PREVIEW / etf_30min / 2019-10-21

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-21.parquet
  size:    498 KB
  rows:    17,254

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-10-21 04:00:00	SPY	ETF	298.82	299.04	298.82	298.95	13171.0
2019-10-21 04:30:00	SPY	ETF	299.0	299.07	298.88	298.88	9100.0
2019-10-21 05:00:00	SPY	ETF	298.8	298.95	298.73	298.8	33849.0
2019-10-21 05:30:00	SPY	ETF	298.82	299.06	298.79	298.99	14776.0
2019-10-21 06:00:00	SPY	ETF	298.97	299.18	298.89	299.11	9089.0
2019-10-21 06:30:00	SPY	ETF	299.06	299.06	298.88	298.95	7358.0
2019-10-21 07:00:00	SPY	ETF	298.93	299.0	298.87	298.99	66597.0
2019-10-21 07:30:00	SPY	ETF	299.0	299.12	298.97	299.1	21414.0
2019-10-21 08:00:00	SPY	ETF	299.08	299.32	298.51	299.29	92328.0
2019-10-21 08:30:00	SPY	ETF	299.28	299.7	299.2	299.48	411072.0
2019-10-21 09:00:00	SPY	ETF	299.49	299.61	299.35	299.43	191152.0
2019-10-21 09:30:00	SPY	ETF	299.42	299.86	299.04	299.17	4641399.0
2019-10-21 10:00:00	SPY	ETF	299.15	299.46	298.935	299.41	1866106.0
2019-10-21 10:30:00	SPY	ETF	299.405	299.61	299.22	299.58	1820902.0
2019-10-21 11:00:00	SPY	ETF	299.58	299.77	299.5	299.74	2160222.0
2019-10-21 11:30:00	SPY	ETF	299.75	299.79	299.45	299.63	1481481.0
2019-10-21 12:00:00	SPY	ETF	299.63	299.78	299.41	299.78	1450639.0
2019-10-21 12:30:00	SPY	ETF	299.775	299.95	299.74	299.84	1843503.0
2019-10-21 13:00:00	SPY	ETF	299.84	299.9	299.67	299.779	1184519.0
2019-10-21 13:30:00	SPY	ETF	299.78	299.8	299.59	299.68	1074739.0
2019-10-21 14:00:00	SPY	ETF	299.68	300.09	299.66	299.84	2645678.0
2019-10-21 14:30:00	SPY	ETF	299.84	299.98	299.83	299.959	1252348.0
2019-10-21 15:00:00	SPY	ETF	299.96	300.07	299.83	299.95	1501399.0
2019-10-21 15:30:00	SPY	ETF	299.94	300.21	299.87	300.05	7957162.0
2019-10-21 16:00:00	SPY	ETF	300.05	300.16	299.95	300.04	5884612.0
2019-10-21 16:30:00	SPY	ETF	300.04	300.14	298.0299	300.1	667063.0
2019-10-21 17:00:00	SPY	ETF	300.14	300.14	299.99	300.1	70100.0
2019-10-21 17:30:00	SPY	ETF	300.1	300.2	299.99	300.11	43337.0
2019-10-21 18:00:00	SPY	ETF	300.14	300.15	300.03	300.05	32350.0
2019-10-21 18:30:00	SPY	ETF	300.04	300.04	300.0	300.0	5313.0
2019-10-21 19:00:00	SPY	ETF	300.0	300.04	300.0	300.03	4550.0
2019-10-21 19:30:00	SPY	ETF	300.04	300.08	300.0	300.04	20820.0
2019-10-21 04:00:00	QQQ	ETF	192.35	192.44	192.34	192.42	11971.0
2019-10-21 04:30:00	QQQ	ETF	192.36	192.39	192.24	192.24	7358.0
2019-10-21 05:00:00	QQQ	ETF	192.26	192.36	192.2	192.23	3153.0
2019-10-21 05:30:00	QQQ	ETF	192.29	192.47	192.29	192.36	4450.0
2019-10-21 06:00:00	QQQ	ETF	192.45	192.53	192.39	192.46	4345.0
2019-10-21 06:30:00	QQQ	ETF	192.36	192.45	192.28	192.45	4330.0
2019-10-21 07:00:00	QQQ	ETF	192.4	192.46	192.31	192.42	17615.0
2019-10-21 07:30:00	QQQ	ETF	192.42	192.48	192.4	192.47	29014.0
2019-10-21 08:00:00	QQQ	ETF	192.39	192.64	191.69	192.56	54751.0
2019-10-21 08:30:00	QQQ	ETF	192.54	192.91	192.52	192.71	248757.0
2019-10-21 09:00:00	QQQ	ETF	192.73	192.8	192.6	192.65	60702.0
2019-10-21 09:30:00	QQQ	ETF	192.65	193.16	192.38	192.49	2134799.0
2019-10-21 10:00:00	QQQ	ETF	192.5	192.86	192.14	192.81	1020558.0
2019-10-21 10:30:00	QQQ	ETF	192.82	193.06	192.64	192.91	678489.0
2019-10-21 11:00:00	QQQ	ETF	192.94	193.22	192.87	193.16	770222.0
2019-10-21 11:30:00	QQQ	ETF	193.15	193.19	192.87	193.0	526901.0
2019-10-21 12:00:00	QQQ	ETF	192.99	193.2	192.9	193.2	649416.0
2019-10-21 12:30:00	QQQ	ETF	193.21	193.32	193.135	193.15	742292.0

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

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