PREVIEW / etf_30min / 2023-07-21

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-21.parquet
  size:    693 KB
  rows:    27,476

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-07-21 04:00:00	SPY	ETF	453.0	453.24	452.87	453.23	12489.0
2023-07-21 04:30:00	SPY	ETF	453.24	453.32	453.15	453.32	10488.0
2023-07-21 05:00:00	SPY	ETF	453.32	453.33	453.17	453.33	6595.0
2023-07-21 05:30:00	SPY	ETF	453.11	453.3	452.96	453.24	14139.0
2023-07-21 06:00:00	SPY	ETF	453.33	453.63	453.33	453.63	18360.0
2023-07-21 06:30:00	SPY	ETF	453.62	453.62	453.46	453.58	5227.0
2023-07-21 07:00:00	SPY	ETF	453.56	453.56	453.36	453.39	31465.0
2023-07-21 07:30:00	SPY	ETF	453.39	453.45	453.1	453.1	42159.0
2023-07-21 08:00:00	SPY	ETF	453.5691	454.07	452.64	454.01	137174.0
2023-07-21 08:30:00	SPY	ETF	454.03	454.4301	453.9301	454.43	149130.0
2023-07-21 09:00:00	SPY	ETF	454.45	454.75	453.92	453.94	316351.0
2023-07-21 09:30:00	SPY	ETF	453.96	454.07	452.58	452.83	6129315.0
2023-07-21 10:00:00	SPY	ETF	452.84	453.57	452.21	452.3064	4764142.0
2023-07-21 10:30:00	SPY	ETF	452.3	453.46	452.29	453.09	3007971.0
2023-07-21 11:00:00	SPY	ETF	453.09	453.88	453.06	453.845	2263819.0
2023-07-21 11:30:00	SPY	ETF	453.85	454.0406	453.1	453.69	2826393.0
2023-07-21 12:00:00	SPY	ETF	453.69	453.7	453.08	453.1101	1663719.0
2023-07-21 12:30:00	SPY	ETF	453.11	453.28	452.61	452.98	2187010.0
2023-07-21 13:00:00	SPY	ETF	452.98	453.79	452.91	453.775	1861844.0
2023-07-21 13:30:00	SPY	ETF	453.78	454.165	453.7	454.05	2164450.0
2023-07-21 14:00:00	SPY	ETF	454.07	454.13	453.1	453.33	2151985.0
2023-07-21 14:30:00	SPY	ETF	453.33	453.8	453.12	453.2	1933334.0
2023-07-21 15:00:00	SPY	ETF	453.21	453.24	452.32	452.67	3776854.0
2023-07-21 15:30:00	SPY	ETF	452.68	452.75	452.17	452.19	10516733.0
2023-07-21 16:00:00	SPY	ETF	452.19	452.31	451.99	452.08	4574962.0
2023-07-21 16:30:00	SPY	ETF	452.05	452.3939	452.03	452.19	1309823.0
2023-07-21 17:00:00	SPY	ETF	452.29	452.3	452.0055	452.17	100956.0
2023-07-21 17:30:00	SPY	ETF	452.17	452.18	452.01	452.1	10459.0
2023-07-21 18:00:00	SPY	ETF	452.12	452.18	452.0	452.1	21547.0
2023-07-21 18:30:00	SPY	ETF	452.1099	452.1099	451.9912	451.9912	9113.0
2023-07-21 19:00:00	SPY	ETF	452.09	452.09	451.93	451.93	2860.0
2023-07-21 19:30:00	SPY	ETF	451.93	452.02	451.91	451.95	9582.0
2023-07-21 04:00:00	QQQ	ETF	377.79	378.38	377.59	378.38	73439.0
2023-07-21 04:30:00	QQQ	ETF	378.42	378.57	378.29	378.38	29671.0
2023-07-21 05:00:00	QQQ	ETF	378.26	378.36	378.18	378.18	11940.0
2023-07-21 05:30:00	QQQ	ETF	378.13	378.21	377.79	378.21	16995.0
2023-07-21 06:00:00	QQQ	ETF	378.24	378.67	378.24	378.67	19774.0
2023-07-21 06:30:00	QQQ	ETF	378.65	378.83	378.55	378.78	83406.0
2023-07-21 07:00:00	QQQ	ETF	378.76	378.85	378.49	378.5	84637.0
2023-07-21 07:30:00	QQQ	ETF	378.49	378.53	378.13	378.18	51191.0
2023-07-21 08:00:00	QQQ	ETF	378.7606	379.24	376.72	379.2	313529.0
2023-07-21 08:30:00	QQQ	ETF	379.21	379.43	379.111	379.37	212843.0
2023-07-21 09:00:00	QQQ	ETF	379.42	379.86	379.08	379.13	424368.0
2023-07-21 09:30:00	QQQ	ETF	379.18	379.92	377.54	377.55	6984091.0
2023-07-21 10:00:00	QQQ	ETF	377.56	378.19	375.84	375.8497	4625857.0
2023-07-21 10:30:00	QQQ	ETF	375.85	377.52	375.81	376.6	3286538.0
2023-07-21 11:00:00	QQQ	ETF	376.6	377.968	376.55	377.8301	2369267.0
2023-07-21 11:30:00	QQQ	ETF	377.85	378.06	376.43	377.26	2255305.0
2023-07-21 12:00:00	QQQ	ETF	377.27	377.41	376.39	376.43	1905829.0
2023-07-21 12:30:00	QQQ	ETF	376.44	376.77	375.95	376.51	1877844.0

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

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