PREVIEW / stock_1hour / 2017-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-01.parquet
  size:    1.0 MB
  rows:    47,241
  symbols: 2,964

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
2017-09-01 04:00:00	AAPL	Stock	41.095	41.095	41.095	41.095	4000.0
2017-09-01 05:00:00	AAPL	Stock	41.095	41.095	41.095	41.095	2976.0
2017-09-01 06:00:00	AAPL	Stock	41.11	41.125	41.105	41.12	14836.0
2017-09-01 07:00:00	AAPL	Stock	41.1125	41.175	41.1125	41.165	95788.0
2017-09-01 08:00:00	AAPL	Stock	41.15	41.195	41.1125	41.1375	447604.0
2017-09-01 09:00:00	AAPL	Stock	41.1425	41.235	40.9875	40.9975	13846040.0
2017-09-01 10:00:00	AAPL	Stock	40.99	41.06	40.9525	41.0275	11366944.0
2017-09-01 11:00:00	AAPL	Stock	41.025	41.095	40.9875	41.046	7277556.0
2017-09-01 12:00:00	AAPL	Stock	41.046	41.0575	40.9825	40.9875	4361136.0
2017-09-01 13:00:00	AAPL	Stock	40.994	41.0175	40.9075	40.9565	5511744.0
2017-09-01 14:00:00	AAPL	Stock	40.955	40.9985	40.953	40.98	4709116.0
2017-09-01 15:00:00	AAPL	Stock	40.98	41.0325	40.9725	41.01	9442620.0
2017-09-01 16:00:00	AAPL	Stock	41.0025	41.02	40.985	41.0125	3150152.0
2017-09-01 17:00:00	AAPL	Stock	41.0125	41.0175	40.9925	41.005	41872.0
2017-09-01 18:00:00	AAPL	Stock	41.0	41.0	40.9875	40.99	18236.0
2017-09-01 19:00:00	AAPL	Stock	40.9925	41.01	40.9925	41.01	17824.0
2017-09-01 04:00:00	MSFT	Stock	74.83	74.9	74.83	74.9	1064.0
2017-09-01 05:00:00	MSFT	Stock	74.78	74.78	74.78	74.78	200.0
2017-09-01 07:00:00	MSFT	Stock	74.8	74.85	74.7	74.85	7715.0
2017-09-01 08:00:00	MSFT	Stock	74.89	74.98	74.77	74.84	18205.0
2017-09-01 09:00:00	MSFT	Stock	74.84	74.89	74.162	74.23	2847102.0
2017-09-01 10:00:00	MSFT	Stock	74.25	74.26	73.81	73.81	2757264.0
2017-09-01 11:00:00	MSFT	Stock	73.81	73.94	73.64	73.869	2378036.0
2017-09-01 12:00:00	MSFT	Stock	73.865	73.92	73.671	73.745	1648735.0
2017-09-01 13:00:00	MSFT	Stock	73.745	73.92	73.7	73.92	1440029.0
2017-09-01 14:00:00	MSFT	Stock	73.915	74.16	73.91	74.13	2180777.0
2017-09-01 15:00:00	MSFT	Stock	74.13	74.13	73.91	73.92	3403886.0
2017-09-01 16:00:00	MSFT	Stock	73.92	74.0	73.92	73.99	2916767.0
2017-09-01 17:00:00	MSFT	Stock	74.0	74.0	73.95	74.0	4535.0
2017-09-01 18:00:00	MSFT	Stock	73.95	73.96	73.95	73.96	634.0
2017-09-01 19:00:00	MSFT	Stock	73.94	73.94	73.94	73.94	2000.0
2017-09-01 04:00:00	NVDA	Stock	4.2425	4.2425	4.2425	4.2425	10280.0
2017-09-01 05:00:00	NVDA	Stock	4.2495	4.2495	4.2495	4.2495	4000.0
2017-09-01 06:00:00	NVDA	Stock	4.2475	4.255	4.2475	4.255	62000.0
2017-09-01 07:00:00	NVDA	Stock	4.2462	4.26	4.2438	4.2575	762840.0
2017-09-01 08:00:00	NVDA	Stock	4.2575	4.2685	4.2462	4.263	3200160.0
2017-09-01 09:00:00	NVDA	Stock	4.262	4.2975	4.2475	4.2708	113080080.0
2017-09-01 10:00:00	NVDA	Stock	4.2721	4.2868	4.249	4.2812	90567200.0
2017-09-01 11:00:00	NVDA	Stock	4.2808	4.2868	4.269	4.278	46231200.0
2017-09-01 12:00:00	NVDA	Stock	4.2786	4.2855	4.2698	4.2738	32795400.0
2017-09-01 13:00:00	NVDA	Stock	4.2736	4.279	4.248	4.2563	45458560.0
2017-09-01 14:00:00	NVDA	Stock	4.2565	4.2593	4.24	4.2545	44248880.0
2017-09-01 15:00:00	NVDA	Stock	4.2548	4.264	4.2511	4.2597	55672800.0
2017-09-01 16:00:00	NVDA	Stock	4.2615	4.2739	4.2465	4.2508	4685120.0
2017-09-01 17:00:00	NVDA	Stock	4.2513	4.2513	4.25	4.2502	470520.0
2017-09-01 18:00:00	NVDA	Stock	4.2525	4.2578	4.25	4.2565	78640.0
2017-09-01 19:00:00	NVDA	Stock	4.2575	4.2575	4.2502	4.2558	94000.0
2017-09-01 04:00:00	AMZN	Stock	49.1315	49.15	49.1315	49.15	12400.0
2017-09-01 06:00:00	AMZN	Stock	49.18	49.1805	49.175	49.1805	31360.0
2017-09-01 07:00:00	AMZN	Stock	49.2	49.2425	49.2	49.2385	35160.0

> showing 50 of 47,241 rows — these rows as CSV

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