PREVIEW / etf_30min / 2024-10-18

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-18.parquet
  size:    843 KB
  rows:    33,689

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-10-18 04:00:00	SPY	ETF	583.0	583.96	583.0	583.73	10757.0
2024-10-18 04:30:00	SPY	ETF	583.6	583.76	583.5	583.76	3380.0
2024-10-18 05:00:00	SPY	ETF	583.76	583.98	583.67	583.84	16096.0
2024-10-18 05:30:00	SPY	ETF	583.56	583.56	583.36	583.36	1998.0
2024-10-18 06:00:00	SPY	ETF	583.32	583.59	583.24	583.59	7736.0
2024-10-18 06:30:00	SPY	ETF	583.59	583.67	583.55	583.65	9131.0
2024-10-18 07:00:00	SPY	ETF	583.64	583.99	583.28	583.95	271057.0
2024-10-18 07:30:00	SPY	ETF	583.81	584.0	583.8	583.82	39540.0
2024-10-18 08:00:00	SPY	ETF	583.85	583.96	582.48	583.7979	48825.0
2024-10-18 08:30:00	SPY	ETF	583.85	584.11	583.85	583.93	78200.0
2024-10-18 09:00:00	SPY	ETF	584.0	584.5	583.58	584.07	196723.0
2024-10-18 09:30:00	SPY	ETF	584.07	584.22	582.58	583.28	2855214.0
2024-10-18 10:00:00	SPY	ETF	583.27	584.03	583.11	583.4712	1444673.0
2024-10-18 10:30:00	SPY	ETF	583.4911	583.89	583.06	583.43	1000016.0
2024-10-18 11:00:00	SPY	ETF	583.4199	584.33	583.3701	584.2501	963542.0
2024-10-18 11:30:00	SPY	ETF	584.26	584.47	583.72	583.885	861588.0
2024-10-18 12:00:00	SPY	ETF	583.89	584.295	583.6901	584.15	529908.0
2024-10-18 12:30:00	SPY	ETF	584.17	585.25	584.11	584.675	1161371.0
2024-10-18 13:00:00	SPY	ETF	584.69	585.1198	584.53	584.62	1049143.0
2024-10-18 13:30:00	SPY	ETF	584.63	584.9699	584.4808	584.58	610283.0
2024-10-18 14:00:00	SPY	ETF	584.565	585.39	583.84	585.1798	1289710.0
2024-10-18 14:30:00	SPY	ETF	585.18	585.25	584.74	584.8515	516358.0
2024-10-18 15:00:00	SPY	ETF	584.85	584.85	584.22	584.46	1050139.0
2024-10-18 15:30:00	SPY	ETF	584.46	584.78	584.06	584.57	3465091.0
2024-10-18 16:00:00	SPY	ETF	584.53	584.9	584.36	584.69	2359698.0
2024-10-18 16:30:00	SPY	ETF	584.68	584.8	584.65	584.71	67823.0
2024-10-18 17:00:00	SPY	ETF	584.65	584.71	584.5804	584.7	13456.0
2024-10-18 17:30:00	SPY	ETF	584.69	584.75	584.5832	584.69	449400.0
2024-10-18 18:00:00	SPY	ETF	584.7	584.75	584.7	584.74	4138.0
2024-10-18 18:30:00	SPY	ETF	584.74	584.75	584.7	584.7	5008.0
2024-10-18 19:00:00	SPY	ETF	584.72	584.73	584.7	584.7	2249.0
2024-10-18 19:30:00	SPY	ETF	584.75	584.84	584.72	584.72	13788.0
2024-10-18 04:00:00	QQQ	ETF	493.81	494.06	493.51	493.82	37110.0
2024-10-18 04:30:00	QQQ	ETF	493.73	493.85	493.41	493.62	14084.0
2024-10-18 05:00:00	QQQ	ETF	493.72	494.01	493.65	493.7	18786.0
2024-10-18 05:30:00	QQQ	ETF	493.64	493.71	493.14	493.25	20916.0
2024-10-18 06:00:00	QQQ	ETF	493.32	493.57	493.01	493.57	62453.0
2024-10-18 06:30:00	QQQ	ETF	493.57	493.76	493.52	493.72	17107.0
2024-10-18 07:00:00	QQQ	ETF	493.68	494.28	493.43	494.2	61749.0
2024-10-18 07:30:00	QQQ	ETF	494.14	494.4	494.14	494.165	43234.0
2024-10-18 08:00:00	QQQ	ETF	494.2	494.4	490.882	494.2	71081.0
2024-10-18 08:30:00	QQQ	ETF	494.2	494.53	494.2	494.39	69898.0
2024-10-18 09:00:00	QQQ	ETF	494.4	495.05	493.94	494.12	384222.0
2024-10-18 09:30:00	QQQ	ETF	494.06	495.16	493.3	494.3293	2324422.0
2024-10-18 10:00:00	QQQ	ETF	494.4196	495.44	494.14	494.89	1193188.0
2024-10-18 10:30:00	QQQ	ETF	494.89	495.05	493.77	493.872	1037794.0
2024-10-18 11:00:00	QQQ	ETF	493.88	495.27	493.85	495.19	952350.0
2024-10-18 11:30:00	QQQ	ETF	495.2	495.57	493.96	494.1875	1157423.0
2024-10-18 12:00:00	QQQ	ETF	494.18	494.25	493.55	494.0	776199.0
2024-10-18 12:30:00	QQQ	ETF	494.0	495.4	493.99	494.83	969496.0

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

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