PREVIEW / etf_30min / 2021-08-24

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-24.parquet
  size:    617 KB
  rows:    23,360

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
2021-08-24 04:00:00	SPY	ETF	447.98	448.44	447.98	448.29	7183.0
2021-08-24 04:30:00	SPY	ETF	448.27	448.3	448.13	448.19	9450.0
2021-08-24 05:00:00	SPY	ETF	448.11	448.29	448.04	448.09	11896.0
2021-08-24 05:30:00	SPY	ETF	448.07	448.12	447.68	447.75	22717.0
2021-08-24 06:00:00	SPY	ETF	447.75	447.98	447.74	447.98	8548.0
2021-08-24 06:30:00	SPY	ETF	447.99	448.1	447.96	448.1	16089.0
2021-08-24 07:00:00	SPY	ETF	448.17	448.19	447.98	448.05	26291.0
2021-08-24 07:30:00	SPY	ETF	448.09	448.09	447.77	447.8	91231.0
2021-08-24 08:00:00	SPY	ETF	448.19	448.25	447.43	447.63	81665.0
2021-08-24 08:30:00	SPY	ETF	447.61	447.66	447.36	447.56	228586.0
2021-08-24 09:00:00	SPY	ETF	447.63	448.07	447.57	447.96	244102.0
2021-08-24 09:30:00	SPY	ETF	447.97	448.18	447.42	448.01	4717154.0
2021-08-24 10:00:00	SPY	ETF	448.02	448.375	447.82	448.3573	2448735.0
2021-08-24 10:30:00	SPY	ETF	448.355	448.46	448.09	448.19	1734674.0
2021-08-24 11:00:00	SPY	ETF	448.19	448.38	447.9748	447.98	1430144.0
2021-08-24 11:30:00	SPY	ETF	447.98	448.08	447.74	448.025	1647044.0
2021-08-24 12:00:00	SPY	ETF	448.03	448.035	447.65	447.69	987988.0
2021-08-24 12:30:00	SPY	ETF	447.69	447.96	447.59	447.92	720952.0
2021-08-24 13:00:00	SPY	ETF	447.925	448.09	447.91	447.99	757228.0
2021-08-24 13:30:00	SPY	ETF	447.995	448.32	447.995	448.23	1159659.0
2021-08-24 14:00:00	SPY	ETF	448.24	448.4	448.215	448.29	1368730.0
2021-08-24 14:30:00	SPY	ETF	448.3	448.5	448.263	448.47	1241734.0
2021-08-24 15:00:00	SPY	ETF	448.48	448.54	448.32	448.44	1825990.0
2021-08-24 15:30:00	SPY	ETF	448.43	448.455	447.69	447.95	5687084.0
2021-08-24 16:00:00	SPY	ETF	447.96	448.4	447.8	448.07	2292557.0
2021-08-24 16:30:00	SPY	ETF	448.09	448.09	447.53	448.02	336828.0
2021-08-24 17:00:00	SPY	ETF	448.0	448.15	447.97	448.11	286527.0
2021-08-24 17:30:00	SPY	ETF	448.08	448.17	448.08	448.1	15780.0
2021-08-24 18:00:00	SPY	ETF	448.1	448.12	448.0	448.04	57319.0
2021-08-24 18:30:00	SPY	ETF	447.97	448.09	447.97	447.98	14881.0
2021-08-24 19:00:00	SPY	ETF	447.98	447.98	447.75	447.75	45295.0
2021-08-24 19:30:00	SPY	ETF	447.77	447.87	447.67	447.791	81750.0
2021-08-24 04:00:00	QQQ	ETF	374.11	374.98	374.11	374.9	56550.0
2021-08-24 04:30:00	QQQ	ETF	374.89	374.94	374.78	374.8	13677.0
2021-08-24 05:00:00	QQQ	ETF	374.8	374.98	374.75	374.82	15114.0
2021-08-24 05:30:00	QQQ	ETF	374.81	374.84	374.16	374.28	51451.0
2021-08-24 06:00:00	QQQ	ETF	374.31	374.38	374.17	374.24	10207.0
2021-08-24 06:30:00	QQQ	ETF	374.22	374.4	374.15	374.31	22260.0
2021-08-24 07:00:00	QQQ	ETF	374.34	374.38	374.03	374.12	67804.0
2021-08-24 07:30:00	QQQ	ETF	374.14	374.15	373.78	373.88	46964.0
2021-08-24 08:00:00	QQQ	ETF	374.26	374.83	373.35	373.55	156581.0
2021-08-24 08:30:00	QQQ	ETF	373.5	373.66	373.3	373.63	74619.0
2021-08-24 09:00:00	QQQ	ETF	373.68	374.06	373.63	373.87	172816.0
2021-08-24 09:30:00	QQQ	ETF	373.83	374.33	373.36	373.81	3161634.0
2021-08-24 10:00:00	QQQ	ETF	373.82	374.74	373.605	374.69	1856809.0
2021-08-24 10:30:00	QQQ	ETF	374.68	374.99	374.36	374.47	1366831.0
2021-08-24 11:00:00	QQQ	ETF	374.47	374.68	374.0499	374.0499	1254350.0
2021-08-24 11:30:00	QQQ	ETF	374.055	374.539	373.83	374.48	1072724.0
2021-08-24 12:00:00	QQQ	ETF	374.49	374.54	373.94	373.9499	776087.0
2021-08-24 12:30:00	QQQ	ETF	373.95	374.09	373.77	374.03	540589.0

> showing 50 of 23,360 rows — these rows as CSV

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