PREVIEW / etf_30min / 2024-09-24

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-09-24.parquet
  size:    853 KB
  rows:    34,373

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-24 04:00:00	SPY	ETF	570.22	571.41	570.22	571.38	7942.0
2024-09-24 04:30:00	SPY	ETF	571.23	571.34	571.01	571.34	2482.0
2024-09-24 05:00:00	SPY	ETF	571.19	571.26	570.71	570.88	14157.0
2024-09-24 05:30:00	SPY	ETF	570.85	570.87	570.59	570.74	3588.0
2024-09-24 06:00:00	SPY	ETF	570.67	570.98	570.67	570.83	15741.0
2024-09-24 06:30:00	SPY	ETF	570.95	571.09	570.2	570.21	9147.0
2024-09-24 07:00:00	SPY	ETF	570.17	570.33	569.1	569.841	65130.0
2024-09-24 07:30:00	SPY	ETF	569.95	570.541	569.91	570.08	136062.0
2024-09-24 08:00:00	SPY	ETF	570.1	571.38	568.91	570.16	179164.0
2024-09-24 08:30:00	SPY	ETF	570.12	570.3	569.76	570.21	123774.0
2024-09-24 09:00:00	SPY	ETF	570.3	570.8	570.28	570.47	140818.0
2024-09-24 09:30:00	SPY	ETF	570.47	570.55	569.23	569.332	3130452.0
2024-09-24 10:00:00	SPY	ETF	569.34	569.357	567.71	568.2784	3134910.0
2024-09-24 10:30:00	SPY	ETF	568.28	569.7015	567.6	569.4988	2133349.0
2024-09-24 11:00:00	SPY	ETF	569.49	570.0699	569.32	569.8505	1483344.0
2024-09-24 11:30:00	SPY	ETF	569.87	571.07	569.73	570.6	1671095.0
2024-09-24 12:00:00	SPY	ETF	570.61	570.89	570.26	570.505	933047.0
2024-09-24 12:30:00	SPY	ETF	570.5	571.2	570.37	570.4475	1566913.0
2024-09-24 13:00:00	SPY	ETF	570.445	570.98	570.27	570.61	653462.0
2024-09-24 13:30:00	SPY	ETF	570.61	571.01	570.43	570.465	726460.0
2024-09-24 14:00:00	SPY	ETF	570.5	570.6991	570.07	570.2325	1147551.0
2024-09-24 14:30:00	SPY	ETF	570.25	570.63	569.43	570.45	1112498.0
2024-09-24 15:00:00	SPY	ETF	570.43	570.75	570.36	570.6399	2020883.0
2024-09-24 15:30:00	SPY	ETF	570.64	571.36	570.38	571.24	6199927.0
2024-09-24 16:00:00	SPY	ETF	571.24	571.36	570.85	571.27	5778108.0
2024-09-24 16:30:00	SPY	ETF	571.2	571.4	571.17	571.21	155817.0
2024-09-24 17:00:00	SPY	ETF	571.2	571.3	571.2	571.24	23351.0
2024-09-24 17:30:00	SPY	ETF	571.2	571.27	571.2	571.24	20119.0
2024-09-24 18:00:00	SPY	ETF	571.31	571.34	571.18	571.18	19078.0
2024-09-24 18:30:00	SPY	ETF	571.17	571.26	571.1	571.26	9126.0
2024-09-24 19:00:00	SPY	ETF	571.29	571.39	571.29	571.34	2116.0
2024-09-24 19:30:00	SPY	ETF	571.34	571.34	571.19	571.22	27029.0
2024-09-24 04:00:00	QQQ	ETF	483.72	485.5	483.72	485.41	43434.0
2024-09-24 04:30:00	QQQ	ETF	485.36	485.37	484.86	485.19	12034.0
2024-09-24 05:00:00	QQQ	ETF	485.15	485.19	484.46	484.7	11011.0
2024-09-24 05:30:00	QQQ	ETF	484.65	484.75	484.2	484.37	7181.0
2024-09-24 06:00:00	QQQ	ETF	484.27	484.73	484.25	484.63	7343.0
2024-09-24 06:30:00	QQQ	ETF	484.65	484.91	484.0	484.02	11938.0
2024-09-24 07:00:00	QQQ	ETF	484.03	484.12	482.5	483.4	69610.0
2024-09-24 07:30:00	QQQ	ETF	483.4	484.23	483.4	483.76	64405.0
2024-09-24 08:00:00	QQQ	ETF	483.9901	485.4504	482.34	483.86	85273.0
2024-09-24 08:30:00	QQQ	ETF	483.8	484.0593	483.33	483.96	55980.0
2024-09-24 09:00:00	QQQ	ETF	484.0	484.64	483.97	484.48	99442.0
2024-09-24 09:30:00	QQQ	ETF	484.48	484.89	483.21	483.35	1825233.0
2024-09-24 10:00:00	QQQ	ETF	483.35	483.3971	480.43	480.97	2585725.0
2024-09-24 10:30:00	QQQ	ETF	480.985	483.07	480.17	483.0315	1908978.0
2024-09-24 11:00:00	QQQ	ETF	483.03	484.21	482.91	483.97	1692991.0
2024-09-24 11:30:00	QQQ	ETF	483.98	486.33	483.92	485.67	2220473.0
2024-09-24 12:00:00	QQQ	ETF	485.67	486.3	485.31	485.71	1414116.0
2024-09-24 12:30:00	QQQ	ETF	485.72	486.26	485.05	485.1	1046883.0

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

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