PREVIEW / stock_1hour / 2019-12-10

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-10.parquet
  size:    1.1 MB
  rows:    50,464
  symbols: 2,490

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-12-10 04:00:00	AAPL	Stock	66.4375	66.4375	66.1775	66.2825	34620.0
2019-12-10 05:00:00	AAPL	Stock	66.3225	66.375	66.26	66.295	16552.0
2019-12-10 06:00:00	AAPL	Stock	66.2975	66.3075	66.02	66.225	40256.0
2019-12-10 07:00:00	AAPL	Stock	66.2475	66.2675	66.1	66.16	207812.0
2019-12-10 08:00:00	AAPL	Stock	66.1632	67.31	66.0925	67.1625	2254064.0
2019-12-10 09:00:00	AAPL	Stock	67.1725	67.2075	66.465	66.71	11105660.0
2019-12-10 10:00:00	AAPL	Stock	66.7162	67.485	66.71	67.4525	18087600.0
2019-12-10 11:00:00	AAPL	Stock	67.4575	67.5175	67.2125	67.2765	11712708.0
2019-12-10 12:00:00	AAPL	Stock	67.2775	67.305	67.14	67.2628	5923188.0
2019-12-10 13:00:00	AAPL	Stock	67.2625	67.425	67.2375	67.2625	5099132.0
2019-12-10 14:00:00	AAPL	Stock	67.265	67.3925	67.265	67.3358	5009200.0
2019-12-10 15:00:00	AAPL	Stock	67.3375	67.4375	66.9325	67.155	13543960.0
2019-12-10 16:00:00	AAPL	Stock	67.12	67.1875	67.1025	67.1875	4984552.0
2019-12-10 17:00:00	AAPL	Stock	67.185	67.2025	67.12	67.2	32784.0
2019-12-10 18:00:00	AAPL	Stock	67.2	67.215	67.1625	67.1875	63324.0
2019-12-10 19:00:00	AAPL	Stock	67.1625	67.2	67.04	67.125	47872.0
2019-12-10 04:00:00	MSFT	Stock	150.92	150.92	150.62	150.72	1312.0
2019-12-10 05:00:00	MSFT	Stock	150.7	150.75	150.7	150.75	600.0
2019-12-10 06:00:00	MSFT	Stock	150.8	150.8	150.49	150.7	5951.0
2019-12-10 07:00:00	MSFT	Stock	150.71	150.85	150.5	150.65	10276.0
2019-12-10 08:00:00	MSFT	Stock	150.604	151.72	150.5	151.301	67094.0
2019-12-10 09:00:00	MSFT	Stock	151.4	151.5	150.89	151.27	1861987.0
2019-12-10 10:00:00	MSFT	Stock	151.27	151.89	151.195	151.657	1958755.0
2019-12-10 11:00:00	MSFT	Stock	151.66	151.87	151.13	151.715	1810963.0
2019-12-10 12:00:00	MSFT	Stock	151.718	151.718	151.275	151.43	1194608.0
2019-12-10 13:00:00	MSFT	Stock	151.425	151.6	151.3	151.32	826814.0
2019-12-10 14:00:00	MSFT	Stock	151.325	151.52	151.3	151.475	862481.0
2019-12-10 15:00:00	MSFT	Stock	151.48	151.7	150.765	151.17	3022417.0
2019-12-10 16:00:00	MSFT	Stock	151.13	151.17	151.03	151.15	2824116.0
2019-12-10 17:00:00	MSFT	Stock	151.19	151.247	151.19	151.21	3175.0
2019-12-10 18:00:00	MSFT	Stock	151.25	151.25	151.17	151.23	659.0
2019-12-10 19:00:00	MSFT	Stock	151.12	151.15	151.0	151.0	3125.0
2019-12-10 04:00:00	NVDA	Stock	5.2593	5.2593	5.259	5.259	8000.0
2019-12-10 06:00:00	NVDA	Stock	5.25	5.25	5.25	5.25	31960.0
2019-12-10 07:00:00	NVDA	Stock	5.255	5.2588	5.2475	5.25	258560.0
2019-12-10 08:00:00	NVDA	Stock	5.2462	5.3375	5.2462	5.32	1537600.0
2019-12-10 09:00:00	NVDA	Stock	5.3204	5.337	5.2815	5.3182	22139200.0
2019-12-10 10:00:00	NVDA	Stock	5.3185	5.3875	5.3145	5.3824	49349600.0
2019-12-10 11:00:00	NVDA	Stock	5.3843	5.4015	5.3553	5.3792	38190480.0
2019-12-10 12:00:00	NVDA	Stock	5.38	5.3802	5.3588	5.3732	21940240.0
2019-12-10 13:00:00	NVDA	Stock	5.374	5.3798	5.3638	5.3668	20060800.0
2019-12-10 14:00:00	NVDA	Stock	5.3661	5.3712	5.352	5.364	12263720.0
2019-12-10 15:00:00	NVDA	Stock	5.3642	5.3745	5.3328	5.3498	31088280.0
2019-12-10 16:00:00	NVDA	Stock	5.3495	5.3515	5.3438	5.3515	15573600.0
2019-12-10 17:00:00	NVDA	Stock	5.35	5.3538	5.35	5.3538	48000.0
2019-12-10 18:00:00	NVDA	Stock	5.3512	5.355	5.3493	5.3495	181720.0
2019-12-10 19:00:00	NVDA	Stock	5.3488	5.3495	5.3432	5.3432	136520.0
2019-12-10 04:00:00	AMZN	Stock	87.11	87.11	87.11	87.11	3120.0
2019-12-10 05:00:00	AMZN	Stock	87.2	87.2	87.2	87.2	2000.0
2019-12-10 06:00:00	AMZN	Stock	86.884	87.0145	86.85	87.0145	28080.0

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

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