PREVIEW / stock_1hour / 2019-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-18.parquet
  size:    1.1 MB
  rows:    50,240
  symbols: 2,609

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-06-18 04:00:00	AAPL	Stock	48.4725	48.8425	48.4725	48.775	16924.0
2019-06-18 05:00:00	AAPL	Stock	48.8	48.835	48.7825	48.7825	21168.0
2019-06-18 06:00:00	AAPL	Stock	48.775	48.9225	48.7175	48.8875	51320.0
2019-06-18 07:00:00	AAPL	Stock	48.8075	48.975	48.7725	48.9125	197920.0
2019-06-18 08:00:00	AAPL	Stock	48.775	49.0125	48.7725	48.95	273380.0
2019-06-18 09:00:00	AAPL	Stock	48.9575	49.96	48.8025	49.765	23227268.0
2019-06-18 10:00:00	AAPL	Stock	49.765	50.0725	49.74	50.0018	20967988.0
2019-06-18 11:00:00	AAPL	Stock	50.0025	50.0675	49.5875	49.63	12524948.0
2019-06-18 12:00:00	AAPL	Stock	49.63	49.7725	49.6	49.69	5442584.0
2019-06-18 13:00:00	AAPL	Stock	49.6875	49.6875	49.515	49.64	4794992.0
2019-06-18 14:00:00	AAPL	Stock	49.64	49.7575	49.64	49.7325	4667760.0
2019-06-18 15:00:00	AAPL	Stock	49.73	49.7475	49.475	49.625	11517388.0
2019-06-18 16:00:00	AAPL	Stock	49.6125	49.8625	49.5775	49.7375	7888140.0
2019-06-18 17:00:00	AAPL	Stock	49.7475	49.7475	49.65	49.6625	33476.0
2019-06-18 18:00:00	AAPL	Stock	49.6625	49.695	49.6525	49.68	40088.0
2019-06-18 19:00:00	AAPL	Stock	49.695	49.825	49.6875	49.825	58764.0
2019-06-18 04:00:00	MSFT	Stock	133.28	133.59	133.28	133.59	300.0
2019-06-18 05:00:00	MSFT	Stock	133.88	133.88	133.61	133.61	200.0
2019-06-18 06:00:00	MSFT	Stock	133.78	134.09	133.78	134.09	1998.0
2019-06-18 07:00:00	MSFT	Stock	133.97	134.2	133.85	134.14	34668.0
2019-06-18 08:00:00	MSFT	Stock	134.038	134.25	133.18	134.12	40790.0
2019-06-18 09:00:00	MSFT	Stock	134.118	135.0	133.57	134.72	3596628.0
2019-06-18 10:00:00	MSFT	Stock	134.72	135.163	134.535	135.045	3578922.0
2019-06-18 11:00:00	MSFT	Stock	135.04	135.15	134.44	134.63	2628482.0
2019-06-18 12:00:00	MSFT	Stock	134.625	134.8	134.18	134.56	1829740.0
2019-06-18 13:00:00	MSFT	Stock	134.55	134.73	134.29	134.64	1399895.0
2019-06-18 14:00:00	MSFT	Stock	134.64	135.15	134.64	135.0	2016792.0
2019-06-18 15:00:00	MSFT	Stock	135.0	135.24	134.84	135.18	4146626.0
2019-06-18 16:00:00	MSFT	Stock	135.18	135.29	134.585	135.26	2871733.0
2019-06-18 17:00:00	MSFT	Stock	135.2	135.3	135.11	135.3	8820.0
2019-06-18 18:00:00	MSFT	Stock	135.3	135.37	135.22	135.37	6760.0
2019-06-18 19:00:00	MSFT	Stock	135.33	135.5	135.33	135.5	4312.0
2019-06-18 04:00:00	NVDA	Stock	3.6372	3.6513	3.634	3.6483	85280.0
2019-06-18 05:00:00	NVDA	Stock	3.6508	3.6508	3.65	3.65	32000.0
2019-06-18 06:00:00	NVDA	Stock	3.6505	3.6768	3.65	3.6752	127720.0
2019-06-18 07:00:00	NVDA	Stock	3.6848	3.6898	3.665	3.6812	646760.0
2019-06-18 08:00:00	NVDA	Stock	3.67	3.6962	3.6645	3.6875	1712560.0
2019-06-18 09:00:00	NVDA	Stock	3.6875	3.8138	3.6765	3.7985	99136640.0
2019-06-18 10:00:00	NVDA	Stock	3.7979	3.8778	3.7918	3.8668	122274880.0
2019-06-18 11:00:00	NVDA	Stock	3.866	3.8735	3.8285	3.8355	82099880.0
2019-06-18 12:00:00	NVDA	Stock	3.835	3.8408	3.816	3.8328	43875160.0
2019-06-18 13:00:00	NVDA	Stock	3.8322	3.8398	3.8145	3.8341	33479960.0
2019-06-18 14:00:00	NVDA	Stock	3.8347	3.8605	3.8343	3.8498	41077760.0
2019-06-18 15:00:00	NVDA	Stock	3.8498	3.851	3.8125	3.8222	62657960.0
2019-06-18 16:00:00	NVDA	Stock	3.822	3.8298	3.82	3.8252	30008800.0
2019-06-18 17:00:00	NVDA	Stock	3.8232	3.8322	3.8232	3.83	242800.0
2019-06-18 18:00:00	NVDA	Stock	3.83	3.8392	3.8268	3.835	241960.0
2019-06-18 19:00:00	NVDA	Stock	3.8338	3.8595	3.8328	3.8562	974840.0
2019-06-18 04:00:00	AMZN	Stock	94.91	94.91	94.902	94.902	4000.0
2019-06-18 05:00:00	AMZN	Stock	95.0815	95.0815	95.0815	95.0815	10180.0

> showing 50 of 50,240 rows — these rows as CSV

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