PREVIEW / etf_30min / 2024-09-05

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-09-05.parquet
  size:    798 KB
  rows:    32,991

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-05 04:00:00	SPY	ETF	551.94	552.04	551.52	551.9	89579.0
2024-09-05 04:30:00	SPY	ETF	551.77	551.85	551.55	551.85	4881.0
2024-09-05 05:00:00	SPY	ETF	551.57	551.57	550.42	550.47	15349.0
2024-09-05 05:30:00	SPY	ETF	550.7	551.35	550.51	551.09	10462.0
2024-09-05 06:00:00	SPY	ETF	551.09	551.25	550.75	551.07	8173.0
2024-09-05 06:30:00	SPY	ETF	551.09	551.43	550.95	551.33	7483.0
2024-09-05 07:00:00	SPY	ETF	551.37	551.62	551.0	551.6	155592.0
2024-09-05 07:30:00	SPY	ETF	551.56	551.72	550.6	550.74	70995.0
2024-09-05 08:00:00	SPY	ETF	551.3901	551.95	549.29	549.87	183196.0
2024-09-05 08:30:00	SPY	ETF	549.95	551.4	549.7	550.42	295562.0
2024-09-05 09:00:00	SPY	ETF	550.45	551.09	550.25	550.89	124906.0
2024-09-05 09:30:00	SPY	ETF	550.89	552.27	550.65	551.96	3681546.0
2024-09-05 10:00:00	SPY	ETF	551.97	553.7995	551.56	552.97	2553464.0
2024-09-05 10:30:00	SPY	ETF	552.97	553.55	550.33	550.3899	2143866.0
2024-09-05 11:00:00	SPY	ETF	550.38	550.54	547.82	547.9186	2553271.0
2024-09-05 11:30:00	SPY	ETF	547.92	548.54	547.36	547.49	2016103.0
2024-09-05 12:00:00	SPY	ETF	547.48	548.62	547.1	548.5595	2037858.0
2024-09-05 12:30:00	SPY	ETF	548.55	549.3	548.23	548.71	1190819.0
2024-09-05 13:00:00	SPY	ETF	548.72	548.96	547.75	547.8199	876517.0
2024-09-05 13:30:00	SPY	ETF	547.73	550.7	547.73	550.68	1485793.0
2024-09-05 14:00:00	SPY	ETF	550.69	550.93	549.85	550.0	1701975.0
2024-09-05 14:30:00	SPY	ETF	549.99	551.18	549.9699	550.17	1120606.0
2024-09-05 15:00:00	SPY	ETF	550.15	550.17	548.14	549.2801	1967226.0
2024-09-05 15:30:00	SPY	ETF	549.31	550.26	548.04	549.57	6252378.0
2024-09-05 16:00:00	SPY	ETF	549.56	550.32	549.04	549.22	3244076.0
2024-09-05 16:30:00	SPY	ETF	549.25	549.37	549.02	549.19	103564.0
2024-09-05 17:00:00	SPY	ETF	549.14	549.29	549.0	549.07	27222.0
2024-09-05 17:30:00	SPY	ETF	549.15	549.33	549.04	549.33	12446.0
2024-09-05 18:00:00	SPY	ETF	549.33	549.4	548.73	548.801	36587.0
2024-09-05 18:30:00	SPY	ETF	548.93	549.11	548.81	549.11	20265.0
2024-09-05 19:00:00	SPY	ETF	549.0	549.01	548.65	548.77	11912.0
2024-09-05 19:30:00	SPY	ETF	548.8604	549.1024	548.8604	549.05	10467.0
2024-09-05 04:00:00	QQQ	ETF	460.67	461.67	460.67	461.3	32902.0
2024-09-05 04:30:00	QQQ	ETF	461.37	461.46	460.89	461.1	11979.0
2024-09-05 05:00:00	QQQ	ETF	460.94	460.94	459.31	459.45	33935.0
2024-09-05 05:30:00	QQQ	ETF	459.65	460.24	459.36	460.23	10062.0
2024-09-05 06:00:00	QQQ	ETF	460.0	460.53	459.86	460.22	24572.0
2024-09-05 06:30:00	QQQ	ETF	460.15	460.64	460.1	460.45	21073.0
2024-09-05 07:00:00	QQQ	ETF	460.44	460.85	459.95	460.72	69198.0
2024-09-05 07:30:00	QQQ	ETF	460.7	460.88	459.55	459.719	45312.0
2024-09-05 08:00:00	QQQ	ETF	459.96	461.6	457.56	458.1	409151.0
2024-09-05 08:30:00	QQQ	ETF	458.1	460.16	458.1	459.01	425325.0
2024-09-05 09:00:00	QQQ	ETF	459.02	459.7	458.87	458.97	178365.0
2024-09-05 09:30:00	QQQ	ETF	458.97	463.2	458.97	463.05	3385024.0
2024-09-05 10:00:00	QQQ	ETF	463.04	465.36	462.365	464.2894	2980959.0
2024-09-05 10:30:00	QQQ	ETF	464.33	465.0	461.3	461.33	2044941.0
2024-09-05 11:00:00	QQQ	ETF	461.362	461.54	458.48	458.59	2627260.0
2024-09-05 11:30:00	QQQ	ETF	458.59	459.449	457.939	458.41	1627839.0
2024-09-05 12:00:00	QQQ	ETF	458.37	460.52	458.32	460.41	1589132.0
2024-09-05 12:30:00	QQQ	ETF	460.41	460.88	459.79	460.12	1019340.0

> showing 50 of 32,991 rows — these rows as CSV

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