PREVIEW / etf_30min / 2024-04-30

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-30.parquet
  size:    803 KB
  rows:    32,013

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
2024-04-30 04:00:00	SPY	ETF	509.71	509.71	509.46	509.51	4949.0
2024-04-30 04:30:00	SPY	ETF	509.5	509.5	509.1	509.15	1719.0
2024-04-30 05:00:00	SPY	ETF	509.0	509.58	509.0	509.52	3150.0
2024-04-30 05:30:00	SPY	ETF	509.4	509.5	509.18	509.37	4889.0
2024-04-30 06:00:00	SPY	ETF	509.36	509.42	509.32	509.39	5037.0
2024-04-30 06:30:00	SPY	ETF	509.4	509.9	509.4	509.9	12801.0
2024-04-30 07:00:00	SPY	ETF	509.9	510.0	509.63	509.63	33476.0
2024-04-30 07:30:00	SPY	ETF	509.75	509.75	509.5	509.58	41230.0
2024-04-30 08:00:00	SPY	ETF	509.9002	509.93	509.18	509.72	101832.0
2024-04-30 08:30:00	SPY	ETF	509.7	509.7	507.54	508.14	623195.0
2024-04-30 09:00:00	SPY	ETF	508.19	508.75	507.89	508.56	264426.0
2024-04-30 09:30:00	SPY	ETF	508.56	509.54	508.2	509.1308	3504531.0
2024-04-30 10:00:00	SPY	ETF	509.16	509.56	508.31	508.32	2585269.0
2024-04-30 10:30:00	SPY	ETF	508.31	509.38	508.11	508.64	2524008.0
2024-04-30 11:00:00	SPY	ETF	508.65	508.66	506.4098	506.905	4175426.0
2024-04-30 11:30:00	SPY	ETF	506.91	506.95	506.03	506.61	2859478.0
2024-04-30 12:00:00	SPY	ETF	506.61	507.03	506.12	506.7	2298735.0
2024-04-30 12:30:00	SPY	ETF	506.7	506.7	504.8	505.29	3729256.0
2024-04-30 13:00:00	SPY	ETF	505.3	505.735	504.71	505.255	2801730.0
2024-04-30 13:30:00	SPY	ETF	505.25	506.265	505.11	506.11	2186652.0
2024-04-30 14:00:00	SPY	ETF	506.105	506.54	505.095	505.18	2790804.0
2024-04-30 14:30:00	SPY	ETF	505.19	505.78	504.4	504.795	3054279.0
2024-04-30 15:00:00	SPY	ETF	504.795	505.29	504.2	504.765	3719565.0
2024-04-30 15:30:00	SPY	ETF	504.77	505.17	502.03	502.04	12108461.0
2024-04-30 16:00:00	SPY	ETF	502.04	503.95	500.66	500.95	6456178.0
2024-04-30 16:30:00	SPY	ETF	500.91	501.36	500.9	501.0	239965.0
2024-04-30 17:00:00	SPY	ETF	501.0	501.98	500.8	501.05	190184.0
2024-04-30 17:30:00	SPY	ETF	501.01	501.01	500.15	500.35	98094.0
2024-04-30 18:00:00	SPY	ETF	500.4	501.17	500.4	500.97	132476.0
2024-04-30 18:30:00	SPY	ETF	500.98	501.2	500.98	501.12	27742.0
2024-04-30 19:00:00	SPY	ETF	501.06	501.43	500.99	501.1199	15109.0
2024-04-30 19:30:00	SPY	ETF	501.12	501.31	500.85	501.28	36137.0
2024-04-30 20:00:00	SPY	ETF	501.3	501.3	501.3	501.3	326.0
2024-04-30 04:00:00	QQQ	ETF	432.75	432.79	432.24	432.47	21513.0
2024-04-30 04:30:00	QQQ	ETF	432.49	432.51	432.0	432.0	19183.0
2024-04-30 05:00:00	QQQ	ETF	431.9	432.32	431.79	432.18	10793.0
2024-04-30 05:30:00	QQQ	ETF	432.25	432.32	431.93	431.93	4300.0
2024-04-30 06:00:00	QQQ	ETF	432.06	432.18	431.96	432.09	6223.0
2024-04-30 06:30:00	QQQ	ETF	432.08	432.55	432.02	432.51	22852.0
2024-04-30 07:00:00	QQQ	ETF	432.46	432.56	432.0	432.08	69925.0
2024-04-30 07:30:00	QQQ	ETF	432.17	432.32	432.0	432.08	47133.0
2024-04-30 08:00:00	QQQ	ETF	432.53	433.074	431.95	432.15	58763.0
2024-04-30 08:30:00	QQQ	ETF	432.04	432.05	430.07	430.9	410833.0
2024-04-30 09:00:00	QQQ	ETF	430.94	431.27	430.59	431.13	139914.0
2024-04-30 09:30:00	QQQ	ETF	431.15	432.36	430.87	431.97	2492438.0
2024-04-30 10:00:00	QQQ	ETF	431.9631	432.56	430.88	430.88	1729463.0
2024-04-30 10:30:00	QQQ	ETF	430.87	432.17	430.7	431.2	1512706.0
2024-04-30 11:00:00	QQQ	ETF	431.19	431.23	429.13	429.59	2095508.0
2024-04-30 11:30:00	QQQ	ETF	429.6	429.64	428.65	429.43	1647246.0
2024-04-30 12:00:00	QQQ	ETF	429.43	429.6995	428.8416	429.45	1264086.0

> showing 50 of 32,013 rows — these rows as CSV

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