PREVIEW / etf_30min / 2023-09-05

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-05.parquet
  size:    706 KB
  rows:    27,957

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
2023-09-05 04:00:00	SPY	ETF	449.8	449.8	449.11	449.21	18753.0
2023-09-05 04:30:00	SPY	ETF	449.15	450.07	449.15	449.93	14867.0
2023-09-05 05:00:00	SPY	ETF	449.94	450.35	449.91	450.34	36299.0
2023-09-05 05:30:00	SPY	ETF	450.42	450.55	450.31	450.42	23809.0
2023-09-05 06:00:00	SPY	ETF	450.27	450.63	450.26	450.6	22901.0
2023-09-05 06:30:00	SPY	ETF	450.61	450.73	450.42	450.45	10374.0
2023-09-05 07:00:00	SPY	ETF	450.45	450.5	450.01	450.25	46872.0
2023-09-05 07:30:00	SPY	ETF	450.24	450.68	450.24	450.56	54089.0
2023-09-05 08:00:00	SPY	ETF	450.1786	450.7	449.13	450.07	95545.0
2023-09-05 08:30:00	SPY	ETF	450.0	451.03	449.76	450.91	309535.0
2023-09-05 09:00:00	SPY	ETF	450.98	450.98	450.22	450.74	279023.0
2023-09-05 09:30:00	SPY	ETF	450.74	450.93	449.38	449.5899	4673205.0
2023-09-05 10:00:00	SPY	ETF	449.59	450.43	449.17	449.8703	3858626.0
2023-09-05 10:30:00	SPY	ETF	449.89	450.37	449.23	450.105	3370442.0
2023-09-05 11:00:00	SPY	ETF	450.11	451.06	450.11	450.28	3657006.0
2023-09-05 11:30:00	SPY	ETF	450.2799	450.42	449.87	450.22	2437605.0
2023-09-05 12:00:00	SPY	ETF	450.23	450.73	450.18	450.4	2057369.0
2023-09-05 12:30:00	SPY	ETF	450.4	450.69	450.235	450.31	1633067.0
2023-09-05 13:00:00	SPY	ETF	450.3	450.34	449.5993	449.62	2437962.0
2023-09-05 13:30:00	SPY	ETF	449.62	450.07	449.49	450.02	2463065.0
2023-09-05 14:00:00	SPY	ETF	450.03	450.46	449.695	450.37	2597281.0
2023-09-05 14:30:00	SPY	ETF	450.38	450.64	450.1	450.62	1907401.0
2023-09-05 15:00:00	SPY	ETF	450.62	450.625	449.6399	449.8473	2916390.0
2023-09-05 15:30:00	SPY	ETF	449.85	450.38	449.17	449.25	7065115.0
2023-09-05 16:00:00	SPY	ETF	449.24	449.44	449.0	449.11	1504715.0
2023-09-05 16:30:00	SPY	ETF	449.11	449.13	448.98	449.05	194041.0
2023-09-05 17:00:00	SPY	ETF	449.07	449.13	449.02	449.13	34283.0
2023-09-05 17:30:00	SPY	ETF	449.1	449.15	449.0	449.0	36977.0
2023-09-05 18:00:00	SPY	ETF	448.91	449.2	448.9	449.12	71421.0
2023-09-05 18:30:00	SPY	ETF	449.15	449.21	449.13	449.2	9523.0
2023-09-05 19:00:00	SPY	ETF	449.19	449.21	449.01	449.01	10088.0
2023-09-05 19:30:00	SPY	ETF	449.06	449.19	449.06	449.15	16756.0
2023-09-05 04:00:00	QQQ	ETF	376.3	376.39	375.29	375.41	41517.0
2023-09-05 04:30:00	QQQ	ETF	375.41	376.18	375.3	376.05	15494.0
2023-09-05 05:00:00	QQQ	ETF	376.02	376.48	375.93	376.42	31190.0
2023-09-05 05:30:00	QQQ	ETF	376.49	376.64	376.39	376.53	26093.0
2023-09-05 06:00:00	QQQ	ETF	376.38	376.79	376.29	376.68	14924.0
2023-09-05 06:30:00	QQQ	ETF	376.7	376.91	376.56	376.58	7136.0
2023-09-05 07:00:00	QQQ	ETF	376.6	376.64	375.9	376.11	77089.0
2023-09-05 07:30:00	QQQ	ETF	376.11	376.72	376.11	376.58	47344.0
2023-09-05 08:00:00	QQQ	ETF	376.85	377.5	375.6196	376.08	117084.0
2023-09-05 08:30:00	QQQ	ETF	376.05	377.17	375.7	377.02	284144.0
2023-09-05 09:00:00	QQQ	ETF	377.07	377.1	375.9	376.74	282965.0
2023-09-05 09:30:00	QQQ	ETF	376.77	377.36	375.9	376.29	3379807.0
2023-09-05 10:00:00	QQQ	ETF	376.28	377.77	375.83	376.96	2695452.0
2023-09-05 10:30:00	QQQ	ETF	376.97	378.18	376.6566	377.67	2250696.0
2023-09-05 11:00:00	QQQ	ETF	377.68	379.06	377.68	377.98	2167409.0
2023-09-05 11:30:00	QQQ	ETF	377.99	378.14	377.29	377.72	1914072.0
2023-09-05 12:00:00	QQQ	ETF	377.7	378.52	377.6201	378.22	1162704.0
2023-09-05 12:30:00	QQQ	ETF	378.25	378.75	378.18	378.495	1085490.0

> showing 50 of 27,957 rows — these rows as CSV

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