PREVIEW / stock_1hour / 2017-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-27.parquet
  size:    1.1 MB
  rows:    50,388
  symbols: 2,967

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-27 04:00:00	AAPL	Stock	38.4275	38.56	38.4275	38.56	1200.0
2017-09-27 05:00:00	AAPL	Stock	38.49	38.55	38.49	38.52	10332.0
2017-09-27 06:00:00	AAPL	Stock	38.465	38.575	38.4625	38.575	64692.0
2017-09-27 07:00:00	AAPL	Stock	38.56	38.6625	38.275	38.335	457136.0
2017-09-27 08:00:00	AAPL	Stock	38.5375	38.6225	38.3375	38.405	605732.0
2017-09-27 09:00:00	AAPL	Stock	38.39	38.6675	38.35	38.6025	20929312.0
2017-09-27 10:00:00	AAPL	Stock	38.605	38.655	38.465	38.525	15869960.0
2017-09-27 11:00:00	AAPL	Stock	38.525	38.575	38.44	38.48	9766164.0
2017-09-27 12:00:00	AAPL	Stock	38.4825	38.55	38.385	38.535	7247752.0
2017-09-27 13:00:00	AAPL	Stock	38.535	38.555	38.46	38.5525	6052572.0
2017-09-27 14:00:00	AAPL	Stock	38.555	38.6798	38.554	38.5725	8760232.0
2017-09-27 15:00:00	AAPL	Stock	38.5772	38.67	38.535	38.55	13272672.0
2017-09-27 16:00:00	AAPL	Stock	38.555	38.5875	38.525	38.525	8742344.0
2017-09-27 17:00:00	AAPL	Stock	38.525	38.545	38.5225	38.5325	17712.0
2017-09-27 18:00:00	AAPL	Stock	38.53	38.5575	38.5	38.5125	349440.0
2017-09-27 19:00:00	AAPL	Stock	38.525	38.525	38.5125	38.515	41996.0
2017-09-27 05:00:00	MSFT	Stock	73.99	73.99	73.99	73.99	100.0
2017-09-27 06:00:00	MSFT	Stock	73.56	73.56	73.56	73.56	4880.0
2017-09-27 07:00:00	MSFT	Stock	73.49	73.6	73.49	73.6	1597.0
2017-09-27 08:00:00	MSFT	Stock	73.55	73.59	73.5	73.55	1916.0
2017-09-27 09:00:00	MSFT	Stock	73.59	73.9	73.5	73.64	1596654.0
2017-09-27 10:00:00	MSFT	Stock	73.64	73.7	73.17	73.37	2782566.0
2017-09-27 11:00:00	MSFT	Stock	73.37	73.59	73.29	73.45	1571158.0
2017-09-27 12:00:00	MSFT	Stock	73.445	73.6	73.35	73.595	1277739.0
2017-09-27 13:00:00	MSFT	Stock	73.6	73.825	73.56	73.78	1684023.0
2017-09-27 14:00:00	MSFT	Stock	73.78	74.11	73.75	74.0	2035146.0
2017-09-27 15:00:00	MSFT	Stock	74.01	74.17	73.81	73.85	3517313.0
2017-09-27 16:00:00	MSFT	Stock	73.85	73.95	73.799	73.85	3090672.0
2017-09-27 17:00:00	MSFT	Stock	73.89	73.9	73.81	73.81	816.0
2017-09-27 18:00:00	MSFT	Stock	73.8	73.85	73.8	73.8	1152.0
2017-09-27 19:00:00	MSFT	Stock	73.85	73.95	73.85	73.95	1228.0
2017-09-27 04:00:00	NVDA	Stock	4.3175	4.345	4.3175	4.345	41000.0
2017-09-27 05:00:00	NVDA	Stock	4.3422	4.3422	4.335	4.335	48640.0
2017-09-27 06:00:00	NVDA	Stock	4.3303	4.3575	4.3303	4.3575	205640.0
2017-09-27 07:00:00	NVDA	Stock	4.3498	4.3708	4.3438	4.3532	735280.0
2017-09-27 08:00:00	NVDA	Stock	4.3562	4.372	4.3438	4.3562	2807960.0
2017-09-27 09:00:00	NVDA	Stock	4.356	4.4038	4.3342	4.34	147568000.0
2017-09-27 10:00:00	NVDA	Stock	4.3391	4.3718	4.3188	4.35	172937680.0
2017-09-27 11:00:00	NVDA	Stock	4.35	4.3612	4.3338	4.3445	74799040.0
2017-09-27 12:00:00	NVDA	Stock	4.3458	4.3462	4.3282	4.3395	36936080.0
2017-09-27 13:00:00	NVDA	Stock	4.3402	4.3557	4.322	4.3538	40258400.0
2017-09-27 14:00:00	NVDA	Stock	4.3542	4.3692	4.3512	4.363	47809200.0
2017-09-27 15:00:00	NVDA	Stock	4.3635	4.4068	4.3617	4.3932	126182240.0
2017-09-27 16:00:00	NVDA	Stock	4.3932	4.3998	4.3664	4.3925	18151800.0
2017-09-27 17:00:00	NVDA	Stock	4.3925	4.3975	4.3925	4.3955	614800.0
2017-09-27 18:00:00	NVDA	Stock	4.395	4.4	4.3925	4.3938	2174280.0
2017-09-27 19:00:00	NVDA	Stock	4.3925	4.399	4.39	4.399	594960.0
2017-09-27 05:00:00	AMZN	Stock	47.1695	47.181	47.1695	47.181	4000.0
2017-09-27 06:00:00	AMZN	Stock	47.2015	47.2015	47.2	47.2	5000.0
2017-09-27 07:00:00	AMZN	Stock	47.2495	47.3	47.225	47.2995	30580.0

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

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