PREVIEW / etf_30min / 2024-08-01

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-01.parquet
  size:    856 KB
  rows:    34,747

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-08-01 04:00:00	SPY	ETF	552.26	552.35	550.69	551.32	31744.0
2024-08-01 04:30:00	SPY	ETF	551.26	551.62	550.67	551.09	17795.0
2024-08-01 05:00:00	SPY	ETF	551.07	552.07	551.0	551.63	22445.0
2024-08-01 05:30:00	SPY	ETF	551.6	552.53	551.56	552.46	129476.0
2024-08-01 06:00:00	SPY	ETF	552.66	552.73	552.34	552.69	7949.0
2024-08-01 06:30:00	SPY	ETF	552.64	552.82	552.25	552.82	19906.0
2024-08-01 07:00:00	SPY	ETF	552.82	553.33	552.73	553.33	90407.0
2024-08-01 07:30:00	SPY	ETF	553.31	553.48	552.4	552.47	133797.0
2024-08-01 08:00:00	SPY	ETF	552.87	554.01	551.0496	553.53	174885.0
2024-08-01 08:30:00	SPY	ETF	553.41	554.08	552.59	553.5	363399.0
2024-08-01 09:00:00	SPY	ETF	553.5	553.59	552.1	552.55	316434.0
2024-08-01 09:30:00	SPY	ETF	552.57	554.8688	552.32	554.04	4131767.0
2024-08-01 10:00:00	SPY	ETF	553.99	554.33	549.81	549.8301	4144181.0
2024-08-01 10:30:00	SPY	ETF	549.87	550.25	547.24	547.47	3883047.0
2024-08-01 11:00:00	SPY	ETF	547.47	547.68	546.0	546.17	2653559.0
2024-08-01 11:30:00	SPY	ETF	546.11	546.58	544.17	544.72	2883965.0
2024-08-01 12:00:00	SPY	ETF	544.72	546.4054	544.39	545.03	2959711.0
2024-08-01 12:30:00	SPY	ETF	545.05	545.05	543.14	543.74	2819131.0
2024-08-01 13:00:00	SPY	ETF	543.73	543.95	541.82	542.3	2714398.0
2024-08-01 13:30:00	SPY	ETF	542.3	542.6	540.47	542.56	3304219.0
2024-08-01 14:00:00	SPY	ETF	542.54	542.8596	539.8199	540.26	3441806.0
2024-08-01 14:30:00	SPY	ETF	540.24	540.83	539.43	539.9789	2738539.0
2024-08-01 15:00:00	SPY	ETF	539.975	541.7	539.7	541.47	3067658.0
2024-08-01 15:30:00	SPY	ETF	541.46	543.47	541.16	543.04	11814542.0
2024-08-01 16:00:00	SPY	ETF	543.04	543.44	539.79	540.58	3332993.0
2024-08-01 16:30:00	SPY	ETF	540.5	542.19	540.22	542.03	306634.0
2024-08-01 17:00:00	SPY	ETF	542.1	542.2	540.67	540.67	300246.0
2024-08-01 17:30:00	SPY	ETF	540.85	541.67	540.7201	541.21	127167.0
2024-08-01 18:00:00	SPY	ETF	541.31	542.21	540.18	541.5	146522.0
2024-08-01 18:30:00	SPY	ETF	541.69	541.69	539.7	540.2	70189.0
2024-08-01 19:00:00	SPY	ETF	540.24	541.58	539.97	541.58	34273.0
2024-08-01 19:30:00	SPY	ETF	541.5	541.7195	541.1084	541.1084	33157.0
2024-08-01 04:00:00	QQQ	ETF	474.9	474.9	471.5	472.29	93915.0
2024-08-01 04:30:00	QQQ	ETF	472.23	472.66	471.3	471.78	96264.0
2024-08-01 05:00:00	QQQ	ETF	471.68	473.1	471.58	472.59	31369.0
2024-08-01 05:30:00	QQQ	ETF	472.85	473.61	472.85	473.28	14675.0
2024-08-01 06:00:00	QQQ	ETF	473.37	473.71	473.04	473.52	27205.0
2024-08-01 06:30:00	QQQ	ETF	473.5	473.5	472.6	473.32	18314.0
2024-08-01 07:00:00	QQQ	ETF	473.31	474.32	473.25	474.22	91898.0
2024-08-01 07:30:00	QQQ	ETF	474.26	474.32	472.9	473.03	149484.0
2024-08-01 08:00:00	QQQ	ETF	472.98	475.61	470.717	474.05	238094.0
2024-08-01 08:30:00	QQQ	ETF	474.1	475.02	472.5	473.3901	198539.0
2024-08-01 09:00:00	QQQ	ETF	473.45	473.7	471.2	471.72	302536.0
2024-08-01 09:30:00	QQQ	ETF	471.76	475.55	471.3001	474.71	3601057.0
2024-08-01 10:00:00	QQQ	ETF	474.62	475.17	469.84	469.87	2424447.0
2024-08-01 10:30:00	QQQ	ETF	469.92	470.46	467.0501	467.37	2920296.0
2024-08-01 11:00:00	QQQ	ETF	467.36	467.67	465.17	465.46	2654684.0
2024-08-01 11:30:00	QQQ	ETF	465.5	465.95	462.66	463.06	2963392.0
2024-08-01 12:00:00	QQQ	ETF	463.05	464.86	462.01	462.831	2459929.0
2024-08-01 12:30:00	QQQ	ETF	462.815	462.89	460.97	461.36	2103525.0

> showing 50 of 34,747 rows — these rows as CSV

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