PREVIEW / etf_30min / 2023-09-25

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-25.parquet
  size:    708 KB
  rows:    28,339

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-25 04:00:00	SPY	ETF	431.88	432.02	430.62	430.62	12422.0
2023-09-25 04:30:00	SPY	ETF	430.59	430.59	429.13	429.71	102914.0
2023-09-25 05:00:00	SPY	ETF	429.7	430.29	429.6	430.28	16024.0
2023-09-25 05:30:00	SPY	ETF	430.26	430.29	429.72	430.25	32036.0
2023-09-25 06:00:00	SPY	ETF	430.31	430.56	430.1	430.43	21571.0
2023-09-25 06:30:00	SPY	ETF	430.52	430.52	429.82	430.23	45703.0
2023-09-25 07:00:00	SPY	ETF	430.2	430.45	429.9	430.0	221536.0
2023-09-25 07:30:00	SPY	ETF	430.0	430.0	429.11	429.27	174512.0
2023-09-25 08:00:00	SPY	ETF	429.26	432.06	428.75	429.19	282756.0
2023-09-25 08:30:00	SPY	ETF	429.19	429.62	428.98	429.0617	267456.0
2023-09-25 09:00:00	SPY	ETF	429.1	429.19	428.23	429.16	496878.0
2023-09-25 09:30:00	SPY	ETF	429.16	430.76	428.72	430.56	5678853.0
2023-09-25 10:00:00	SPY	ETF	430.57	430.71	429.23	429.53	4845013.0
2023-09-25 10:30:00	SPY	ETF	429.52	430.21	429.21	429.215	3162999.0
2023-09-25 11:00:00	SPY	ETF	429.211	431.48	429.14	430.98	4771355.0
2023-09-25 11:30:00	SPY	ETF	430.99	431.69	430.87	431.27	3039255.0
2023-09-25 12:00:00	SPY	ETF	431.26	432.02	431.04	431.89	2254350.0
2023-09-25 12:30:00	SPY	ETF	431.9	431.955	430.61	431.08	2600421.0
2023-09-25 13:00:00	SPY	ETF	431.1	431.85	430.66	430.98	2295125.0
2023-09-25 13:30:00	SPY	ETF	430.99	431.5	430.62	431.47	2464833.0
2023-09-25 14:00:00	SPY	ETF	431.48	431.73	430.85	430.995	2635551.0
2023-09-25 14:30:00	SPY	ETF	430.986	431.6801	430.78	430.84	3118519.0
2023-09-25 15:00:00	SPY	ETF	430.86	431.46	429.98	431.0597	5266882.0
2023-09-25 15:30:00	SPY	ETF	431.05	432.27	430.82	432.22	7846125.0
2023-09-25 16:00:00	SPY	ETF	432.22	432.57	430.1728	432.46	3713315.0
2023-09-25 16:30:00	SPY	ETF	432.46	432.61	432.42	432.55	231453.0
2023-09-25 17:00:00	SPY	ETF	432.61	432.64	432.23	432.57	66112.0
2023-09-25 17:30:00	SPY	ETF	432.59	432.59	432.51	432.53	17007.0
2023-09-25 18:00:00	SPY	ETF	432.53	432.53	432.24	432.31	50917.0
2023-09-25 18:30:00	SPY	ETF	432.31	432.35	432.29	432.32	24043.0
2023-09-25 19:00:00	SPY	ETF	432.28	432.28	432.15	432.21	14538.0
2023-09-25 19:30:00	SPY	ETF	432.17	432.23	432.1	432.1	26641.0
2023-09-25 04:00:00	QQQ	ETF	359.34	359.52	357.93	358.0	96052.0
2023-09-25 04:30:00	QQQ	ETF	357.85	357.85	356.35	357.3	132036.0
2023-09-25 05:00:00	QQQ	ETF	357.25	357.92	357.19	357.8	36437.0
2023-09-25 05:30:00	QQQ	ETF	357.79	357.79	357.17	357.7	29690.0
2023-09-25 06:00:00	QQQ	ETF	357.78	358.15	357.62	357.99	16534.0
2023-09-25 06:30:00	QQQ	ETF	358.05	358.05	357.29	357.82	20700.0
2023-09-25 07:00:00	QQQ	ETF	357.78	358.05	357.51	357.6	49442.0
2023-09-25 07:30:00	QQQ	ETF	357.55	357.56	356.71	356.9	162135.0
2023-09-25 08:00:00	QQQ	ETF	356.89	359.6	356.39	356.95	212919.0
2023-09-25 08:30:00	QQQ	ETF	356.92	357.46	356.79	356.89	273026.0
2023-09-25 09:00:00	QQQ	ETF	356.85	356.94	355.97	356.94	506101.0
2023-09-25 09:30:00	QQQ	ETF	356.93	358.68	355.93	358.18	5291856.0
2023-09-25 10:00:00	QQQ	ETF	358.2	358.4	356.725	357.0389	3010754.0
2023-09-25 10:30:00	QQQ	ETF	357.02	357.93	356.78	356.79	2396385.0
2023-09-25 11:00:00	QQQ	ETF	356.786	359.17	356.77	358.67	3215252.0
2023-09-25 11:30:00	QQQ	ETF	358.68	359.27	358.57	358.77	1785215.0
2023-09-25 12:00:00	QQQ	ETF	358.76	359.6	358.38	359.4375	1485784.0
2023-09-25 12:30:00	QQQ	ETF	359.47	359.5	357.91	358.35	1561168.0

> showing 50 of 28,339 rows — these rows as CSV

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