PREVIEW / stock_30min / 2017-08-18

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-18.parquet
  size:    1.6 MB
  rows:    80,620
  symbols: 2,961

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
2017-08-18 04:00:00	AAPL	Stock	39.45	39.4525	39.45	39.45	7564.0
2017-08-18 04:30:00	AAPL	Stock	39.5	39.5	39.5	39.5	1908.0
2017-08-18 05:00:00	AAPL	Stock	39.5	39.5	39.5	39.5	1408.0
2017-08-18 05:30:00	AAPL	Stock	39.5	39.525	39.5	39.525	2480.0
2017-08-18 06:00:00	AAPL	Stock	39.5625	39.75	39.5625	39.705	52192.0
2017-08-18 06:30:00	AAPL	Stock	39.7	39.745	39.7	39.7	14356.0
2017-08-18 07:00:00	AAPL	Stock	39.7075	39.71	39.6025	39.6125	49204.0
2017-08-18 07:30:00	AAPL	Stock	39.6125	39.6875	39.6	39.6875	35648.0
2017-08-18 08:00:00	AAPL	Stock	39.6975	39.71	39.6125	39.69	265984.0
2017-08-18 08:30:00	AAPL	Stock	39.6875	39.72	39.6525	39.675	108848.0
2017-08-18 09:00:00	AAPL	Stock	39.6625	39.675	39.405	39.49	616676.0
2017-08-18 09:30:00	AAPL	Stock	39.49	39.67	39.18	39.2275	20287692.0
2017-08-18 10:00:00	AAPL	Stock	39.2275	39.5737	39.2	39.4925	10057556.0
2017-08-18 10:30:00	AAPL	Stock	39.4925	39.605	39.38	39.54	6441408.0
2017-08-18 11:00:00	AAPL	Stock	39.54	39.7	39.4075	39.6835	7479728.0
2017-08-18 11:30:00	AAPL	Stock	39.68	39.875	39.64	39.8028	8466084.0
2017-08-18 12:00:00	AAPL	Stock	39.8013	39.8085	39.685	39.768	4465184.0
2017-08-18 12:30:00	AAPL	Stock	39.772	39.855	39.7325	39.7875	4925868.0
2017-08-18 13:00:00	AAPL	Stock	39.79	39.8155	39.71	39.765	3726232.0
2017-08-18 13:30:00	AAPL	Stock	39.7625	39.805	39.5475	39.55	4403360.0
2017-08-18 14:00:00	AAPL	Stock	39.5475	39.655	39.5425	39.61	3213828.0
2017-08-18 14:30:00	AAPL	Stock	39.615	39.64	39.5025	39.5188	2759872.0
2017-08-18 15:00:00	AAPL	Stock	39.5225	39.5825	39.445	39.485	4656696.0
2017-08-18 15:30:00	AAPL	Stock	39.4825	39.5475	39.355	39.3775	11265112.0
2017-08-18 16:00:00	AAPL	Stock	39.375	39.3825	39.3675	39.375	4352460.0
2017-08-18 16:30:00	AAPL	Stock	39.37	39.3825	39.3675	39.3675	44628.0
2017-08-18 17:00:00	AAPL	Stock	39.38	39.38	39.3425	39.3725	94704.0
2017-08-18 17:30:00	AAPL	Stock	39.375	39.375	39.3275	39.3275	28964.0
2017-08-18 18:00:00	AAPL	Stock	39.3275	39.3425	39.305	39.3125	23688.0
2017-08-18 18:30:00	AAPL	Stock	39.3125	39.3475	39.3075	39.3225	18236.0
2017-08-18 19:00:00	AAPL	Stock	39.3225	39.3475	39.3125	39.3475	25664.0
2017-08-18 19:30:00	AAPL	Stock	39.3325	39.3375	39.3175	39.325	28184.0
2017-08-18 06:00:00	MSFT	Stock	72.49	72.49	72.49	72.49	196.0
2017-08-18 07:00:00	MSFT	Stock	72.49	72.49	72.49	72.49	120.0
2017-08-18 07:30:00	MSFT	Stock	72.49	72.65	72.49	72.65	680.0
2017-08-18 08:00:00	MSFT	Stock	72.6	72.72	72.6	72.6	1891.0
2017-08-18 08:30:00	MSFT	Stock	72.66	72.67	72.66	72.67	1025.0
2017-08-18 09:00:00	MSFT	Stock	72.6	72.6	72.02	72.29	101391.0
2017-08-18 09:30:00	MSFT	Stock	72.27	72.61	71.94	71.94	4196929.0
2017-08-18 10:00:00	MSFT	Stock	71.95	72.31	71.93	72.19	1164844.0
2017-08-18 10:30:00	MSFT	Stock	72.198	72.39	72.0	72.275	756636.0
2017-08-18 11:00:00	MSFT	Stock	72.27	72.441	72.01	72.405	1043732.0
2017-08-18 11:30:00	MSFT	Stock	72.405	72.55	72.33	72.535	819468.0
2017-08-18 12:00:00	MSFT	Stock	72.54	72.65	72.415	72.635	708066.0
2017-08-18 12:30:00	MSFT	Stock	72.64	72.83	72.59	72.73	775692.0
2017-08-18 13:00:00	MSFT	Stock	72.72	72.84	72.64	72.82	595151.0
2017-08-18 13:30:00	MSFT	Stock	72.82	72.83	72.48	72.49	552729.0
2017-08-18 14:00:00	MSFT	Stock	72.48	72.72	72.48	72.65	535139.0
2017-08-18 14:30:00	MSFT	Stock	72.66	72.74	72.62	72.64	649968.0
2017-08-18 15:00:00	MSFT	Stock	72.645	72.78	72.59	72.685	778468.0

> showing 50 of 80,620 rows — these rows as CSV

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