PREVIEW / etf_30min / 2024-07-05

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-05.parquet
  size:    808 KB
  rows:    32,578

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-05 04:00:00	SPY	ETF	551.95	552.16	551.89	551.94	16013.0
2024-07-05 04:30:00	SPY	ETF	551.7	551.75	551.7	551.75	2613.0
2024-07-05 05:00:00	SPY	ETF	551.68	551.83	551.63	551.83	1307.0
2024-07-05 05:30:00	SPY	ETF	551.76	551.87	551.76	551.83	314.0
2024-07-05 06:00:00	SPY	ETF	551.74	551.76	551.68	551.74	3799.0
2024-07-05 06:30:00	SPY	ETF	551.73	551.8	551.67	551.71	5098.0
2024-07-05 07:00:00	SPY	ETF	551.62	551.74	551.53	551.74	21851.0
2024-07-05 07:30:00	SPY	ETF	551.76	551.79	551.43	551.47	55728.0
2024-07-05 08:00:00	SPY	ETF	551.66	552.21	551.36	551.89	140241.0
2024-07-05 08:30:00	SPY	ETF	552.0	552.92	551.0	551.66	474921.0
2024-07-05 09:00:00	SPY	ETF	551.66	551.81	551.38	551.77	151544.0
2024-07-05 09:30:00	SPY	ETF	551.77	552.53	551.39	552.53	2649892.0
2024-07-05 10:00:00	SPY	ETF	552.54	552.775	551.12	552.095	2003479.0
2024-07-05 10:30:00	SPY	ETF	552.1	552.84	551.798	552.355	1650969.0
2024-07-05 11:00:00	SPY	ETF	552.35	553.14	552.1	552.91	1699615.0
2024-07-05 11:30:00	SPY	ETF	552.89	553.72	552.8629	553.535	1236285.0
2024-07-05 12:00:00	SPY	ETF	553.53	553.76	553.1863	553.61	1007840.0
2024-07-05 12:30:00	SPY	ETF	553.6	553.6	553.1	553.505	756853.0
2024-07-05 13:00:00	SPY	ETF	553.505	553.986	553.29	553.8648	785694.0
2024-07-05 13:30:00	SPY	ETF	553.87	554.52	553.84	554.27	1306924.0
2024-07-05 14:00:00	SPY	ETF	554.28	554.4	553.92	554.04	1318861.0
2024-07-05 14:30:00	SPY	ETF	554.04	554.43	553.86	554.37	989182.0
2024-07-05 15:00:00	SPY	ETF	554.36	554.61	554.24	554.35	2029869.0
2024-07-05 15:30:00	SPY	ETF	554.35	555.05	554.25	554.7	6421225.0
2024-07-05 16:00:00	SPY	ETF	554.7	554.79	552.2221	554.41	2578293.0
2024-07-05 16:30:00	SPY	ETF	554.4	554.69	554.02	554.09	175531.0
2024-07-05 17:00:00	SPY	ETF	554.04	554.1	554.0	554.0	39031.0
2024-07-05 17:30:00	SPY	ETF	554.08	554.08	553.93	553.97	10289.0
2024-07-05 18:00:00	SPY	ETF	554.1123	554.1123	553.95	554.1	2358.0
2024-07-05 18:30:00	SPY	ETF	554.08	554.09	554.0066	554.0066	2464.0
2024-07-05 19:00:00	SPY	ETF	554.09	554.09	554.02	554.07	34665.0
2024-07-05 19:30:00	SPY	ETF	554.07	554.17	554.0601	554.12	14698.0
2024-07-05 04:00:00	QQQ	ETF	491.35	492.28	491.04	492.0	35941.0
2024-07-05 04:30:00	QQQ	ETF	491.96	492.06	491.55	491.63	18786.0
2024-07-05 05:00:00	QQQ	ETF	491.65	491.8	491.61	491.73	6021.0
2024-07-05 05:30:00	QQQ	ETF	491.94	491.96	491.69	491.74	14045.0
2024-07-05 06:00:00	QQQ	ETF	491.65	491.8	491.62	491.75	4993.0
2024-07-05 06:30:00	QQQ	ETF	491.82	492.09	491.79	491.9	17411.0
2024-07-05 07:00:00	QQQ	ETF	491.89	492.04	491.84	491.96	27622.0
2024-07-05 07:30:00	QQQ	ETF	491.97	492.01	491.59	491.67	44807.0
2024-07-05 08:00:00	QQQ	ETF	491.97	492.27	491.28	492.19	85399.0
2024-07-05 08:30:00	QQQ	ETF	492.25	493.13	490.1527	491.64	227078.0
2024-07-05 09:00:00	QQQ	ETF	491.51	491.97	491.17	491.97	104217.0
2024-07-05 09:30:00	QQQ	ETF	491.9	493.7	491.59	493.61	2971445.0
2024-07-05 10:00:00	QQQ	ETF	493.66	494.3397	492.406	493.69	2031399.0
2024-07-05 10:30:00	QQQ	ETF	493.7	494.51	493.07	493.83	1364288.0
2024-07-05 11:00:00	QQQ	ETF	493.82	494.89	493.52	494.68	1388901.0
2024-07-05 11:30:00	QQQ	ETF	494.68	495.78	494.67	495.53	1526140.0
2024-07-05 12:00:00	QQQ	ETF	495.54	496.025	495.2	495.99	1177868.0
2024-07-05 12:30:00	QQQ	ETF	495.98	496.01	495.08	495.365	1057279.0

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

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