PREVIEW / etf_30min / 2019-09-10

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-10.parquet
  size:    513 KB
  rows:    17,832

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-10 04:00:00	SPY	ETF	297.29	297.3	296.89	296.95	11779.0
2019-09-10 04:30:00	SPY	ETF	296.92	297.12	296.92	297.12	3831.0
2019-09-10 05:00:00	SPY	ETF	297.13	297.52	297.13	297.41	11756.0
2019-09-10 05:30:00	SPY	ETF	297.32	297.56	297.2	297.5	5151.0
2019-09-10 06:00:00	SPY	ETF	297.5	297.65	297.5	297.6	6055.0
2019-09-10 06:30:00	SPY	ETF	297.73	297.73	297.46	297.46	13480.0
2019-09-10 07:00:00	SPY	ETF	297.47	297.98	297.47	297.77	57379.0
2019-09-10 07:30:00	SPY	ETF	297.77	297.83	297.4	297.55	44810.0
2019-09-10 08:00:00	SPY	ETF	297.7401	298.2	297.1	297.4	86525.0
2019-09-10 08:30:00	SPY	ETF	297.4	297.72	297.39	297.42	88692.0
2019-09-10 09:00:00	SPY	ETF	297.39	297.5	297.27	297.37	172882.0
2019-09-10 09:30:00	SPY	ETF	297.36	297.42	296.05	296.33	9936206.0
2019-09-10 10:00:00	SPY	ETF	296.32	296.76	295.97	296.74	5646509.0
2019-09-10 10:30:00	SPY	ETF	296.73	296.82	296.11	296.24	3755904.0
2019-09-10 11:00:00	SPY	ETF	296.245	296.63	296.08	296.19	2777988.0
2019-09-10 11:30:00	SPY	ETF	296.19	297.28	296.0923	296.91	5575645.0
2019-09-10 12:00:00	SPY	ETF	296.91	297.59	296.42	297.42	3268720.0
2019-09-10 12:30:00	SPY	ETF	297.43	297.79	297.31	297.61	3170606.0
2019-09-10 13:00:00	SPY	ETF	297.6	297.66	296.94	297.18	2022371.0
2019-09-10 13:30:00	SPY	ETF	297.17	297.55	297.14	297.165	1316993.0
2019-09-10 14:00:00	SPY	ETF	297.16	297.28	296.73	296.76	1870364.0
2019-09-10 14:30:00	SPY	ETF	296.76	296.98	296.515	296.8	2141566.0
2019-09-10 15:00:00	SPY	ETF	296.79	296.99	296.66	296.845	2741871.0
2019-09-10 15:30:00	SPY	ETF	296.845	298.2	296.81	298.2	6908978.0
2019-09-10 16:00:00	SPY	ETF	298.18	298.18	297.92	298.14	4171357.0
2019-09-10 16:30:00	SPY	ETF	298.15	298.28	298.02	298.16	549791.0
2019-09-10 17:00:00	SPY	ETF	298.16	298.2057	297.99	298.06	414184.0
2019-09-10 17:30:00	SPY	ETF	298.06	298.06	297.96	298.04	175015.0
2019-09-10 18:00:00	SPY	ETF	298.09	298.13	297.88	297.95	171471.0
2019-09-10 18:30:00	SPY	ETF	297.95	297.97	297.82	297.85	19980.0
2019-09-10 19:00:00	SPY	ETF	297.81	297.98	297.78	297.98	21716.0
2019-09-10 19:30:00	SPY	ETF	298.0	298.05	297.92	297.93	15466.0
2019-09-10 04:00:00	QQQ	ETF	190.22	190.29	189.85	189.89	25090.0
2019-09-10 04:30:00	QQQ	ETF	189.94	190.16	189.87	190.16	7770.0
2019-09-10 05:00:00	QQQ	ETF	190.35	190.55	190.32	190.33	4510.0
2019-09-10 05:30:00	QQQ	ETF	190.3	190.56	190.17	190.42	9204.0
2019-09-10 06:00:00	QQQ	ETF	190.5	190.63	190.45	190.63	6921.0
2019-09-10 06:30:00	QQQ	ETF	190.59	190.7	190.44	190.44	11200.0
2019-09-10 07:00:00	QQQ	ETF	190.44	190.86	190.43	190.66	22408.0
2019-09-10 07:30:00	QQQ	ETF	190.68	190.68	190.27	190.44	50663.0
2019-09-10 08:00:00	QQQ	ETF	190.78	190.8501	190.2	190.35	84238.0
2019-09-10 08:30:00	QQQ	ETF	190.35	190.6	190.31	190.35	44363.0
2019-09-10 09:00:00	QQQ	ETF	190.3	190.4	190.1	190.17	151244.0
2019-09-10 09:30:00	QQQ	ETF	190.18	190.26	188.91	189.335	4551154.0
2019-09-10 10:00:00	QQQ	ETF	189.33	189.89	189.05	189.82	2715395.0
2019-09-10 10:30:00	QQQ	ETF	189.815	189.95	189.27	189.35	1474641.0
2019-09-10 11:00:00	QQQ	ETF	189.34	189.58	189.12	189.24	906356.0
2019-09-10 11:30:00	QQQ	ETF	189.24	190.09	189.09	189.83	1672786.0
2019-09-10 12:00:00	QQQ	ETF	189.82	190.4295	189.5	190.24	1178528.0
2019-09-10 12:30:00	QQQ	ETF	190.22	190.55	190.08	190.36	746143.0

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

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