PREVIEW / etf_30min / 2024-06-24

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-24.parquet
  size:    815 KB
  rows:    32,642

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-06-24 04:00:00	SPY	ETF	545.12	545.73	544.4	545.73	16926.0
2024-06-24 04:30:00	SPY	ETF	545.6	545.6	545.37	545.38	4402.0
2024-06-24 05:00:00	SPY	ETF	545.49	545.49	545.18	545.25	4733.0
2024-06-24 05:30:00	SPY	ETF	545.1	545.11	544.63	544.87	6353.0
2024-06-24 06:00:00	SPY	ETF	544.95	545.08	544.83	545.08	2061.0
2024-06-24 06:30:00	SPY	ETF	545.01	545.32	544.95	545.26	11076.0
2024-06-24 07:00:00	SPY	ETF	545.25	545.4	544.91	545.01	26976.0
2024-06-24 07:30:00	SPY	ETF	545.01	545.25	544.85	544.91	41262.0
2024-06-24 08:00:00	SPY	ETF	545.27	545.4	543.8	545.04	51049.0
2024-06-24 08:30:00	SPY	ETF	545.04	545.1	544.33	544.39	64217.0
2024-06-24 09:00:00	SPY	ETF	544.39	544.46	543.97	544.34	134228.0
2024-06-24 09:30:00	SPY	ETF	544.33	545.802	543.76	545.655	3180672.0
2024-06-24 10:00:00	SPY	ETF	545.65	546.95	545.25	545.44	2840401.0
2024-06-24 10:30:00	SPY	ETF	545.43	546.355	544.66	545.98	2259833.0
2024-06-24 11:00:00	SPY	ETF	545.97	546.34	545.54	546.14	1576838.0
2024-06-24 11:30:00	SPY	ETF	546.145	546.28	545.69	546.17	827716.0
2024-06-24 12:00:00	SPY	ETF	546.15	546.226	545.57	545.965	823997.0
2024-06-24 12:30:00	SPY	ETF	545.965	546.18	544.85	545.0999	828825.0
2024-06-24 13:00:00	SPY	ETF	545.1	545.3	544.0	544.25	1627381.0
2024-06-24 13:30:00	SPY	ETF	544.27	544.54	543.61	543.975	1202095.0
2024-06-24 14:00:00	SPY	ETF	543.98	544.0601	543.425	543.77	1483129.0
2024-06-24 14:30:00	SPY	ETF	543.77	544.6172	543.48	544.225	1804787.0
2024-06-24 15:00:00	SPY	ETF	544.22	544.66	543.98	544.23	1499594.0
2024-06-24 15:30:00	SPY	ETF	544.24	544.42	542.63	542.65	7043354.0
2024-06-24 16:00:00	SPY	ETF	542.63	542.91	542.21	542.48	3707695.0
2024-06-24 16:30:00	SPY	ETF	542.5	542.79	542.39	542.79	101991.0
2024-06-24 17:00:00	SPY	ETF	542.7989	542.95	542.75	542.85	48558.0
2024-06-24 17:30:00	SPY	ETF	542.86	542.92	542.82	542.88	20611.0
2024-06-24 18:00:00	SPY	ETF	542.84	543.02	542.64	542.93	417159.0
2024-06-24 18:30:00	SPY	ETF	542.95	542.98	542.91	542.96	3530.0
2024-06-24 19:00:00	SPY	ETF	542.9	543.05	542.89	543.05	4698.0
2024-06-24 19:30:00	SPY	ETF	543.11	543.11	542.98	543.08	6474.0
2024-06-24 04:00:00	QQQ	ETF	480.0	480.71	479.82	480.66	28310.0
2024-06-24 04:30:00	QQQ	ETF	480.6	480.64	480.07	480.2	9777.0
2024-06-24 05:00:00	QQQ	ETF	480.04	480.22	479.63	479.7	15425.0
2024-06-24 05:30:00	QQQ	ETF	479.63	479.64	478.57	478.83	49877.0
2024-06-24 06:00:00	QQQ	ETF	479.0	479.17	478.8	479.17	22137.0
2024-06-24 06:30:00	QQQ	ETF	479.15	479.42	478.99	479.29	20101.0
2024-06-24 07:00:00	QQQ	ETF	479.25	479.64	479.12	479.219	78084.0
2024-06-24 07:30:00	QQQ	ETF	479.16	479.55	478.89	478.91	76290.0
2024-06-24 08:00:00	QQQ	ETF	479.41	480.57	478.31	479.24	112070.0
2024-06-24 08:30:00	QQQ	ETF	479.13	479.13	478.21	478.45	134054.0
2024-06-24 09:00:00	QQQ	ETF	478.45	478.48	477.55	478.16	223680.0
2024-06-24 09:30:00	QQQ	ETF	478.18	479.21	476.82	478.7	2877693.0
2024-06-24 10:00:00	QQQ	ETF	478.73	479.93	477.22	477.47	1885012.0
2024-06-24 10:30:00	QQQ	ETF	477.48	478.64	475.77	477.79	2377525.0
2024-06-24 11:00:00	QQQ	ETF	477.8	478.42	477.0	477.91	1342846.0
2024-06-24 11:30:00	QQQ	ETF	477.9186	478.25	477.3	478.07	826487.0
2024-06-24 12:00:00	QQQ	ETF	478.06	478.1599	477.171	477.68	748799.0
2024-06-24 12:30:00	QQQ	ETF	477.68	478.06	476.26	476.49	725843.0

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

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