PREVIEW / stock_1hour / 2019-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-02.parquet
  size:    1.1 MB
  rows:    49,553
  symbols: 2,610

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2019-07-02 04:00:00	AAPL	Stock	50.3075	50.3075	50.205	50.205	5564.0
2019-07-02 05:00:00	AAPL	Stock	50.25	50.25	50.2175	50.2175	14016.0
2019-07-02 06:00:00	AAPL	Stock	50.19	50.2	50.125	50.2	4200.0
2019-07-02 07:00:00	AAPL	Stock	50.245	50.3	50.2025	50.25	71024.0
2019-07-02 08:00:00	AAPL	Stock	50.25	50.31	50.2	50.275	84548.0
2019-07-02 09:00:00	AAPL	Stock	50.275	50.665	50.275	50.6125	10073476.0
2019-07-02 10:00:00	AAPL	Stock	50.6175	50.783	50.53	50.7125	10515640.0
2019-07-02 11:00:00	AAPL	Stock	50.7088	50.74	50.4825	50.5775	6360240.0
2019-07-02 12:00:00	AAPL	Stock	50.5785	50.65	50.4225	50.505	7020224.0
2019-07-02 13:00:00	AAPL	Stock	50.505	50.55	50.4425	50.5125	5117232.0
2019-07-02 14:00:00	AAPL	Stock	50.5125	50.5625	50.4815	50.5475	5208620.0
2019-07-02 15:00:00	AAPL	Stock	50.5475	50.695	50.545	50.6775	10458880.0
2019-07-02 16:00:00	AAPL	Stock	50.6825	50.9925	50.63	50.6825	3004320.0
2019-07-02 17:00:00	AAPL	Stock	50.725	50.7425	50.6825	50.7425	82456.0
2019-07-02 18:00:00	AAPL	Stock	50.7425	50.7425	50.7125	50.725	22480.0
2019-07-02 19:00:00	AAPL	Stock	50.7175	50.7375	50.6825	50.7375	46396.0
2019-07-02 04:00:00	MSFT	Stock	135.75	135.75	135.27	135.34	1736.0
2019-07-02 05:00:00	MSFT	Stock	135.43	135.43	135.43	135.43	408.0
2019-07-02 07:00:00	MSFT	Stock	135.58	135.61	135.46	135.61	1951.0
2019-07-02 08:00:00	MSFT	Stock	135.5	135.85	135.41	135.6	9750.0
2019-07-02 09:00:00	MSFT	Stock	135.68	136.12	135.34	135.75	1621702.0
2019-07-02 10:00:00	MSFT	Stock	135.75	136.16	135.65	136.06	1822205.0
2019-07-02 11:00:00	MSFT	Stock	136.07	136.14	135.8	135.96	1427107.0
2019-07-02 12:00:00	MSFT	Stock	135.94	136.07	135.62	135.9	1157671.0
2019-07-02 13:00:00	MSFT	Stock	135.905	136.17	135.8	136.095	902928.0
2019-07-02 14:00:00	MSFT	Stock	136.093	136.17	136.01	136.07	1060022.0
2019-07-02 15:00:00	MSFT	Stock	136.07	136.59	135.99	136.57	2772292.0
2019-07-02 16:00:00	MSFT	Stock	136.58	137.0	136.41	136.58	2046753.0
2019-07-02 17:00:00	MSFT	Stock	136.86	136.86	136.58	136.58	15198.0
2019-07-02 18:00:00	MSFT	Stock	136.7	136.86	136.7	136.78	4474.0
2019-07-02 19:00:00	MSFT	Stock	136.74	136.8	136.64	136.75	5998.0
2019-07-02 04:00:00	NVDA	Stock	4.17	4.17	4.15	4.15	151480.0
2019-07-02 05:00:00	NVDA	Stock	4.1505	4.1505	4.15	4.15	40120.0
2019-07-02 06:00:00	NVDA	Stock	4.1425	4.15	4.135	4.15	86520.0
2019-07-02 07:00:00	NVDA	Stock	4.154	4.1618	4.1452	4.155	314280.0
2019-07-02 08:00:00	NVDA	Stock	4.1548	4.1575	4.1432	4.1518	1124400.0
2019-07-02 09:00:00	NVDA	Stock	4.1518	4.1587	4.1057	4.1112	67340720.0
2019-07-02 10:00:00	NVDA	Stock	4.1119	4.1233	4.0815	4.101	71117960.0
2019-07-02 11:00:00	NVDA	Stock	4.1002	4.1212	4.0905	4.0922	41347160.0
2019-07-02 12:00:00	NVDA	Stock	4.092	4.099	4.0675	4.0729	39476680.0
2019-07-02 13:00:00	NVDA	Stock	4.0733	4.0798	4.0602	4.0623	35872480.0
2019-07-02 14:00:00	NVDA	Stock	4.0619	4.0728	4.0498	4.0565	45018560.0
2019-07-02 15:00:00	NVDA	Stock	4.0565	4.062	4.0425	4.0555	70688600.0
2019-07-02 16:00:00	NVDA	Stock	4.0558	4.0916	4.0475	4.0558	6639520.0
2019-07-02 17:00:00	NVDA	Stock	4.0568	4.06	4.0528	4.0562	548720.0
2019-07-02 18:00:00	NVDA	Stock	4.0562	4.0685	4.0562	4.0598	682960.0
2019-07-02 19:00:00	NVDA	Stock	4.066	4.0725	4.0612	4.07	815440.0
2019-07-02 04:00:00	AMZN	Stock	96.045	96.045	96.045	96.045	2020.0
2019-07-02 05:00:00	AMZN	Stock	95.8	95.8	95.8	95.8	2000.0
2019-07-02 06:00:00	AMZN	Stock	95.815	95.815	95.815	95.815	3300.0

> showing 50 of 49,553 rows — these rows as CSV

> unlock the full archive -- $79 one-time