PREVIEW / stock_30min / 2018-06-22

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-22.parquet
  size:    1.7 MB
  rows:    84,502
  symbols: 2,818

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-22 04:00:00	AAPL	Stock	46.45	46.45	46.45	46.45	800.0
2018-06-22 04:30:00	AAPL	Stock	46.45	46.4725	46.45	46.4725	1600.0
2018-06-22 05:00:00	AAPL	Stock	46.5125	46.5125	46.5125	46.5125	1200.0
2018-06-22 06:00:00	AAPL	Stock	46.5175	46.5175	46.5175	46.5175	516.0
2018-06-22 06:30:00	AAPL	Stock	46.55	46.55	46.55	46.55	2000.0
2018-06-22 07:00:00	AAPL	Stock	46.625	46.625	46.5	46.515	45824.0
2018-06-22 07:30:00	AAPL	Stock	46.525	46.5425	46.5	46.5425	21552.0
2018-06-22 08:00:00	AAPL	Stock	46.55	46.655	46.4825	46.575	111988.0
2018-06-22 08:30:00	AAPL	Stock	46.5625	46.585	46.55	46.55	44804.0
2018-06-22 09:00:00	AAPL	Stock	46.5625	46.61	46.4525	46.4775	134188.0
2018-06-22 09:30:00	AAPL	Stock	46.4775	46.5375	46.2775	46.3875	7310116.0
2018-06-22 10:00:00	AAPL	Stock	46.385	46.4675	46.2425	46.2725	5432272.0
2018-06-22 10:30:00	AAPL	Stock	46.2738	46.4188	46.205	46.415	4705452.0
2018-06-22 11:00:00	AAPL	Stock	46.4125	46.4288	46.2925	46.35	3135924.0
2018-06-22 11:30:00	AAPL	Stock	46.35	46.39	46.3075	46.315	3104680.0
2018-06-22 12:00:00	AAPL	Stock	46.3162	46.3725	46.27	46.3525	2402744.0
2018-06-22 12:30:00	AAPL	Stock	46.35	46.4238	46.3275	46.42	1937056.0
2018-06-22 13:00:00	AAPL	Stock	46.4188	46.49	46.395	46.441	2781632.0
2018-06-22 13:30:00	AAPL	Stock	46.4425	46.47	46.3975	46.445	2443072.0
2018-06-22 14:00:00	AAPL	Stock	46.445	46.4562	46.365	46.4062	2022904.0
2018-06-22 14:30:00	AAPL	Stock	46.4075	46.4675	46.37	46.445	2287264.0
2018-06-22 15:00:00	AAPL	Stock	46.445	46.46	46.41	46.4425	2118792.0
2018-06-22 15:30:00	AAPL	Stock	46.4425	46.5	46.175	46.23	11301188.0
2018-06-22 16:00:00	AAPL	Stock	46.23	46.4925	46.23	46.255	26993988.0
2018-06-22 16:30:00	AAPL	Stock	46.25	46.2625	46.23	46.25	487196.0
2018-06-22 17:00:00	AAPL	Stock	46.255	46.2675	46.25	46.25	6476.0
2018-06-22 17:30:00	AAPL	Stock	46.2475	46.2475	46.23	46.23	11232.0
2018-06-22 18:00:00	AAPL	Stock	46.23	46.2475	46.225	46.225	14948.0
2018-06-22 18:30:00	AAPL	Stock	46.225	46.225	46.22	46.225	14656.0
2018-06-22 19:00:00	AAPL	Stock	46.225	46.225	46.2125	46.22	3380.0
2018-06-22 19:30:00	AAPL	Stock	46.2225	46.235	46.2225	46.235	2840.0
2018-06-22 04:00:00	MSFT	Stock	100.95	101.1	100.95	101.1	10953.0
2018-06-22 05:30:00	MSFT	Stock	101.11	101.11	101.04	101.1	1851.0
2018-06-22 06:00:00	MSFT	Stock	100.98	100.98	100.98	100.98	500.0
2018-06-22 07:00:00	MSFT	Stock	100.98	101.09	100.83	100.91	10141.0
2018-06-22 07:30:00	MSFT	Stock	101.0	101.0	100.8	100.8	11817.0
2018-06-22 08:00:00	MSFT	Stock	100.9	101.09	100.48	100.75	44711.0
2018-06-22 08:30:00	MSFT	Stock	100.61	100.85	100.61	100.7	12553.0
2018-06-22 09:00:00	MSFT	Stock	100.62	100.89	100.43	100.43	22057.0
2018-06-22 09:30:00	MSFT	Stock	100.43	100.7	99.625	99.772	4504475.0
2018-06-22 10:00:00	MSFT	Stock	99.775	100.215	99.64	99.82	2468643.0
2018-06-22 10:30:00	MSFT	Stock	99.815	99.9	99.63	99.84	1754519.0
2018-06-22 11:00:00	MSFT	Stock	99.835	100.04	99.73	99.99	1361894.0
2018-06-22 11:30:00	MSFT	Stock	99.995	100.196	99.925	100.15	876958.0
2018-06-22 12:00:00	MSFT	Stock	100.15	100.26	100.095	100.185	764606.0
2018-06-22 12:30:00	MSFT	Stock	100.18	100.39	100.07	100.35	550109.0
2018-06-22 13:00:00	MSFT	Stock	100.345	100.55	100.32	100.505	632673.0
2018-06-22 13:30:00	MSFT	Stock	100.51	100.665	100.435	100.565	778292.0
2018-06-22 14:00:00	MSFT	Stock	100.57	100.64	100.4	100.405	658503.0
2018-06-22 14:30:00	MSFT	Stock	100.4	100.5	100.155	100.45	1069273.0

> showing 50 of 84,502 rows — these rows as CSV

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