PREVIEW / stock_1hour / 2015-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-20.parquet
  size:    1.0 MB
  rows:    48,238
  symbols: 3,408

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
2015-11-20 04:00:00	AAPL	Stock	29.7	29.7175	29.7	29.7175	2072.0
2015-11-20 05:00:00	AAPL	Stock	29.7	29.7	29.6975	29.7	2800.0
2015-11-20 06:00:00	AAPL	Stock	29.755	29.77	29.7525	29.7525	7120.0
2015-11-20 07:00:00	AAPL	Stock	29.725	29.73	29.6675	29.725	55504.0
2015-11-20 08:00:00	AAPL	Stock	29.725	29.7875	29.665	29.7675	366016.0
2015-11-20 09:00:00	AAPL	Stock	29.765	29.92	29.7125	29.905	27599008.0
2015-11-20 10:00:00	AAPL	Stock	29.9025	29.98	29.815	29.8355	22011564.0
2015-11-20 11:00:00	AAPL	Stock	29.835	29.91	29.7375	29.79	16194044.0
2015-11-20 12:00:00	AAPL	Stock	29.79	29.9145	29.74	29.8312	16628644.0
2015-11-20 13:00:00	AAPL	Stock	29.8325	29.8875	29.7752	29.815	8912192.0
2015-11-20 14:00:00	AAPL	Stock	29.815	29.84	29.785	29.79	9222404.0
2015-11-20 15:00:00	AAPL	Stock	29.7925	29.8275	29.765	29.825	18406084.0
2015-11-20 16:00:00	AAPL	Stock	29.825	29.876	29.81	29.8325	7969068.0
2015-11-20 17:00:00	AAPL	Stock	29.825	29.8375	29.825	29.8275	582372.0
2015-11-20 18:00:00	AAPL	Stock	29.8325	29.86	29.83	29.86	51732.0
2015-11-20 19:00:00	AAPL	Stock	29.86	29.875	29.8375	29.8625	85908.0
2015-11-20 07:00:00	MSFT	Stock	54.02	54.07	54.02	54.07	5827.0
2015-11-20 08:00:00	MSFT	Stock	54.0	54.12	54.0	54.09	17132.0
2015-11-20 09:00:00	MSFT	Stock	54.09	54.3	53.58	53.76	7159019.0
2015-11-20 10:00:00	MSFT	Stock	53.755	53.92	53.265	53.36	5518705.0
2015-11-20 11:00:00	MSFT	Stock	53.36	53.755	53.34	53.509	3319473.0
2015-11-20 12:00:00	MSFT	Stock	53.51	53.81	53.47	53.776	3235219.0
2015-11-20 13:00:00	MSFT	Stock	53.78	54.1	53.68	54.073	3699163.0
2015-11-20 14:00:00	MSFT	Stock	54.078	54.25	54.02	54.02	3445725.0
2015-11-20 15:00:00	MSFT	Stock	54.03	54.2	54.005	54.18	5742070.0
2015-11-20 16:00:00	MSFT	Stock	54.18	54.23	54.15	54.18	1846101.0
2015-11-20 17:00:00	MSFT	Stock	54.19	54.2	54.19	54.2	3809.0
2015-11-20 18:00:00	MSFT	Stock	54.22	54.25	54.2	54.24	6384.0
2015-11-20 19:00:00	MSFT	Stock	54.22	54.22	54.2	54.2	910.0
2015-11-20 07:00:00	NVDA	Stock	0.7775	0.7775	0.7775	0.7775	4000.0
2015-11-20 08:00:00	NVDA	Stock	0.7775	0.7775	0.7775	0.7775	9760.0
2015-11-20 09:00:00	NVDA	Stock	0.7785	0.785	0.7785	0.7848	25665880.0
2015-11-20 10:00:00	NVDA	Stock	0.785	0.7892	0.7835	0.7878	52024640.0
2015-11-20 11:00:00	NVDA	Stock	0.7879	0.7885	0.7872	0.7878	26277360.0
2015-11-20 12:00:00	NVDA	Stock	0.7879	0.7888	0.7865	0.788	25577520.0
2015-11-20 13:00:00	NVDA	Stock	0.788	0.7888	0.7865	0.7868	20434120.0
2015-11-20 14:00:00	NVDA	Stock	0.7868	0.7885	0.7854	0.7854	26580840.0
2015-11-20 15:00:00	NVDA	Stock	0.7855	0.7862	0.7829	0.7848	45387840.0
2015-11-20 16:00:00	NVDA	Stock	0.7848	0.7855	0.7843	0.7843	2654960.0
2015-11-20 04:00:00	AMZN	Stock	33.075	33.075	33.075	33.075	10000.0
2015-11-20 05:00:00	AMZN	Stock	33.075	33.075	33.075	33.075	2000.0
2015-11-20 06:00:00	AMZN	Stock	33.1125	33.1125	33.1125	33.1125	8000.0
2015-11-20 07:00:00	AMZN	Stock	33.2	33.2	33.1655	33.1755	31600.0
2015-11-20 08:00:00	AMZN	Stock	33.175	33.25	33.138	33.1505	207260.0
2015-11-20 09:00:00	AMZN	Stock	33.2	33.4035	33.026	33.105	13790960.0
2015-11-20 10:00:00	AMZN	Stock	33.1112	33.3075	32.8785	33.239	10405720.0
2015-11-20 11:00:00	AMZN	Stock	33.2373	33.2755	33.0795	33.1262	6564380.0
2015-11-20 12:00:00	AMZN	Stock	33.1315	33.2875	33.106	33.2825	4302260.0
2015-11-20 13:00:00	AMZN	Stock	33.2625	33.3375	33.1783	33.25	5306520.0
2015-11-20 14:00:00	AMZN	Stock	33.244	33.291	33.2085	33.2306	3666740.0

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

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