PREVIEW / stock_1hour / 2015-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-23.parquet
  size:    1.0 MB
  rows:    48,520
  symbols: 3,428

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-23 04:00:00	AAPL	Stock	29.0	29.1	28.9575	29.0625	32576.0
2015-10-23 05:00:00	AAPL	Stock	29.0625	29.075	29.0	29.0425	33980.0
2015-10-23 06:00:00	AAPL	Stock	29.085	29.085	29.0025	29.025	95208.0
2015-10-23 07:00:00	AAPL	Stock	29.025	29.3425	29.0175	29.225	720104.0
2015-10-23 08:00:00	AAPL	Stock	29.225	29.3425	29.04	29.195	1139104.0
2015-10-23 09:00:00	AAPL	Stock	29.195	29.6025	29.0825	29.5912	44701484.0
2015-10-23 10:00:00	AAPL	Stock	29.591	29.6375	29.4325	29.6055	45178592.0
2015-10-23 11:00:00	AAPL	Stock	29.6025	29.6825	29.4295	29.55	27115444.0
2015-10-23 12:00:00	AAPL	Stock	29.5525	29.6725	29.52	29.6575	17571572.0
2015-10-23 13:00:00	AAPL	Stock	29.6562	29.705	29.5875	29.6738	17144732.0
2015-10-23 14:00:00	AAPL	Stock	29.6748	29.807	29.6425	29.7562	24562752.0
2015-10-23 15:00:00	AAPL	Stock	29.755	29.775	29.6575	29.7725	32448360.0
2015-10-23 16:00:00	AAPL	Stock	29.77	29.785	29.5775	29.7625	11175696.0
2015-10-23 17:00:00	AAPL	Stock	29.7675	29.7875	29.7575	29.78	209504.0
2015-10-23 18:00:00	AAPL	Stock	29.78	29.785	29.775	29.7775	76160.0
2015-10-23 19:00:00	AAPL	Stock	29.7825	29.7925	29.7775	29.7925	164504.0
2015-10-23 04:00:00	MSFT	Stock	51.56	51.59	51.4	51.45	23440.0
2015-10-23 05:00:00	MSFT	Stock	51.45	51.45	51.33	51.33	6500.0
2015-10-23 06:00:00	MSFT	Stock	51.45	52.15	51.45	52.15	96089.0
2015-10-23 07:00:00	MSFT	Stock	52.15	53.32	51.87	53.01	898746.0
2015-10-23 08:00:00	MSFT	Stock	53.0	53.25	52.01	52.91	2624622.0
2015-10-23 09:00:00	MSFT	Stock	52.92	53.585	52.25	53.31	35052698.0
2015-10-23 10:00:00	MSFT	Stock	53.31	53.61	52.89	53.08	22940411.0
2015-10-23 11:00:00	MSFT	Stock	53.085	53.16	52.72	52.925	14479018.0
2015-10-23 12:00:00	MSFT	Stock	52.93	53.16	52.78	52.97	9207253.0
2015-10-23 13:00:00	MSFT	Stock	52.97	53.29	52.93	53.2	6871005.0
2015-10-23 14:00:00	MSFT	Stock	53.19	53.535	53.15	53.51	7610134.0
2015-10-23 15:00:00	MSFT	Stock	53.51	54.07	52.82	53.24	24026441.0
2015-10-23 16:00:00	MSFT	Stock	52.98	53.4	52.7	52.8	5701214.0
2015-10-23 17:00:00	MSFT	Stock	52.75	53.0	52.75	53.0	100798.0
2015-10-23 18:00:00	MSFT	Stock	53.03	53.05	53.0	53.02	16056.0
2015-10-23 19:00:00	MSFT	Stock	53.0	53.0	52.92	52.94	9947.0
2015-10-23 04:00:00	NVDA	Stock	0.71	0.71	0.71	0.71	12000.0
2015-10-23 08:00:00	NVDA	Stock	0.7253	0.7285	0.7175	0.7175	96120.0
2015-10-23 09:00:00	NVDA	Stock	0.7185	0.7195	0.7105	0.7179	42002680.0
2015-10-23 10:00:00	NVDA	Stock	0.718	0.7185	0.709	0.7098	72397200.0
2015-10-23 11:00:00	NVDA	Stock	0.71	0.715	0.7055	0.7125	78980160.0
2015-10-23 12:00:00	NVDA	Stock	0.7126	0.7148	0.7123	0.7145	27281200.0
2015-10-23 13:00:00	NVDA	Stock	0.7144	0.7175	0.7115	0.7144	28172720.0
2015-10-23 14:00:00	NVDA	Stock	0.7143	0.716	0.7125	0.7143	41598720.0
2015-10-23 15:00:00	NVDA	Stock	0.7143	0.715	0.7118	0.7148	60224800.0
2015-10-23 16:00:00	NVDA	Stock	0.7148	0.7148	0.7148	0.7148	11974840.0
2015-10-23 17:00:00	NVDA	Stock	0.7125	0.7125	0.7125	0.7125	4000.0
2015-10-23 18:00:00	NVDA	Stock	0.7125	0.7125	0.7125	0.7125	19600.0
2015-10-23 04:00:00	AMZN	Stock	30.8515	30.8645	30.7965	30.8215	52100.0
2015-10-23 05:00:00	AMZN	Stock	30.815	30.8325	30.784	30.799	171960.0
2015-10-23 06:00:00	AMZN	Stock	30.8	30.95	30.8	30.8995	204460.0
2015-10-23 07:00:00	AMZN	Stock	30.8995	31.2215	30.825	31.178	1060680.0
2015-10-23 08:00:00	AMZN	Stock	31.175	31.2	30.6	30.94	4263000.0
2015-10-23 09:00:00	AMZN	Stock	30.9265	31.04	29.9425	29.9878	67733740.0

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

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