PREVIEW / stock_30min / 2018-06-05

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-05.parquet
  size:    1.7 MB
  rows:    85,166
  symbols: 2,850

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
2018-06-05 04:00:00	AAPL	Stock	48.0525	48.11	48.0525	48.11	9500.0
2018-06-05 04:30:00	AAPL	Stock	48.1375	48.1875	48.1375	48.1875	6752.0
2018-06-05 05:00:00	AAPL	Stock	48.1875	48.1975	48.1875	48.1975	3856.0
2018-06-05 05:30:00	AAPL	Stock	48.2	48.2125	48.17	48.21	12096.0
2018-06-05 06:00:00	AAPL	Stock	48.1675	48.175	48.1325	48.1625	18464.0
2018-06-05 06:30:00	AAPL	Stock	48.13	48.1675	48.125	48.1675	7568.0
2018-06-05 07:00:00	AAPL	Stock	48.165	48.3125	48.15	48.2875	256132.0
2018-06-05 07:30:00	AAPL	Stock	48.2825	48.295	48.2525	48.2875	80412.0
2018-06-05 08:00:00	AAPL	Stock	48.1975	48.325	48.1525	48.1875	400380.0
2018-06-05 08:30:00	AAPL	Stock	48.185	48.205	48.125	48.15	160804.0
2018-06-05 09:00:00	AAPL	Stock	48.1375	48.2825	47.9575	48.27	200788.0
2018-06-05 09:30:00	AAPL	Stock	48.23	48.3525	48.09	48.25	12614112.0
2018-06-05 10:00:00	AAPL	Stock	48.2525	48.485	48.2362	48.4075	10032980.0
2018-06-05 10:30:00	AAPL	Stock	48.4075	48.432	48.305	48.4225	5417572.0
2018-06-05 11:00:00	AAPL	Stock	48.4225	48.435	48.26	48.3475	4826200.0
2018-06-05 11:30:00	AAPL	Stock	48.3488	48.3575	48.225	48.3	5124624.0
2018-06-05 12:00:00	AAPL	Stock	48.2988	48.315	48.165	48.2345	3454120.0
2018-06-05 12:30:00	AAPL	Stock	48.2312	48.2875	48.165	48.275	2760748.0
2018-06-05 13:00:00	AAPL	Stock	48.2738	48.305	48.23	48.2925	2493256.0
2018-06-05 13:30:00	AAPL	Stock	48.2925	48.31	48.25	48.264	2180536.0
2018-06-05 14:00:00	AAPL	Stock	48.265	48.295	48.2125	48.27	2836496.0
2018-06-05 14:30:00	AAPL	Stock	48.2675	48.32	48.23	48.3075	2533280.0
2018-06-05 15:00:00	AAPL	Stock	48.3075	48.31	48.2125	48.2738	3374928.0
2018-06-05 15:30:00	AAPL	Stock	48.2725	48.395	48.2575	48.3275	10952648.0
2018-06-05 16:00:00	AAPL	Stock	48.3275	48.3525	48.3175	48.3175	6679656.0
2018-06-05 16:30:00	AAPL	Stock	48.315	48.35	48.275	48.335	228932.0
2018-06-05 17:00:00	AAPL	Stock	48.3275	48.35	48.325	48.3425	10360.0
2018-06-05 17:30:00	AAPL	Stock	48.35	48.3725	48.3425	48.3675	41588.0
2018-06-05 18:00:00	AAPL	Stock	48.3675	48.3675	48.3125	48.3375	33016.0
2018-06-05 18:30:00	AAPL	Stock	48.3275	48.3375	48.3	48.325	5484.0
2018-06-05 19:00:00	AAPL	Stock	48.325	48.325	48.305	48.32	1344.0
2018-06-05 19:30:00	AAPL	Stock	48.3175	48.3275	48.3175	48.325	14936.0
2018-06-05 04:00:00	MSFT	Stock	102.0	102.0	102.0	102.0	200.0
2018-06-05 04:30:00	MSFT	Stock	102.39	102.39	102.39	102.39	100.0
2018-06-05 05:30:00	MSFT	Stock	102.25	102.25	102.25	102.25	2700.0
2018-06-05 06:00:00	MSFT	Stock	102.3	102.3	102.15	102.15	767.0
2018-06-05 06:30:00	MSFT	Stock	102.07	102.07	102.07	102.07	500.0
2018-06-05 07:00:00	MSFT	Stock	102.05	102.15	102.02	102.12	2313.0
2018-06-05 07:30:00	MSFT	Stock	102.01	102.08	102.01	102.08	1350.0
2018-06-05 08:00:00	MSFT	Stock	102.01	102.279	101.85	101.9	23803.0
2018-06-05 08:30:00	MSFT	Stock	101.9	102.08	101.89	101.99	8188.0
2018-06-05 09:00:00	MSFT	Stock	101.951	102.0	101.67	101.98	54223.0
2018-06-05 09:30:00	MSFT	Stock	101.98	102.11	101.53	102.1	3172039.0
2018-06-05 10:00:00	MSFT	Stock	102.1	102.17	101.9	102.015	1700082.0
2018-06-05 10:30:00	MSFT	Stock	102.02	102.21	101.975	102.205	1556759.0
2018-06-05 11:00:00	MSFT	Stock	102.2	102.25	101.95	102.1	1197111.0
2018-06-05 11:30:00	MSFT	Stock	102.11	102.15	101.71	101.985	1365289.0
2018-06-05 12:00:00	MSFT	Stock	101.985	101.995	101.54	101.62	917885.0
2018-06-05 12:30:00	MSFT	Stock	101.625	101.815	101.57	101.79	835420.0
2018-06-05 13:00:00	MSFT	Stock	101.8	101.92	101.71	101.81	664119.0

> showing 50 of 85,166 rows — these rows as CSV

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