PREVIEW / etf_30min / 2019-09-30

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-30.parquet
  size:    500 KB
  rows:    17,400

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
2019-09-30 04:00:00	SPY	ETF	296.43	296.78	296.43	296.58	6522.0
2019-09-30 04:30:00	SPY	ETF	296.45	296.68	296.45	296.63	10200.0
2019-09-30 05:00:00	SPY	ETF	296.67	296.7	296.5	296.54	6191.0
2019-09-30 05:30:00	SPY	ETF	296.49	296.75	296.42	296.75	6830.0
2019-09-30 06:00:00	SPY	ETF	296.61	296.65	296.43	296.6	3460.0
2019-09-30 06:30:00	SPY	ETF	296.33	296.35	296.07	296.12	28494.0
2019-09-30 07:00:00	SPY	ETF	296.12	296.35	296.07	296.3	70782.0
2019-09-30 07:30:00	SPY	ETF	296.25	296.32	296.17	296.21	38683.0
2019-09-30 08:00:00	SPY	ETF	296.07	296.55	295.85	295.93	107395.0
2019-09-30 08:30:00	SPY	ETF	295.96	296.0	295.55	295.62	276781.0
2019-09-30 09:00:00	SPY	ETF	295.63	296.0	295.57	295.95	171215.0
2019-09-30 09:30:00	SPY	ETF	295.97	296.71	295.92	296.49	5662655.0
2019-09-30 10:00:00	SPY	ETF	296.47	296.82	296.24	296.31	2770674.0
2019-09-30 10:30:00	SPY	ETF	296.305	296.73	296.22	296.575	2094991.0
2019-09-30 11:00:00	SPY	ETF	296.58	297.03	296.305	297.0	2127796.0
2019-09-30 11:30:00	SPY	ETF	297.02	297.18	296.85	297.035	1776484.0
2019-09-30 12:00:00	SPY	ETF	297.04	297.48	297.04	297.448	1893224.0
2019-09-30 12:30:00	SPY	ETF	297.445	297.48	297.29	297.36	1067203.0
2019-09-30 13:00:00	SPY	ETF	297.37	297.49	297.21	297.285	1518078.0
2019-09-30 13:30:00	SPY	ETF	297.29	297.55	297.25	297.305	1400988.0
2019-09-30 14:00:00	SPY	ETF	297.3	297.36	297.1	297.25	2080584.0
2019-09-30 14:30:00	SPY	ETF	297.255	297.3655	297.06	297.07	1733551.0
2019-09-30 15:00:00	SPY	ETF	297.07	297.25	296.87	297.04	4020312.0
2019-09-30 15:30:00	SPY	ETF	297.05	297.22	296.6	296.83	14026478.0
2019-09-30 16:00:00	SPY	ETF	296.83	297.66	296.77	297.65	7278690.0
2019-09-30 16:30:00	SPY	ETF	297.58	297.66	296.77	297.51	341460.0
2019-09-30 17:00:00	SPY	ETF	297.53	297.53	296.77	297.45	429893.0
2019-09-30 17:30:00	SPY	ETF	297.43	297.45	297.4	297.45	35881.0
2019-09-30 18:00:00	SPY	ETF	297.44	297.69	296.77	297.54	74574.0
2019-09-30 18:30:00	SPY	ETF	297.5	297.5	297.32	297.32	8513.0
2019-09-30 19:00:00	SPY	ETF	297.32	297.49	297.32	297.47	10238.0
2019-09-30 19:30:00	SPY	ETF	297.49	297.57	297.3	297.38	27254.0
2019-09-30 04:00:00	QQQ	ETF	188.03	188.5	188.01	188.16	30108.0
2019-09-30 04:30:00	QQQ	ETF	188.21	188.21	188.13	188.2	16325.0
2019-09-30 05:00:00	QQQ	ETF	188.26	188.27	188.12	188.14	17891.0
2019-09-30 05:30:00	QQQ	ETF	188.11	188.32	188.1	188.32	25700.0
2019-09-30 06:00:00	QQQ	ETF	188.26	188.26	188.15	188.22	2500.0
2019-09-30 06:30:00	QQQ	ETF	188.19	188.19	187.84	187.85	13904.0
2019-09-30 07:00:00	QQQ	ETF	187.84	188.01	187.8	187.96	37476.0
2019-09-30 07:30:00	QQQ	ETF	187.97	188.02	187.88	187.96	16884.0
2019-09-30 08:00:00	QQQ	ETF	187.9	188.14	187.72	187.77	61591.0
2019-09-30 08:30:00	QQQ	ETF	187.78	187.79	187.41	187.51	84821.0
2019-09-30 09:00:00	QQQ	ETF	187.48	187.8	187.41	187.74	70994.0
2019-09-30 09:30:00	QQQ	ETF	187.75	188.242	187.4	187.95	2644363.0
2019-09-30 10:00:00	QQQ	ETF	187.95	188.41	187.85	188.01	1947395.0
2019-09-30 10:30:00	QQQ	ETF	188.02	188.21	187.7666	188.13	1203457.0
2019-09-30 11:00:00	QQQ	ETF	188.15	188.51	187.92	188.48	843794.0
2019-09-30 11:30:00	QQQ	ETF	188.49	188.54	188.31	188.45	842388.0
2019-09-30 12:00:00	QQQ	ETF	188.45	188.9158	188.43	188.9	1036653.0
2019-09-30 12:30:00	QQQ	ETF	188.91	189.11	188.85	188.97	1214979.0

> showing 50 of 17,400 rows — these rows as CSV

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