PREVIEW / etf_30min / 2024-05-02

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-02.parquet
  size:    794 KB
  rows:    31,572

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-05-02 04:00:00	SPY	ETF	503.42	504.01	503.42	503.66	17069.0
2024-05-02 04:30:00	SPY	ETF	503.76	503.79	503.2	503.2	9554.0
2024-05-02 05:00:00	SPY	ETF	503.15	503.43	503.15	503.34	600.0
2024-05-02 05:30:00	SPY	ETF	503.58	503.65	503.29	503.58	9224.0
2024-05-02 06:00:00	SPY	ETF	503.75	503.89	503.44	503.57	41950.0
2024-05-02 06:30:00	SPY	ETF	503.58	504.09	503.5	503.92	41114.0
2024-05-02 07:00:00	SPY	ETF	503.92	504.32	503.33	504.06	140455.0
2024-05-02 07:30:00	SPY	ETF	503.9	503.9	503.44	503.59	66843.0
2024-05-02 08:00:00	SPY	ETF	503.58	504.32	502.84	503.74	154375.0
2024-05-02 08:30:00	SPY	ETF	503.73	504.8	503.23	503.78	268492.0
2024-05-02 09:00:00	SPY	ETF	503.85	504.2	503.47	504.11	310311.0
2024-05-02 09:30:00	SPY	ETF	504.15	504.68	501.6604	501.99	6064899.0
2024-05-02 10:00:00	SPY	ETF	501.98	502.2099	499.55	502.02	5224133.0
2024-05-02 10:30:00	SPY	ETF	502.02	502.64	500.6	502.44	3493738.0
2024-05-02 11:00:00	SPY	ETF	502.45	503.12	501.99	502.13	2670278.0
2024-05-02 11:30:00	SPY	ETF	502.13	502.98	501.38	502.765	2203463.0
2024-05-02 12:00:00	SPY	ETF	502.77	502.86	501.69	502.29	2268254.0
2024-05-02 12:30:00	SPY	ETF	502.29	502.475	501.32	502.295	2059136.0
2024-05-02 13:00:00	SPY	ETF	502.33	504.14	502.3	504.1199	2222384.0
2024-05-02 13:30:00	SPY	ETF	504.12	504.38	503.3887	503.85	2369729.0
2024-05-02 14:00:00	SPY	ETF	503.86	504.7	503.68	504.5	2347817.0
2024-05-02 14:30:00	SPY	ETF	504.5	505.63	504.395	505.45	3400929.0
2024-05-02 15:00:00	SPY	ETF	505.46	505.89	504.81	505.3199	3949571.0
2024-05-02 15:30:00	SPY	ETF	505.31	505.3999	503.86	505.02	8543617.0
2024-05-02 16:00:00	SPY	ETF	505.01	505.67	504.76	504.99	3380401.0
2024-05-02 16:30:00	SPY	ETF	504.93	507.08	504.7	506.89	586790.0
2024-05-02 17:00:00	SPY	ETF	506.9	506.9	506.4	506.65	89745.0
2024-05-02 17:30:00	SPY	ETF	506.68	506.74	505.75	506.74	70955.0
2024-05-02 18:00:00	SPY	ETF	506.67	507.53	506.3	506.65	127926.0
2024-05-02 18:30:00	SPY	ETF	506.6	506.61	506.26	506.41	14746.0
2024-05-02 19:00:00	SPY	ETF	506.27	506.59	506.27	506.36	20264.0
2024-05-02 19:30:00	SPY	ETF	506.35	506.54	506.34	506.49	16008.0
2024-05-02 04:00:00	QQQ	ETF	425.05	425.68	424.6	425.41	35617.0
2024-05-02 04:30:00	QQQ	ETF	425.33	425.46	424.76	424.79	24652.0
2024-05-02 05:00:00	QQQ	ETF	424.85	425.17	424.84	425.16	12252.0
2024-05-02 05:30:00	QQQ	ETF	425.24	425.43	425.03	425.43	7588.0
2024-05-02 06:00:00	QQQ	ETF	425.5	425.82	425.16	425.16	18008.0
2024-05-02 06:30:00	QQQ	ETF	425.37	425.81	425.32	425.67	42464.0
2024-05-02 07:00:00	QQQ	ETF	425.6	426.04	425.54	425.781	93726.0
2024-05-02 07:30:00	QQQ	ETF	425.65	425.66	424.96	425.07	63945.0
2024-05-02 08:00:00	QQQ	ETF	425.62	426.0	424.0	425.16	144242.0
2024-05-02 08:30:00	QQQ	ETF	425.16	426.16	424.72	425.1	280376.0
2024-05-02 09:00:00	QQQ	ETF	425.15	425.38	424.75	425.28	177377.0
2024-05-02 09:30:00	QQQ	ETF	425.29	425.76	422.92	423.33	4586196.0
2024-05-02 10:00:00	QQQ	ETF	423.31	423.6	420.63	423.3	3126587.0
2024-05-02 10:30:00	QQQ	ETF	423.28	424.28	422.0	424.04	2011303.0
2024-05-02 11:00:00	QQQ	ETF	424.03	424.84	423.66	423.83	1442985.0
2024-05-02 11:30:00	QQQ	ETF	423.84	425.05	423.08	424.805	1198256.0
2024-05-02 12:00:00	QQQ	ETF	424.82	424.93	423.54	424.3	1000219.0
2024-05-02 12:30:00	QQQ	ETF	424.27	424.32	423.1816	424.09	902380.0

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

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