PREVIEW / etf_30min / 2024-07-18

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-18.parquet
  size:    852 KB
  rows:    33,607

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-07-18 04:00:00	SPY	ETF	558.27	558.35	557.89	558.13	10787.0
2024-07-18 04:30:00	SPY	ETF	558.26	558.85	558.26	558.84	5822.0
2024-07-18 05:00:00	SPY	ETF	558.82	559.0	558.75	558.75	1506.0
2024-07-18 05:30:00	SPY	ETF	558.5	558.5	557.82	557.93	10349.0
2024-07-18 06:00:00	SPY	ETF	558.02	558.02	557.16	557.41	7816.0
2024-07-18 06:30:00	SPY	ETF	557.5	558.05	557.42	557.99	36712.0
2024-07-18 07:00:00	SPY	ETF	557.92	558.01	557.71	557.81	123090.0
2024-07-18 07:30:00	SPY	ETF	557.8	558.289	557.74	558.27	120322.0
2024-07-18 08:00:00	SPY	ETF	557.75	559.5	557.61	558.3	78814.0
2024-07-18 08:30:00	SPY	ETF	558.4	558.89	558.25	558.8	142890.0
2024-07-18 09:00:00	SPY	ETF	558.79	559.1	558.36	558.48	197845.0
2024-07-18 09:30:00	SPY	ETF	558.51	558.89	557.705	558.845	3497464.0
2024-07-18 10:00:00	SPY	ETF	558.835	559.52	558.421	558.84	2371769.0
2024-07-18 10:30:00	SPY	ETF	558.83	558.83	555.639	556.87	3512446.0
2024-07-18 11:00:00	SPY	ETF	556.84	557.14	553.78	553.8105	2693044.0
2024-07-18 11:30:00	SPY	ETF	553.8	554.38	552.75	552.94	2991996.0
2024-07-18 12:00:00	SPY	ETF	552.93	553.56	552.38	552.92	2067215.0
2024-07-18 12:30:00	SPY	ETF	552.88	554.31	552.69	554.29	1582213.0
2024-07-18 13:00:00	SPY	ETF	554.295	554.945	553.46	554.37	1223688.0
2024-07-18 13:30:00	SPY	ETF	554.37	554.81	553.49	553.65	1001126.0
2024-07-18 14:00:00	SPY	ETF	553.69	553.74	552.57	552.58	1878014.0
2024-07-18 14:30:00	SPY	ETF	552.56	552.87	551.426	552.38	2918463.0
2024-07-18 15:00:00	SPY	ETF	552.37	552.84	550.43	551.45	3559806.0
2024-07-18 15:30:00	SPY	ETF	551.44	553.85	551.14	552.66	8995660.0
2024-07-18 16:00:00	SPY	ETF	552.66	553.24	552.48	553.15	3445309.0
2024-07-18 16:30:00	SPY	ETF	553.15	553.6	553.14	553.46	86616.0
2024-07-18 17:00:00	SPY	ETF	553.31	553.74	552.66	553.72	39584.0
2024-07-18 17:30:00	SPY	ETF	553.72	553.75	553.65	553.74	27276.0
2024-07-18 18:00:00	SPY	ETF	553.69	553.92	553.5	553.52	157183.0
2024-07-18 18:30:00	SPY	ETF	553.54	553.88	553.43	553.8	9187.0
2024-07-18 19:00:00	SPY	ETF	553.77	553.8101	553.65	553.81	9841.0
2024-07-18 19:30:00	SPY	ETF	553.84	553.86	553.5	553.6	30548.0
2024-07-18 04:00:00	QQQ	ETF	483.55	484.56	483.55	483.9	30144.0
2024-07-18 04:30:00	QQQ	ETF	483.9	485.14	483.84	485.14	40006.0
2024-07-18 05:00:00	QQQ	ETF	485.15	485.19	484.5	484.5	29279.0
2024-07-18 05:30:00	QQQ	ETF	484.49	484.49	483.6	483.64	80282.0
2024-07-18 06:00:00	QQQ	ETF	483.42	483.46	482.57	483.1	45579.0
2024-07-18 06:30:00	QQQ	ETF	483.32	484.0	483.32	483.92	46736.0
2024-07-18 07:00:00	QQQ	ETF	483.84	484.1	483.56	483.7	119930.0
2024-07-18 07:30:00	QQQ	ETF	483.65	484.29	483.64	484.22	55509.0
2024-07-18 08:00:00	QQQ	ETF	483.83	485.9	482.131	484.73	227510.0
2024-07-18 08:30:00	QQQ	ETF	484.78	485.68	484.6	485.63	469814.0
2024-07-18 09:00:00	QQQ	ETF	485.63	486.04	485.35	485.48	336154.0
2024-07-18 09:30:00	QQQ	ETF	485.52	485.71	482.56	483.71	4055805.0
2024-07-18 10:00:00	QQQ	ETF	483.67	484.655	483.07	483.238	1985804.0
2024-07-18 10:30:00	QQQ	ETF	483.22	483.22	479.47	481.78	4099714.0
2024-07-18 11:00:00	QQQ	ETF	481.8	482.15	477.615	477.74	3035611.0
2024-07-18 11:30:00	QQQ	ETF	477.74	478.7199	476.8625	477.16	2655371.0
2024-07-18 12:00:00	QQQ	ETF	477.14	478.28	476.58	478.04	2011651.0
2024-07-18 12:30:00	QQQ	ETF	478.03	479.99	477.73	479.96	1887021.0

> showing 50 of 33,607 rows — these rows as CSV

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