PREVIEW / etf_30min / 2024-02-23

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-23.parquet
  size:    791 KB
  rows:    31,503

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-02-23 04:00:00	SPY	ETF	507.47	507.53	507.06	507.13	9923.0
2024-02-23 04:30:00	SPY	ETF	507.14	507.34	507.09	507.31	8274.0
2024-02-23 05:00:00	SPY	ETF	507.33	507.47	507.2	507.46	4492.0
2024-02-23 05:30:00	SPY	ETF	507.53	507.78	507.49	507.49	7399.0
2024-02-23 06:00:00	SPY	ETF	507.48	507.78	507.48	507.73	5188.0
2024-02-23 06:30:00	SPY	ETF	507.61	507.81	507.57	507.65	7802.0
2024-02-23 07:00:00	SPY	ETF	507.79	507.96	507.64	507.96	14182.0
2024-02-23 07:30:00	SPY	ETF	507.98	508.08	507.79	507.86	31092.0
2024-02-23 08:00:00	SPY	ETF	507.7894	508.35	507.3	508.22	50109.0
2024-02-23 08:30:00	SPY	ETF	508.22	508.62	508.09	508.59	76781.0
2024-02-23 09:00:00	SPY	ETF	508.55	509.43	508.53	509.25	264435.0
2024-02-23 09:30:00	SPY	ETF	509.25	510.13	509.11	509.74	5380061.0
2024-02-23 10:00:00	SPY	ETF	509.75	509.94	509.2	509.23	2364183.0
2024-02-23 10:30:00	SPY	ETF	509.24	509.6599	508.42	508.69	3161857.0
2024-02-23 11:00:00	SPY	ETF	508.7	508.79	507.1	508.18	4201130.0
2024-02-23 11:30:00	SPY	ETF	508.19	508.55	507.75	508.51	2880023.0
2024-02-23 12:00:00	SPY	ETF	508.505	508.995	508.025	508.2593	2269762.0
2024-02-23 12:30:00	SPY	ETF	508.26	508.68	507.79	508.64	1912998.0
2024-02-23 13:00:00	SPY	ETF	508.62	508.99	508.33	508.92	1380973.0
2024-02-23 13:30:00	SPY	ETF	508.93	509.06	508.3501	508.53	1635803.0
2024-02-23 14:00:00	SPY	ETF	508.54	508.6	507.63	507.7787	2166106.0
2024-02-23 14:30:00	SPY	ETF	507.81	508.365	507.71	508.335	2055791.0
2024-02-23 15:00:00	SPY	ETF	508.335	508.56	507.8	507.92	2561668.0
2024-02-23 15:30:00	SPY	ETF	507.92	508.76	507.71	507.82	10524783.0
2024-02-23 16:00:00	SPY	ETF	507.82	507.8802	507.38	507.64	4022411.0
2024-02-23 16:30:00	SPY	ETF	507.65	507.71	507.3502	507.37	135630.0
2024-02-23 17:00:00	SPY	ETF	507.41	507.41	507.25	507.34	39824.0
2024-02-23 17:30:00	SPY	ETF	507.25	507.4	507.16	507.4	5767.0
2024-02-23 18:00:00	SPY	ETF	507.41	507.41	507.22	507.22	17661.0
2024-02-23 18:30:00	SPY	ETF	507.22	507.38	507.16	507.25	8363.0
2024-02-23 19:00:00	SPY	ETF	507.25	507.25	507.11	507.11	1474.0
2024-02-23 19:30:00	SPY	ETF	507.19	507.2	507.01	507.05	5650.0
2024-02-23 04:00:00	QQQ	ETF	437.65	437.79	437.13	437.17	20111.0
2024-02-23 04:30:00	QQQ	ETF	437.24	437.53	437.14	437.52	15720.0
2024-02-23 05:00:00	QQQ	ETF	437.44	437.56	437.28	437.45	8733.0
2024-02-23 05:30:00	QQQ	ETF	437.52	437.76	437.5	437.57	13372.0
2024-02-23 06:00:00	QQQ	ETF	437.5	437.85	437.5	437.73	18256.0
2024-02-23 06:30:00	QQQ	ETF	437.65	437.95	437.62	437.94	9377.0
2024-02-23 07:00:00	QQQ	ETF	438.0	438.06	437.65	437.94	35429.0
2024-02-23 07:30:00	QQQ	ETF	437.98	438.19	437.91	438.15	52820.0
2024-02-23 08:00:00	QQQ	ETF	437.78	438.66	437.1604	438.62	82420.0
2024-02-23 08:30:00	QQQ	ETF	438.579	439.09	438.43	438.9	108452.0
2024-02-23 09:00:00	QQQ	ETF	438.95	439.82	438.91	439.66	291278.0
2024-02-23 09:30:00	QQQ	ETF	439.65	440.59	438.57	439.03	4199422.0
2024-02-23 10:00:00	QQQ	ETF	439.04	439.3301	438.17	438.27	2819890.0
2024-02-23 10:30:00	QQQ	ETF	438.27	438.86	437.425	437.515	2580819.0
2024-02-23 11:00:00	QQQ	ETF	437.52	437.7099	435.79	437.27	3490288.0
2024-02-23 11:30:00	QQQ	ETF	437.27	438.02	436.78	437.99	1791718.0
2024-02-23 12:00:00	QQQ	ETF	437.99	438.62	437.285	437.58	1667291.0
2024-02-23 12:30:00	QQQ	ETF	437.575	438.16	436.96	438.14	1010777.0

> showing 50 of 31,503 rows — these rows as CSV

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