PREVIEW / etf_30min / 2024-09-25

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-09-25.parquet
  size:    826 KB
  rows:    33,146

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-09-25 04:00:00	SPY	ETF	570.4	570.61	570.3	570.31	14186.0
2024-09-25 04:30:00	SPY	ETF	570.31	570.42	570.26	570.38	2600.0
2024-09-25 05:00:00	SPY	ETF	570.39	570.51	570.09	570.31	7246.0
2024-09-25 05:30:00	SPY	ETF	570.6	570.6	570.4	570.4	593.0
2024-09-25 06:00:00	SPY	ETF	570.69	571.0	570.69	570.97	11091.0
2024-09-25 06:30:00	SPY	ETF	571.09	571.15	570.68	571.15	7096.0
2024-09-25 07:00:00	SPY	ETF	571.15	571.3	571.051	571.13	11838.0
2024-09-25 07:30:00	SPY	ETF	571.02	571.14	570.87	571.1	20618.0
2024-09-25 08:00:00	SPY	ETF	570.42	571.21	569.68	571.0483	78875.0
2024-09-25 08:30:00	SPY	ETF	571.0221	571.2396	570.86	571.1	72693.0
2024-09-25 09:00:00	SPY	ETF	571.07	571.29	570.931	571.15	89964.0
2024-09-25 09:30:00	SPY	ETF	571.14	571.8281	570.86	571.54	3705863.0
2024-09-25 10:00:00	SPY	ETF	571.58	571.89	570.9	571.0999	1920528.0
2024-09-25 10:30:00	SPY	ETF	571.1	571.4198	570.6	571.23	1371084.0
2024-09-25 11:00:00	SPY	ETF	571.24	571.41	570.69	570.77	1262183.0
2024-09-25 11:30:00	SPY	ETF	570.75	571.25	570.32	570.74	1298035.0
2024-09-25 12:00:00	SPY	ETF	570.74	570.83	570.26	570.64	1055201.0
2024-09-25 12:30:00	SPY	ETF	570.63	570.64	569.88	569.99	1463631.0
2024-09-25 13:00:00	SPY	ETF	569.98	570.21	569.1	569.75	1634109.0
2024-09-25 13:30:00	SPY	ETF	569.72	570.32	568.91	570.2719	1881222.0
2024-09-25 14:00:00	SPY	ETF	570.25	570.38	569.03	570.2	1375711.0
2024-09-25 14:30:00	SPY	ETF	570.17	570.28	569.77	570.025	1078032.0
2024-09-25 15:00:00	SPY	ETF	570.02	570.26	569.7	569.865	1164353.0
2024-09-25 15:30:00	SPY	ETF	569.835	570.14	569.33	570.0	4677414.0
2024-09-25 16:00:00	SPY	ETF	570.0	570.5	569.84	570.28	3055054.0
2024-09-25 16:30:00	SPY	ETF	570.27	570.39	569.9434	570.3	101884.0
2024-09-25 17:00:00	SPY	ETF	570.26	570.5	570.22	570.27	25184.0
2024-09-25 17:30:00	SPY	ETF	570.43	570.54	570.3	570.4035	18108.0
2024-09-25 18:00:00	SPY	ETF	570.4	570.4	570.12	570.22	20686.0
2024-09-25 18:30:00	SPY	ETF	570.2	570.57	570.2	570.47	18324.0
2024-09-25 19:00:00	SPY	ETF	570.46	570.53	570.36	570.51	19352.0
2024-09-25 19:30:00	SPY	ETF	570.51	571.0	570.51	570.94	42732.0
2024-09-25 04:00:00	QQQ	ETF	484.16	484.2	483.6	483.78	15549.0
2024-09-25 04:30:00	QQQ	ETF	483.72	483.83	483.41	483.62	13502.0
2024-09-25 05:00:00	QQQ	ETF	483.61	483.77	483.26	483.4	14866.0
2024-09-25 05:30:00	QQQ	ETF	483.41	483.98	483.41	483.92	5165.0
2024-09-25 06:00:00	QQQ	ETF	483.97	484.56	483.97	484.4	16458.0
2024-09-25 06:30:00	QQQ	ETF	484.36	484.45	483.95	484.45	20538.0
2024-09-25 07:00:00	QQQ	ETF	484.49	484.66	484.35	484.36	65619.0
2024-09-25 07:30:00	QQQ	ETF	484.46	484.7	484.29	484.67	13148.0
2024-09-25 08:00:00	QQQ	ETF	484.67	484.86	483.0	484.75	57977.0
2024-09-25 08:30:00	QQQ	ETF	484.77	485.07	484.67	484.93	41928.0
2024-09-25 09:00:00	QQQ	ETF	484.9002	484.96	484.7	484.81	57015.0
2024-09-25 09:30:00	QQQ	ETF	484.74	486.93	484.68	486.9199	2223154.0
2024-09-25 10:00:00	QQQ	ETF	486.89	487.79	486.65	486.7	1895770.0
2024-09-25 10:30:00	QQQ	ETF	486.71	487.25	486.22	486.7742	1048867.0
2024-09-25 11:00:00	QQQ	ETF	486.8	487.17	486.12	486.13	908132.0
2024-09-25 11:30:00	QQQ	ETF	486.11	487.07	485.6	486.2575	1314847.0
2024-09-25 12:00:00	QQQ	ETF	486.23	486.47	485.38	486.31	771485.0
2024-09-25 12:30:00	QQQ	ETF	486.3011	486.405	485.44	485.58	773295.0

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

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