PREVIEW / stock_1hour / 2016-03-11

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-11.parquet
  size:    1.0 MB
  rows:    48,557
  symbols: 3,342

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-03-11 04:00:00	AAPL	Stock	25.5075	25.5625	25.5	25.5	2780.0
2016-03-11 05:00:00	AAPL	Stock	25.505	25.59	25.505	25.55	31028.0
2016-03-11 06:00:00	AAPL	Stock	25.55	25.5725	25.5	25.5	29604.0
2016-03-11 07:00:00	AAPL	Stock	25.4975	25.5175	25.4675	25.48	131116.0
2016-03-11 08:00:00	AAPL	Stock	25.4975	25.5625	25.44	25.4525	271876.0
2016-03-11 09:00:00	AAPL	Stock	25.4475	25.5625	25.2925	25.4675	14322292.0
2016-03-11 10:00:00	AAPL	Stock	25.47	25.545	25.375	25.49	15529988.0
2016-03-11 11:00:00	AAPL	Stock	25.4925	25.5075	25.4025	25.4515	10362968.0
2016-03-11 12:00:00	AAPL	Stock	25.4525	25.485	25.4075	25.455	8942704.0
2016-03-11 13:00:00	AAPL	Stock	25.454	25.485	25.4125	25.4675	7799444.0
2016-03-11 14:00:00	AAPL	Stock	25.47	25.515	25.4525	25.4925	7943704.0
2016-03-11 15:00:00	AAPL	Stock	25.4938	25.57	25.4828	25.5625	24582796.0
2016-03-11 16:00:00	AAPL	Stock	25.565	25.565	25.4735	25.5475	9980848.0
2016-03-11 17:00:00	AAPL	Stock	25.54	25.5625	25.5375	25.555	46656.0
2016-03-11 18:00:00	AAPL	Stock	25.555	25.555	25.5375	25.54	31328.0
2016-03-11 19:00:00	AAPL	Stock	25.5425	25.555	25.5425	25.555	21652.0
2016-03-11 05:00:00	MSFT	Stock	52.6	52.6	52.6	52.6	148.0
2016-03-11 07:00:00	MSFT	Stock	52.5	52.59	52.48	52.51	9394.0
2016-03-11 08:00:00	MSFT	Stock	52.54	52.63	52.47	52.55	22410.0
2016-03-11 09:00:00	MSFT	Stock	52.47	53.0	52.46	52.655	4641672.0
2016-03-11 10:00:00	MSFT	Stock	52.655	52.84	52.38	52.77	5174823.0
2016-03-11 11:00:00	MSFT	Stock	52.77	52.93	52.71	52.86	3299683.0
2016-03-11 12:00:00	MSFT	Stock	52.86	52.92	52.76	52.799	2406785.0
2016-03-11 13:00:00	MSFT	Stock	52.79	52.85	52.625	52.8	1779613.0
2016-03-11 14:00:00	MSFT	Stock	52.8	52.895	52.72	52.73	2287485.0
2016-03-11 15:00:00	MSFT	Stock	52.725	53.07	52.7	53.07	7171493.0
2016-03-11 16:00:00	MSFT	Stock	53.05	53.07	52.828	52.99	3692575.0
2016-03-11 17:00:00	MSFT	Stock	53.0	53.07	52.99	53.04	55732.0
2016-03-11 18:00:00	MSFT	Stock	53.04	53.08	53.0	53.0	2300.0
2016-03-11 19:00:00	MSFT	Stock	53.07	53.07	53.06	53.06	3656.0
2016-03-11 09:00:00	NVDA	Stock	0.803	0.8038	0.7942	0.8015	28475680.0
2016-03-11 10:00:00	NVDA	Stock	0.8015	0.8024	0.7958	0.8001	31825840.0
2016-03-11 11:00:00	NVDA	Stock	0.8	0.8005	0.7963	0.7968	30428560.0
2016-03-11 12:00:00	NVDA	Stock	0.797	0.7992	0.7964	0.797	18859320.0
2016-03-11 13:00:00	NVDA	Stock	0.797	0.801	0.796	0.8008	33790160.0
2016-03-11 14:00:00	NVDA	Stock	0.8009	0.805	0.8009	0.8049	47794400.0
2016-03-11 15:00:00	NVDA	Stock	0.8048	0.8058	0.8028	0.8055	57910040.0
2016-03-11 16:00:00	NVDA	Stock	0.8055	0.8055	0.8055	0.8055	2946520.0
2016-03-11 18:00:00	NVDA	Stock	0.8055	0.8055	0.8055	0.8055	12000.0
2016-03-11 04:00:00	AMZN	Stock	28.176	28.176	28.176	28.176	2000.0
2016-03-11 05:00:00	AMZN	Stock	28.263	28.263	28.263	28.263	2000.0
2016-03-11 06:00:00	AMZN	Stock	28.265	28.312	28.265	28.31	13700.0
2016-03-11 07:00:00	AMZN	Stock	28.249	28.2895	28.2	28.2895	79840.0
2016-03-11 08:00:00	AMZN	Stock	28.257	28.292	28.1625	28.2525	306740.0
2016-03-11 09:00:00	AMZN	Stock	28.25	28.3825	28.1755	28.234	12140180.0
2016-03-11 10:00:00	AMZN	Stock	28.2494	28.4185	28.1365	28.337	13864880.0
2016-03-11 11:00:00	AMZN	Stock	28.335	28.3898	28.249	28.3065	7363420.0
2016-03-11 12:00:00	AMZN	Stock	28.3135	28.3335	28.25	28.2888	4801320.0
2016-03-11 13:00:00	AMZN	Stock	28.288	28.315	28.225	28.2945	4319320.0
2016-03-11 14:00:00	AMZN	Stock	28.2945	28.3295	28.243	28.298	5542600.0

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

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