PREVIEW / stock_1hour / 2015-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-05.parquet
  size:    1.0 MB
  rows:    48,778
  symbols: 3,435

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-10-05 04:00:00	AAPL	Stock	27.675	27.7225	27.6675	27.71	7024.0
2015-10-05 05:00:00	AAPL	Stock	27.715	27.745	27.65	27.745	15664.0
2015-10-05 06:00:00	AAPL	Stock	27.75	27.775	27.7075	27.7075	65280.0
2015-10-05 07:00:00	AAPL	Stock	27.7125	27.725	27.465	27.5	590484.0
2015-10-05 08:00:00	AAPL	Stock	27.5	27.72	27.375	27.455	1444316.0
2015-10-05 09:00:00	AAPL	Stock	27.4525	27.535	27.285	27.375	30900352.0
2015-10-05 10:00:00	AAPL	Stock	27.3725	27.55	27.2675	27.485	34767016.0
2015-10-05 11:00:00	AAPL	Stock	27.485	27.5875	27.3788	27.4275	22165576.0
2015-10-05 12:00:00	AAPL	Stock	27.4275	27.54	27.3788	27.4875	22644844.0
2015-10-05 13:00:00	AAPL	Stock	27.4875	27.7175	27.465	27.67	20095860.0
2015-10-05 14:00:00	AAPL	Stock	27.6725	27.8425	27.6305	27.725	20097720.0
2015-10-05 15:00:00	AAPL	Stock	27.7275	27.77	27.5625	27.66	32678056.0
2015-10-05 16:00:00	AAPL	Stock	27.66	27.695	27.425	27.6	10329088.0
2015-10-05 17:00:00	AAPL	Stock	27.6025	27.695	27.595	27.6125	91496.0
2015-10-05 18:00:00	AAPL	Stock	27.615	27.615	27.59	27.59	32164.0
2015-10-05 19:00:00	AAPL	Stock	27.6	27.61	27.58	27.59	44216.0
2015-10-05 05:00:00	MSFT	Stock	45.72	45.99	45.72	45.99	640.0
2015-10-05 06:00:00	MSFT	Stock	45.99	46.0	45.9	45.9	1200.0
2015-10-05 07:00:00	MSFT	Stock	45.91	46.01	45.91	46.0	17223.0
2015-10-05 08:00:00	MSFT	Stock	45.99	46.1	45.85	45.95	22469.0
2015-10-05 09:00:00	MSFT	Stock	45.95	46.24	45.7	46.015	4241413.0
2015-10-05 10:00:00	MSFT	Stock	46.015	46.4	45.98	46.38	4424356.0
2015-10-05 11:00:00	MSFT	Stock	46.37	46.63	46.36	46.585	3203344.0
2015-10-05 12:00:00	MSFT	Stock	46.585	46.82	46.55	46.705	4074867.0
2015-10-05 13:00:00	MSFT	Stock	46.71	46.85	46.64	46.67	3125034.0
2015-10-05 14:00:00	MSFT	Stock	46.67	46.89	46.64	46.786	3023838.0
2015-10-05 15:00:00	MSFT	Stock	46.786	46.84	46.56	46.63	6744684.0
2015-10-05 16:00:00	MSFT	Stock	46.63	46.67	46.5	46.59	2491582.0
2015-10-05 17:00:00	MSFT	Stock	46.56	46.56	46.56	46.56	447.0
2015-10-05 18:00:00	MSFT	Stock	46.61	46.63	46.52	46.52	752289.0
2015-10-05 19:00:00	MSFT	Stock	46.55	46.55	46.55	46.55	800.0
2015-10-05 08:00:00	NVDA	Stock	0.625	0.625	0.625	0.625	10120.0
2015-10-05 09:00:00	NVDA	Stock	0.6248	0.6325	0.6208	0.6303	57635960.0
2015-10-05 10:00:00	NVDA	Stock	0.6303	0.6345	0.6273	0.6331	88298760.0
2015-10-05 11:00:00	NVDA	Stock	0.6332	0.638	0.632	0.6374	49137880.0
2015-10-05 12:00:00	NVDA	Stock	0.6372	0.6433	0.6365	0.6419	54544400.0
2015-10-05 13:00:00	NVDA	Stock	0.642	0.6428	0.6372	0.6388	48830240.0
2015-10-05 14:00:00	NVDA	Stock	0.6388	0.641	0.6375	0.6388	46300560.0
2015-10-05 15:00:00	NVDA	Stock	0.6385	0.639	0.635	0.6353	100479920.0
2015-10-05 16:00:00	NVDA	Stock	0.6355	0.6355	0.6353	0.6355	21034520.0
2015-10-05 17:00:00	NVDA	Stock	0.6355	0.6355	0.6355	0.6355	40000.0
2015-10-05 05:00:00	AMZN	Stock	26.7	26.7595	26.7	26.7595	7700.0
2015-10-05 06:00:00	AMZN	Stock	26.7595	26.775	26.7595	26.775	16900.0
2015-10-05 07:00:00	AMZN	Stock	26.7745	26.863	26.7745	26.8305	159820.0
2015-10-05 08:00:00	AMZN	Stock	26.8265	26.85	26.7625	26.825	601100.0
2015-10-05 09:00:00	AMZN	Stock	26.825	27.0085	26.8	26.912	11528460.0
2015-10-05 10:00:00	AMZN	Stock	26.9145	27.1214	26.879	27.0343	12715160.0
2015-10-05 11:00:00	AMZN	Stock	27.05	27.163	27.0365	27.1505	7310100.0
2015-10-05 12:00:00	AMZN	Stock	27.151	27.2215	27.0895	27.0895	5754380.0
2015-10-05 13:00:00	AMZN	Stock	27.1012	27.217	27.0625	27.2054	5618720.0

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

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