PREVIEW / etf_30min / 2024-09-09

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-09-09.parquet
  size:    811 KB
  rows:    32,944

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-09 04:00:00	SPY	ETF	542.72	543.84	542.22	543.42	38748.0
2024-09-09 04:30:00	SPY	ETF	543.41	543.64	543.14	543.57	8811.0
2024-09-09 05:00:00	SPY	ETF	543.57	544.29	543.52	544.29	12119.0
2024-09-09 05:30:00	SPY	ETF	544.35	544.35	543.94	544.33	4589.0
2024-09-09 06:00:00	SPY	ETF	544.26	544.76	544.22	544.51	18125.0
2024-09-09 06:30:00	SPY	ETF	544.5	544.52	543.94	543.98	17817.0
2024-09-09 07:00:00	SPY	ETF	544.1	544.81	543.6	544.76	340342.0
2024-09-09 07:30:00	SPY	ETF	544.71	544.72	543.8	543.97	159732.0
2024-09-09 08:00:00	SPY	ETF	544.07	544.7	541.97	543.24	170408.0
2024-09-09 08:30:00	SPY	ETF	543.27	544.12	543.27	544.06	86704.0
2024-09-09 09:00:00	SPY	ETF	544.06	544.81	543.88	544.62	152640.0
2024-09-09 09:30:00	SPY	ETF	544.65	545.49	544.06	545.3	4031911.0
2024-09-09 10:00:00	SPY	ETF	545.3	546.39	544.69	544.73	2399973.0
2024-09-09 10:30:00	SPY	ETF	544.72	544.7701	543.31	543.31	1796368.0
2024-09-09 11:00:00	SPY	ETF	543.33	544.2699	542.68	544.2	1139975.0
2024-09-09 11:30:00	SPY	ETF	544.23	545.99	544.14	545.99	1260453.0
2024-09-09 12:00:00	SPY	ETF	545.98	547.0	545.76	546.89	1202365.0
2024-09-09 12:30:00	SPY	ETF	546.9001	547.68	546.77	547.49	1301007.0
2024-09-09 13:00:00	SPY	ETF	547.485	547.71	547.14	547.33	1044852.0
2024-09-09 13:30:00	SPY	ETF	547.32	547.33	545.575	545.7401	1382289.0
2024-09-09 14:00:00	SPY	ETF	545.74	545.85	544.9	544.9698	1577699.0
2024-09-09 14:30:00	SPY	ETF	544.96	545.51	544.18	545.11	1863582.0
2024-09-09 15:00:00	SPY	ETF	545.07	545.63	544.46	545.59	1925368.0
2024-09-09 15:30:00	SPY	ETF	545.58	546.51	544.98	546.42	4882194.0
2024-09-09 16:00:00	SPY	ETF	546.39	547.3998	546.21	547.38	3386924.0
2024-09-09 16:30:00	SPY	ETF	547.35	547.43	547.05	547.13	180002.0
2024-09-09 17:00:00	SPY	ETF	547.18	547.29	547.12	547.28	15217.0
2024-09-09 17:30:00	SPY	ETF	547.26	547.36	547.22	547.27	17782.0
2024-09-09 18:00:00	SPY	ETF	547.27	547.52	546.9	547.14	99337.0
2024-09-09 18:30:00	SPY	ETF	547.14	547.19	546.85	546.87	13297.0
2024-09-09 19:00:00	SPY	ETF	546.84	547.33	546.82	547.22	11116.0
2024-09-09 19:30:00	SPY	ETF	547.21	547.35	547.0	547.13	37211.0
2024-09-09 04:00:00	QQQ	ETF	451.12	452.87	451.12	452.15	86686.0
2024-09-09 04:30:00	QQQ	ETF	452.22	452.6	451.95	452.46	27854.0
2024-09-09 05:00:00	QQQ	ETF	452.53	453.16	452.4	453.1	20373.0
2024-09-09 05:30:00	QQQ	ETF	452.95	453.18	452.62	452.9	14461.0
2024-09-09 06:00:00	QQQ	ETF	453.1	453.38	452.93	453.14	41321.0
2024-09-09 06:30:00	QQQ	ETF	453.07	453.12	452.25	452.44	47393.0
2024-09-09 07:00:00	QQQ	ETF	452.53	453.18	452.35	453.18	157243.0
2024-09-09 07:30:00	QQQ	ETF	453.15	453.15	452.04	452.25	140416.0
2024-09-09 08:00:00	QQQ	ETF	452.485	453.097	450.83	451.5	228887.0
2024-09-09 08:30:00	QQQ	ETF	451.57	452.53	451.57	452.41	108427.0
2024-09-09 09:00:00	QQQ	ETF	452.41	453.09	452.17	453.0	155820.0
2024-09-09 09:30:00	QQQ	ETF	453.04	454.65	452.465	454.45	3734976.0
2024-09-09 10:00:00	QQQ	ETF	454.46	455.24	452.66	452.87	2181171.0
2024-09-09 10:30:00	QQQ	ETF	452.86	452.88	450.32	450.34	2547508.0
2024-09-09 11:00:00	QQQ	ETF	450.34	451.62	449.8234	451.57	1348785.0
2024-09-09 11:30:00	QQQ	ETF	451.6	453.41	451.38	453.39	1244841.0
2024-09-09 12:00:00	QQQ	ETF	453.39	454.28	453.12	454.182	1090268.0
2024-09-09 12:30:00	QQQ	ETF	454.2	455.19	453.94	455.0205	1338584.0

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

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