PREVIEW / etf_30min / 2021-10-26

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-26.parquet
  size:    631 KB
  rows:    24,348

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-10-26 04:00:00	SPY	ETF	456.92	457.55	456.92	457.14	24088.0
2021-10-26 04:30:00	SPY	ETF	457.08	457.21	456.96	457.21	3328.0
2021-10-26 05:00:00	SPY	ETF	457.16	457.17	457.05	457.17	3019.0
2021-10-26 05:30:00	SPY	ETF	457.12	457.18	456.97	457.16	8972.0
2021-10-26 06:00:00	SPY	ETF	457.21	457.27	457.05	457.05	4996.0
2021-10-26 06:30:00	SPY	ETF	457.0	457.16	456.94	457.16	15444.0
2021-10-26 07:00:00	SPY	ETF	457.17	457.38	457.14	457.31	100449.0
2021-10-26 07:30:00	SPY	ETF	457.31	457.31	457.0	457.09	110340.0
2021-10-26 08:00:00	SPY	ETF	457.2	457.35	455.55	457.11	105896.0
2021-10-26 08:30:00	SPY	ETF	457.14	457.16	457.02	457.15	56781.0
2021-10-26 09:00:00	SPY	ETF	457.15	457.22	456.95	457.19	226569.0
2021-10-26 09:30:00	SPY	ETF	457.2	457.8	456.78	457.4	4550111.0
2021-10-26 10:00:00	SPY	ETF	457.41	458.49	457.18	458.21	3592275.0
2021-10-26 10:30:00	SPY	ETF	458.2	458.4	457.81	458.125	2516973.0
2021-10-26 11:00:00	SPY	ETF	458.12	458.35	457.89	458.28	1771206.0
2021-10-26 11:30:00	SPY	ETF	458.29	458.35	457.115	457.15	2681964.0
2021-10-26 12:00:00	SPY	ETF	457.15	457.26	456.5	456.67	2984998.0
2021-10-26 12:30:00	SPY	ETF	456.665	456.8501	455.56	456.23	3810237.0
2021-10-26 13:00:00	SPY	ETF	456.22	456.5786	455.82	456.27	2698961.0
2021-10-26 13:30:00	SPY	ETF	456.26	456.97	456.16	456.61	1867244.0
2021-10-26 14:00:00	SPY	ETF	456.61	457.12	456.585	456.82	2634592.0
2021-10-26 14:30:00	SPY	ETF	456.81	457.17	456.5301	457.06	2228702.0
2021-10-26 15:00:00	SPY	ETF	457.07	457.31	456.73	456.75	2823991.0
2021-10-26 15:30:00	SPY	ETF	456.75	457.43	455.89	455.9801	7195833.0
2021-10-26 16:00:00	SPY	ETF	455.99	456.43	455.0	456.01	2688266.0
2021-10-26 16:30:00	SPY	ETF	455.97	456.13	455.78	455.9	226614.0
2021-10-26 17:00:00	SPY	ETF	455.72	455.99	455.64	455.93	48839.0
2021-10-26 17:30:00	SPY	ETF	455.94	455.95	455.82	455.9	30455.0
2021-10-26 18:00:00	SPY	ETF	455.89	456.49	455.89	456.46	65634.0
2021-10-26 18:30:00	SPY	ETF	455.96	456.64	455.96	456.53	27841.0
2021-10-26 19:00:00	SPY	ETF	456.49	456.6	456.46	456.59	9976.0
2021-10-26 19:30:00	SPY	ETF	456.62	456.76	456.16	456.46	27397.0
2021-10-26 04:00:00	QQQ	ETF	379.54	380.54	379.54	380.14	142578.0
2021-10-26 04:30:00	QQQ	ETF	380.1	380.24	380.02	380.18	262200.0
2021-10-26 05:00:00	QQQ	ETF	380.18	380.28	380.1	380.18	154058.0
2021-10-26 05:30:00	QQQ	ETF	380.09	380.21	380.04	380.18	58766.0
2021-10-26 06:00:00	QQQ	ETF	380.21	380.26	379.7	379.71	92661.0
2021-10-26 06:30:00	QQQ	ETF	379.68	379.84	379.66	379.82	15209.0
2021-10-26 07:00:00	QQQ	ETF	379.88	380.11	379.87	380.04	49766.0
2021-10-26 07:30:00	QQQ	ETF	380.01	380.05	379.84	379.93	77273.0
2021-10-26 08:00:00	QQQ	ETF	379.979	380.18	378.213	379.91	153190.0
2021-10-26 08:30:00	QQQ	ETF	379.93	380.03	379.81	379.97	55758.0
2021-10-26 09:00:00	QQQ	ETF	379.97	380.25	379.93	380.21	935272.0
2021-10-26 09:30:00	QQQ	ETF	380.22	381.68	379.7905	381.24	5564348.0
2021-10-26 10:00:00	QQQ	ETF	381.24	382.67	381.11	382.27	2619066.0
2021-10-26 10:30:00	QQQ	ETF	382.27	382.71	381.92	381.95	1853799.0
2021-10-26 11:00:00	QQQ	ETF	381.96	382.17	381.3	381.86	1780715.0
2021-10-26 11:30:00	QQQ	ETF	381.87	381.96	379.87	380.0599	2433819.0
2021-10-26 12:00:00	QQQ	ETF	380.02	380.31	379.24	379.74	2243407.0
2021-10-26 12:30:00	QQQ	ETF	379.7592	380.21	377.905	378.74	3765964.0

> showing 50 of 24,348 rows — these rows as CSV

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