PREVIEW / etf_30min / 2024-02-12

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-12.parquet
  size:    815 KB
  rows:    32,102

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-12 04:00:00	SPY	ETF	500.98	501.22	500.94	501.22	9036.0
2024-02-12 04:30:00	SPY	ETF	501.28	501.34	501.17	501.23	2823.0
2024-02-12 05:00:00	SPY	ETF	501.14	501.32	501.14	501.24	2675.0
2024-02-12 05:30:00	SPY	ETF	501.31	501.32	501.25	501.29	1529.0
2024-02-12 06:00:00	SPY	ETF	501.29	501.49	501.2	501.43	14798.0
2024-02-12 06:30:00	SPY	ETF	501.34	501.38	501.26	501.33	5520.0
2024-02-12 07:00:00	SPY	ETF	501.37	501.44	501.25	501.29	5788.0
2024-02-12 07:30:00	SPY	ETF	501.23	501.3	501.2	501.28	8900.0
2024-02-12 08:00:00	SPY	ETF	501.27	501.43	501.16	501.18	55908.0
2024-02-12 08:30:00	SPY	ETF	501.2	501.2	501.0	501.03	59085.0
2024-02-12 09:00:00	SPY	ETF	501.04	501.18	500.83	501.17	144834.0
2024-02-12 09:30:00	SPY	ETF	501.17	501.47	501.14	501.43	3198508.0
2024-02-12 10:00:00	SPY	ETF	501.42	501.46	501.02	501.325	1812135.0
2024-02-12 10:30:00	SPY	ETF	501.335	502.13	501.31	502.07	2316865.0
2024-02-12 11:00:00	SPY	ETF	502.08	502.95	501.86	502.8903	2184994.0
2024-02-12 11:30:00	SPY	ETF	502.89	503.5	502.86	503.295	2426968.0
2024-02-12 12:00:00	SPY	ETF	503.29	503.445	502.69	502.92	2244884.0
2024-02-12 12:30:00	SPY	ETF	502.92	503.22	502.65	503.195	1720860.0
2024-02-12 13:00:00	SPY	ETF	503.2	503.44	502.51	502.56	1790522.0
2024-02-12 13:30:00	SPY	ETF	502.57	502.61	501.68	502.08	3453297.0
2024-02-12 14:00:00	SPY	ETF	502.08	502.1696	500.24	501.07	4111357.0
2024-02-12 14:30:00	SPY	ETF	501.08	501.3	500.42	500.59	2689395.0
2024-02-12 15:00:00	SPY	ETF	500.58	501.12	500.52	500.91	1977541.0
2024-02-12 15:30:00	SPY	ETF	500.915	501.24	500.55	500.94	7314467.0
2024-02-12 16:00:00	SPY	ETF	500.94	501.05	500.02	500.22	3167971.0
2024-02-12 16:30:00	SPY	ETF	500.24	500.98	500.15	500.44	220841.0
2024-02-12 17:00:00	SPY	ETF	500.43	500.48	500.33	500.35	39024.0
2024-02-12 17:30:00	SPY	ETF	500.34	500.36	500.28	500.28	8421.0
2024-02-12 18:00:00	SPY	ETF	500.27	500.4	500.03	500.35	70425.0
2024-02-12 18:30:00	SPY	ETF	500.331	500.57	500.32	500.42	39764.0
2024-02-12 19:00:00	SPY	ETF	500.42	500.42	500.06	500.17	22970.0
2024-02-12 19:30:00	SPY	ETF	500.22	500.23	500.0704	500.2	18836.0
2024-02-12 04:00:00	QQQ	ETF	437.27	437.66	437.27	437.5	35982.0
2024-02-12 04:30:00	QQQ	ETF	437.55	437.63	437.42	437.45	24498.0
2024-02-12 05:00:00	QQQ	ETF	437.52	437.65	437.3	437.49	19928.0
2024-02-12 05:30:00	QQQ	ETF	437.51	437.51	437.36	437.48	9017.0
2024-02-12 06:00:00	QQQ	ETF	437.44	437.6	437.28	437.47	7946.0
2024-02-12 06:30:00	QQQ	ETF	437.45	437.52	437.27	437.29	6352.0
2024-02-12 07:00:00	QQQ	ETF	437.33	437.44	437.11	437.15	44576.0
2024-02-12 07:30:00	QQQ	ETF	437.09	437.21	437.01	437.17	16501.0
2024-02-12 08:00:00	QQQ	ETF	437.2917	437.5696	436.7	437.23	42051.0
2024-02-12 08:30:00	QQQ	ETF	437.24	437.25	436.87	436.95	76337.0
2024-02-12 09:00:00	QQQ	ETF	436.94	437.07	436.75	436.94	94796.0
2024-02-12 09:30:00	QQQ	ETF	436.94	437.45	436.3806	437.175	2852985.0
2024-02-12 10:00:00	QQQ	ETF	437.2	437.233	436.57	437.0	1732570.0
2024-02-12 10:30:00	QQQ	ETF	437.0	438.235	436.89	438.13	1655333.0
2024-02-12 11:00:00	QQQ	ETF	438.135	438.56	437.76	438.475	1214535.0
2024-02-12 11:30:00	QQQ	ETF	438.49	439.14	438.25	438.64	1593413.0
2024-02-12 12:00:00	QQQ	ETF	438.67	438.84	437.85	438.07	1504903.0
2024-02-12 12:30:00	QQQ	ETF	438.09	438.76	438.05	438.73	984827.0

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

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