https://fr.finance.yahoo.com/quote/MSFT
INSERT INTO brse_cours__nasdaq_3(brse_stock_id, brse_ticker, brse_market, brse_symbol, brse_date, brse_date_time, brse_price, brse_currency, brse_variation)
VALUES ('14','MSFT','nasdaq','MSFT',NOW(),NOW(),'406.48','USD','2.17')
ON DUPLICATE KEY UPDATE brse_date = NOW(), brse_date_time = NOW(), brse_ticker = 'MSFT', brse_price = '406.48', brse_variation = '2.17';
UPDATE brse_stock
SET bs_last_price = '406.48', bs_last_variation = '2.17', bs_currency = 'USD', bs_last_price_update = NOW() ,bs_bna = '11.54' ,bs_per = '35.22' ,bs_capitalisation = '3,021T' ,bs_last_dividende = '3.00' ,bs_dividend_yield = '0.75'
WHERE bs_symbol_yahoo = 'MSFT'
https://fr.finance.yahoo.com/quote/MC.PA
INSERT INTO brse_cours__euronext_3(brse_stock_id, brse_ticker, brse_market, brse_symbol, brse_date, brse_date_time, brse_price, brse_currency, brse_variation)
VALUES ('44','MC','euronext','MC.PA',NOW(),NOW(),'782','EUR','1.96')
ON DUPLICATE KEY UPDATE brse_date = NOW(), brse_date_time = NOW(), brse_ticker = 'MC', brse_price = '782', brse_variation = '1.96';
UPDATE brse_stock
SET bs_last_price = '782', bs_last_variation = '1.96', bs_currency = 'EUR', bs_last_price_update = NOW() ,bs_bna = '30.30' ,bs_per = '25.81' ,bs_capitalisation = '390,643B' ,bs_last_dividende = '13.00' ,bs_dividend_yield = '1.69'
WHERE bs_symbol_yahoo = 'MC.PA'
https://fr.finance.yahoo.com/quote/KO
INSERT INTO brse_cours__nyse_7(brse_stock_id, brse_ticker, brse_market, brse_symbol, brse_date, brse_date_time, brse_price, brse_currency, brse_variation)
VALUES ('1317','KO','nyse','KO',NOW(),NOW(),'62.19','USD','0.32')
ON DUPLICATE KEY UPDATE brse_date = NOW(), brse_date_time = NOW(), brse_ticker = 'KO', brse_price = '62.19', brse_variation = '0.32';
UPDATE brse_stock
SET bs_last_price = '62.19', bs_last_variation = '0.32', bs_currency = 'USD', bs_last_price_update = NOW() ,bs_bna = '2.49' ,bs_per = '24.98' ,bs_capitalisation = '267,914B' ,bs_last_dividende = '1.94' ,bs_dividend_yield = '3.13'
WHERE bs_symbol_yahoo = 'KO'
https://fr.finance.yahoo.com/quote/BAC
INSERT INTO brse_cours__nyse_7(brse_stock_id, brse_ticker, brse_market, brse_symbol, brse_date, brse_date_time, brse_price, brse_currency, brse_variation)
VALUES ('1398','BAC','nyse','BAC',NOW(),NOW(),'37.255','USD','1.02')
ON DUPLICATE KEY UPDATE brse_date = NOW(), brse_date_time = NOW(), brse_ticker = 'BAC', brse_price = '37.255', brse_variation = '1.02';
UPDATE brse_stock
SET bs_last_price = '37.255', bs_last_variation = '1.02', bs_currency = 'USD', bs_last_price_update = NOW() ,bs_bna = '2.90' ,bs_per = '12.85' ,bs_capitalisation = '291,348B' ,bs_last_dividende = '0.96' ,bs_dividend_yield = '2.60'
WHERE bs_symbol_yahoo = 'BAC'
https://fr.finance.yahoo.com/quote/STNE
INSERT INTO brse_cours__nasdaq_7(brse_stock_id, brse_ticker, brse_market, brse_symbol, brse_date, brse_date_time, brse_price, brse_currency, brse_variation)
VALUES ('15017','STNE','nasdaq','STNE',NOW(),NOW(),'16.86','USD','3.63')
ON DUPLICATE KEY UPDATE brse_date = NOW(), brse_date_time = NOW(), brse_ticker = 'STNE', brse_price = '16.86', brse_variation = '3.63';
UPDATE brse_stock
SET bs_last_price = '16.86', bs_last_variation = '3.63', bs_currency = 'USD', bs_last_price_update = NOW() ,bs_bna = '0.91' ,bs_per = '18.53' ,bs_capitalisation = '5,21B'
WHERE bs_symbol_yahoo = 'STNE'
https://fr.finance.yahoo.com/quote/TSLA
INSERT INTO brse_cours__nasdaq_5(brse_stock_id, brse_ticker, brse_market, brse_symbol, brse_date, brse_date_time, brse_price, brse_currency, brse_variation)
VALUES ('15','TSLA','nasdaq','TSLA',NOW(),NOW(),'181.5594','USD','0.86')
ON DUPLICATE KEY UPDATE brse_date = NOW(), brse_date_time = NOW(), brse_ticker = 'TSLA', brse_price = '181.5594', brse_variation = '0.86';
UPDATE brse_stock
SET bs_last_price = '181.5594', bs_last_variation = '0.86', bs_currency = 'USD', bs_last_price_update = NOW() ,bs_bna = '3.91' ,bs_per = '46.43' ,bs_capitalisation = '579,029B'
WHERE bs_symbol_yahoo = 'TSLA'
https://fr.finance.yahoo.com/quote/BRK-B
INSERT INTO brse_cours__nyse_3(brse_stock_id, brse_ticker, brse_market, brse_symbol, brse_date, brse_date_time, brse_price, brse_currency, brse_variation)
VALUES ('5734','BRK.B','nyse','BRK-B',NOW(),NOW(),'403.18','USD','0.64')
ON DUPLICATE KEY UPDATE brse_date = NOW(), brse_date_time = NOW(), brse_ticker = 'BRK.B', brse_price = '403.18', brse_variation = '0.64';
UPDATE brse_stock
SET bs_last_price = '403.18', bs_last_variation = '0.64', bs_currency = 'USD', bs_last_price_update = NOW() ,bs_bna = '44.27' ,bs_per = '9.11' ,bs_capitalisation = '872,59B'
WHERE bs_symbol_yahoo = 'BRK-B'
https://fr.finance.yahoo.com/quote/AAPL
INSERT INTO brse_cours__nasdaq_5(brse_stock_id, brse_ticker, brse_market, brse_symbol, brse_date, brse_date_time, brse_price, brse_currency, brse_variation)
VALUES ('6','AAPL','nasdaq','AAPL',NOW(),NOW(),'185.8036','USD','7.38')
ON DUPLICATE KEY UPDATE brse_date = NOW(), brse_date_time = NOW(), brse_ticker = 'AAPL', brse_price = '185.8036', brse_variation = '7.38';
UPDATE brse_stock
SET bs_last_price = '185.8036', bs_last_variation = '7.38', bs_currency = 'USD', bs_last_price_update = NOW() ,bs_bna = '6.44' ,bs_per = '28.85' ,bs_capitalisation = '2,869T' ,bs_last_dividende = '0.96' ,bs_dividend_yield = '0.55'
WHERE bs_symbol_yahoo = 'AAPL'
