PREVIEW / stock_1hour / 2018-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-16.parquet
  size:    1.1 MB
  rows:    49,271
  symbols: 2,877

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
2018-03-16 04:00:00	AAPL	Stock	44.6625	44.6925	44.555	44.685	4120.0
2018-03-16 05:00:00	AAPL	Stock	44.7	44.7	44.655	44.655	836.0
2018-03-16 06:00:00	AAPL	Stock	44.645	44.645	44.6	44.63	3692.0
2018-03-16 07:00:00	AAPL	Stock	44.655	44.6975	44.61	44.61	112632.0
2018-03-16 08:00:00	AAPL	Stock	44.687	44.75	44.575	44.7	301492.0
2018-03-16 09:00:00	AAPL	Stock	44.69	44.78	44.5375	44.6675	30345100.0
2018-03-16 10:00:00	AAPL	Stock	44.6688	44.71	44.5775	44.6518	10559376.0
2018-03-16 11:00:00	AAPL	Stock	44.6512	44.6875	44.405	44.435	10098624.0
2018-03-16 12:00:00	AAPL	Stock	44.44	44.65	44.4225	44.645	7464224.0
2018-03-16 13:00:00	AAPL	Stock	44.645	44.68	44.565	44.6325	5790616.0
2018-03-16 14:00:00	AAPL	Stock	44.635	44.675	44.5475	44.6625	6351576.0
2018-03-16 15:00:00	AAPL	Stock	44.66	44.685	44.4625	44.4725	18092692.0
2018-03-16 16:00:00	AAPL	Stock	44.505	44.625	44.4625	44.4875	41595388.0
2018-03-16 17:00:00	AAPL	Stock	44.4925	44.505	44.4675	44.5025	4158928.0
2018-03-16 18:00:00	AAPL	Stock	44.5025	44.51	44.4675	44.495	33288.0
2018-03-16 19:00:00	AAPL	Stock	44.47	44.56	44.47	44.5375	43896.0
2018-03-16 07:00:00	MSFT	Stock	94.6	94.6	94.36	94.5	5556.0
2018-03-16 08:00:00	MSFT	Stock	94.37	94.45	94.37	94.43	1845.0
2018-03-16 09:00:00	MSFT	Stock	94.41	94.9	94.22	94.9	9688702.0
2018-03-16 10:00:00	MSFT	Stock	94.894	95.38	94.73	94.8	3689220.0
2018-03-16 11:00:00	MSFT	Stock	94.78	94.96	93.92	93.97	2284742.0
2018-03-16 12:00:00	MSFT	Stock	93.97	94.335	93.965	94.176	1966327.0
2018-03-16 13:00:00	MSFT	Stock	94.175	94.25	94.025	94.065	1700374.0
2018-03-16 14:00:00	MSFT	Stock	94.08	94.311	93.96	94.2	2643655.0
2018-03-16 15:00:00	MSFT	Stock	94.2	94.68	94.025	94.49	8758766.0
2018-03-16 16:00:00	MSFT	Stock	94.51	94.73	94.4	94.62	14487753.0
2018-03-16 17:00:00	MSFT	Stock	94.62	94.64	94.61	94.64	3085.0
2018-03-16 18:00:00	MSFT	Stock	94.62	94.64	94.62	94.64	589.0
2018-03-16 19:00:00	MSFT	Stock	94.65	94.65	94.62	94.62	200.0
2018-03-16 06:00:00	NVDA	Stock	6.2545	6.255	6.2545	6.255	20000.0
2018-03-16 07:00:00	NVDA	Stock	6.25	6.2625	6.25	6.255	317280.0
2018-03-16 08:00:00	NVDA	Stock	6.2575	6.2625	6.2475	6.2525	388960.0
2018-03-16 09:00:00	NVDA	Stock	6.2542	6.2685	6.212	6.2334	59790600.0
2018-03-16 10:00:00	NVDA	Stock	6.2353	6.263	6.2155	6.2598	42258680.0
2018-03-16 11:00:00	NVDA	Stock	6.2595	6.2712	6.216	6.2194	33537000.0
2018-03-16 12:00:00	NVDA	Stock	6.2193	6.249	6.215	6.2446	18616720.0
2018-03-16 13:00:00	NVDA	Stock	6.2438	6.255	6.235	6.2405	21846360.0
2018-03-16 14:00:00	NVDA	Stock	6.2412	6.2662	6.2383	6.2611	25491360.0
2018-03-16 15:00:00	NVDA	Stock	6.2613	6.2812	6.254	6.262	53221560.0
2018-03-16 16:00:00	NVDA	Stock	6.262	6.262	6.2125	6.2475	37502720.0
2018-03-16 17:00:00	NVDA	Stock	6.2408	6.2618	6.2405	6.259	300400.0
2018-03-16 18:00:00	NVDA	Stock	6.2582	6.2618	6.2563	6.2618	52440.0
2018-03-16 19:00:00	NVDA	Stock	6.2605	6.2698	6.2605	6.2675	145000.0
2018-03-16 04:00:00	AMZN	Stock	79.25	79.25	79.25	79.25	3000.0
2018-03-16 05:00:00	AMZN	Stock	79.4435	79.5	79.4435	79.5	5780.0
2018-03-16 06:00:00	AMZN	Stock	79.435	79.435	79.25	79.25	9440.0
2018-03-16 07:00:00	AMZN	Stock	79.3195	79.325	79.175	79.175	44440.0
2018-03-16 08:00:00	AMZN	Stock	79.325	79.325	79.15	79.15	100040.0
2018-03-16 09:00:00	AMZN	Stock	79.084	79.472	78.8005	79.311	15688560.0
2018-03-16 10:00:00	AMZN	Stock	79.335	79.425	79.0885	79.1545	6437300.0

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

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