PREVIEW / stock_1hour / 2016-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-28.parquet
  size:    1.0 MB
  rows:    48,287
  symbols: 3,235

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
2016-09-28 04:00:00	AAPL	Stock	28.275	28.275	28.275	28.275	480.0
2016-09-28 05:00:00	AAPL	Stock	28.3275	28.3275	28.27	28.27	2000.0
2016-09-28 06:00:00	AAPL	Stock	28.27	28.3425	28.27	28.3	29576.0
2016-09-28 07:00:00	AAPL	Stock	28.3125	28.415	28.3125	28.4	93156.0
2016-09-28 08:00:00	AAPL	Stock	28.385	28.4375	28.355	28.41	361644.0
2016-09-28 09:00:00	AAPL	Stock	28.41	28.6125	28.39	28.6075	21033784.0
2016-09-28 10:00:00	AAPL	Stock	28.6088	28.66	28.4362	28.4625	25672692.0
2016-09-28 11:00:00	AAPL	Stock	28.46	28.484	28.3875	28.4525	14619496.0
2016-09-28 12:00:00	AAPL	Stock	28.45	28.4525	28.3575	28.395	8573456.0
2016-09-28 13:00:00	AAPL	Stock	28.393	28.52	28.38	28.475	9045272.0
2016-09-28 14:00:00	AAPL	Stock	28.4775	28.525	28.455	28.5162	10340884.0
2016-09-28 15:00:00	AAPL	Stock	28.5162	28.5375	28.4625	28.4875	13927756.0
2016-09-28 16:00:00	AAPL	Stock	28.4875	28.5075	28.4325	28.47	6307916.0
2016-09-28 17:00:00	AAPL	Stock	28.47	28.4875	28.47	28.48	26044.0
2016-09-28 18:00:00	AAPL	Stock	28.48	28.48	28.4675	28.4675	22036.0
2016-09-28 19:00:00	AAPL	Stock	28.4675	28.4875	28.4575	28.4625	80828.0
2016-09-28 05:00:00	MSFT	Stock	57.9	57.9	57.9	57.9	100.0
2016-09-28 08:00:00	MSFT	Stock	57.9	58.0	57.9	57.95	1172.0
2016-09-28 09:00:00	MSFT	Stock	57.99	58.01	57.67	57.9	2396517.0
2016-09-28 10:00:00	MSFT	Stock	57.9	57.99	57.79	57.825	2124718.0
2016-09-28 11:00:00	MSFT	Stock	57.82	57.925	57.72	57.905	1639036.0
2016-09-28 12:00:00	MSFT	Stock	57.9	57.97	57.8	57.85	1687053.0
2016-09-28 13:00:00	MSFT	Stock	57.86	57.86	57.77	57.8	1882722.0
2016-09-28 14:00:00	MSFT	Stock	57.79	58.06	57.79	58.02	3037210.0
2016-09-28 15:00:00	MSFT	Stock	58.03	58.05	57.91	58.01	3913954.0
2016-09-28 16:00:00	MSFT	Stock	58.03	58.05	58.01	58.05	2446240.0
2016-09-28 17:00:00	MSFT	Stock	58.03	58.03	57.99	57.99	49352.0
2016-09-28 18:00:00	MSFT	Stock	57.95	58.0	57.95	58.0	565.0
2016-09-28 04:00:00	NVDA	Stock	1.655	1.655	1.655	1.655	8000.0
2016-09-28 07:00:00	NVDA	Stock	1.6703	1.6703	1.6663	1.6663	48000.0
2016-09-28 08:00:00	NVDA	Stock	1.668	1.675	1.66	1.6712	595240.0
2016-09-28 09:00:00	NVDA	Stock	1.6715	1.675	1.6483	1.6628	59386800.0
2016-09-28 10:00:00	NVDA	Stock	1.6628	1.6684	1.6535	1.656	39816560.0
2016-09-28 11:00:00	NVDA	Stock	1.6561	1.6665	1.6508	1.6648	51841360.0
2016-09-28 12:00:00	NVDA	Stock	1.6646	1.6652	1.6562	1.657	22052120.0
2016-09-28 13:00:00	NVDA	Stock	1.6571	1.6639	1.6552	1.6608	24881800.0
2016-09-28 14:00:00	NVDA	Stock	1.6609	1.668	1.6605	1.6668	28365520.0
2016-09-28 15:00:00	NVDA	Stock	1.6668	1.6708	1.6605	1.6695	63431720.0
2016-09-28 16:00:00	NVDA	Stock	1.6695	1.67	1.6695	1.6695	803000.0
2016-09-28 17:00:00	NVDA	Stock	1.6695	1.6695	1.6695	1.6695	40000.0
2016-09-28 19:00:00	NVDA	Stock	1.6675	1.6695	1.6675	1.6695	14400.0
2016-09-28 04:00:00	AMZN	Stock	40.8135	40.9345	40.8135	40.9345	10000.0
2016-09-28 05:00:00	AMZN	Stock	40.8	40.8835	40.8	40.8835	8000.0
2016-09-28 06:00:00	AMZN	Stock	40.8735	40.8885	40.8735	40.8885	27000.0
2016-09-28 07:00:00	AMZN	Stock	40.8885	40.901	40.87	40.897	82780.0
2016-09-28 08:00:00	AMZN	Stock	40.8885	40.9	40.725	40.7925	256720.0
2016-09-28 09:00:00	AMZN	Stock	40.803	41.2382	40.7925	41.079	16056780.0
2016-09-28 10:00:00	AMZN	Stock	41.0898	41.262	40.99	41.0726	12513080.0
2016-09-28 11:00:00	AMZN	Stock	41.069	41.225	41.045	41.2198	5508240.0
2016-09-28 12:00:00	AMZN	Stock	41.2137	41.449	41.163	41.422	8433340.0

> showing 50 of 48,287 rows — these rows as CSV

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