PREVIEW / stock_1hour / 2016-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-08.parquet
  size:    1.0 MB
  rows:    48,927
  symbols: 3,260

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-08-08 04:00:00	AAPL	Stock	26.895	26.9125	26.885	26.885	7356.0
2016-08-08 05:00:00	AAPL	Stock	26.89	26.9225	26.89	26.9225	2000.0
2016-08-08 06:00:00	AAPL	Stock	26.89	26.98	26.89	26.95	9396.0
2016-08-08 07:00:00	AAPL	Stock	26.94	26.9725	26.925	26.9375	66200.0
2016-08-08 08:00:00	AAPL	Stock	26.9375	26.97	26.915	26.915	414616.0
2016-08-08 09:00:00	AAPL	Stock	26.925	26.99	26.79	26.8552	21501824.0
2016-08-08 10:00:00	AAPL	Stock	26.8562	26.9325	26.85	26.9238	14933712.0
2016-08-08 11:00:00	AAPL	Stock	26.9248	27.0	26.915	26.9925	12451528.0
2016-08-08 12:00:00	AAPL	Stock	26.9925	27.0238	26.98	27.0025	8943856.0
2016-08-08 13:00:00	AAPL	Stock	27.005	27.045	26.9775	27.0328	7712936.0
2016-08-08 14:00:00	AAPL	Stock	27.0332	27.0332	26.9725	27.0188	8109652.0
2016-08-08 15:00:00	AAPL	Stock	27.0198	27.0925	27.0125	27.0925	15038664.0
2016-08-08 16:00:00	AAPL	Stock	27.0925	27.1075	26.9405	27.0975	15082028.0
2016-08-08 17:00:00	AAPL	Stock	27.0975	27.1025	27.0875	27.0925	322460.0
2016-08-08 18:00:00	AAPL	Stock	27.0925	27.1	27.0875	27.0975	40124.0
2016-08-08 19:00:00	AAPL	Stock	27.0975	27.0975	27.0775	27.0925	30636.0
2016-08-08 04:00:00	MSFT	Stock	58.0	58.0	58.0	58.0	240.0
2016-08-08 07:00:00	MSFT	Stock	58.01	58.16	58.0	58.01	1100.0
2016-08-08 08:00:00	MSFT	Stock	58.01	58.1	58.01	58.1	4410.0
2016-08-08 09:00:00	MSFT	Stock	58.1	58.11	57.81	57.875	2262451.0
2016-08-08 10:00:00	MSFT	Stock	57.88	58.02	57.85	58.0	2875828.0
2016-08-08 11:00:00	MSFT	Stock	58.0	58.06	57.88	57.906	1873550.0
2016-08-08 12:00:00	MSFT	Stock	57.91	57.95	57.78	57.86	1313005.0
2016-08-08 13:00:00	MSFT	Stock	57.851	57.92	57.81	57.915	1028900.0
2016-08-08 14:00:00	MSFT	Stock	57.91	57.99	57.82	57.95	2213983.0
2016-08-08 15:00:00	MSFT	Stock	57.955	58.085	57.95	58.06	4485362.0
2016-08-08 16:00:00	MSFT	Stock	58.06	58.06	57.97	58.0	2399533.0
2016-08-08 17:00:00	MSFT	Stock	58.06	58.06	58.0	58.05	154861.0
2016-08-08 18:00:00	MSFT	Stock	58.05	58.05	58.05	58.05	635.0
2016-08-08 19:00:00	MSFT	Stock	58.05	58.05	58.05	58.05	700.0
2016-08-08 04:00:00	NVDA	Stock	1.455	1.455	1.455	1.455	8000.0
2016-08-08 06:00:00	NVDA	Stock	1.4645	1.4645	1.464	1.4645	64000.0
2016-08-08 07:00:00	NVDA	Stock	1.464	1.4662	1.4625	1.4662	53120.0
2016-08-08 08:00:00	NVDA	Stock	1.4625	1.4738	1.4625	1.47	396760.0
2016-08-08 09:00:00	NVDA	Stock	1.47	1.481	1.4558	1.4595	50663880.0
2016-08-08 10:00:00	NVDA	Stock	1.4596	1.461	1.453	1.4568	40324760.0
2016-08-08 11:00:00	NVDA	Stock	1.4569	1.4588	1.455	1.4575	27403680.0
2016-08-08 12:00:00	NVDA	Stock	1.4575	1.4595	1.4542	1.4582	23053720.0
2016-08-08 13:00:00	NVDA	Stock	1.4581	1.4633	1.4565	1.4605	24896560.0
2016-08-08 14:00:00	NVDA	Stock	1.4606	1.4625	1.4582	1.4602	27382520.0
2016-08-08 15:00:00	NVDA	Stock	1.4602	1.4688	1.46	1.4685	60982520.0
2016-08-08 16:00:00	NVDA	Stock	1.4685	1.469	1.468	1.469	10295400.0
2016-08-08 17:00:00	NVDA	Stock	1.4693	1.471	1.4693	1.471	97200.0
2016-08-08 18:00:00	NVDA	Stock	1.4725	1.4725	1.4695	1.47	63840.0
2016-08-08 19:00:00	NVDA	Stock	1.4705	1.4713	1.4693	1.4713	152640.0
2016-08-08 04:00:00	AMZN	Stock	38.335	38.335	38.335	38.335	2000.0
2016-08-08 05:00:00	AMZN	Stock	38.4325	38.4325	38.4325	38.4325	6000.0
2016-08-08 06:00:00	AMZN	Stock	38.45	38.4895	38.45	38.4895	10000.0
2016-08-08 07:00:00	AMZN	Stock	38.417	38.417	38.36	38.3655	41440.0
2016-08-08 08:00:00	AMZN	Stock	38.361	38.4445	38.34	38.3555	215320.0

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

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