PREVIEW / etf_30min / 2024-06-03

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-03.parquet
  size:    705 KB
  rows:    29,361

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-06-03 04:00:00	SPY	ETF	527.42	528.64	527.0	528.25	29624.0
2024-06-03 04:30:00	SPY	ETF	528.26	528.62	528.08	528.44	109519.0
2024-06-03 05:00:00	SPY	ETF	528.4	528.4	528.1	528.16	47636.0
2024-06-03 05:30:00	SPY	ETF	528.21	528.29	527.78	528.08	14675.0
2024-06-03 06:00:00	SPY	ETF	528.13	528.14	528.05	528.14	4298.0
2024-06-03 06:30:00	SPY	ETF	528.17	528.25	527.89	527.97	64829.0
2024-06-03 07:00:00	SPY	ETF	528.02	528.5	527.89	527.99	177798.0
2024-06-03 07:30:00	SPY	ETF	528.09	528.66	528.09	528.6	134598.0
2024-06-03 08:00:00	SPY	ETF	527.98	528.96	527.73	528.69	198174.0
2024-06-03 08:30:00	SPY	ETF	528.67	528.76	528.33	528.4	92992.0
2024-06-03 09:00:00	SPY	ETF	528.46	529.1	527.37	529.02	350133.0
2024-06-03 09:30:00	SPY	ETF	529.02	529.16	527.345	527.92	5691369.0
2024-06-03 10:00:00	SPY	ETF	527.92	529.31	527.4305	528.17	2566852.0
2024-06-03 11:30:00	SPY	ETF	526.3072	526.415	525.72	526.09	783146.0
2024-06-03 12:00:00	SPY	ETF	526.09	526.4	523.65	523.95	2162779.0
2024-06-03 12:30:00	SPY	ETF	523.94	524.31	523.21	523.79	1630417.0
2024-06-03 13:00:00	SPY	ETF	523.77	524.69	522.6	524.65	1642422.0
2024-06-03 13:30:00	SPY	ETF	524.64	525.58	524.58	525.19	1576728.0
2024-06-03 14:00:00	SPY	ETF	525.22	525.78	524.67	525.11	1300296.0
2024-06-03 14:30:00	SPY	ETF	525.11	526.14	525.11	525.75	1092078.0
2024-06-03 15:00:00	SPY	ETF	525.75	526.5	525.56	526.25	1615340.0
2024-06-03 15:30:00	SPY	ETF	526.26	527.83	525.73	527.77	5476276.0
2024-06-03 16:00:00	SPY	ETF	527.76	528.24	527.5502	528.05	3302053.0
2024-06-03 16:30:00	SPY	ETF	528.04	528.12	527.8	527.89	181335.0
2024-06-03 17:00:00	SPY	ETF	527.85	527.8698	527.7	527.7	22814.0
2024-06-03 17:30:00	SPY	ETF	527.75	527.95	527.7	527.75	7254.0
2024-06-03 18:00:00	SPY	ETF	527.85	527.88	527.72	527.83	4740.0
2024-06-03 18:30:00	SPY	ETF	527.9	528.0	527.85	527.86	6982.0
2024-06-03 19:00:00	SPY	ETF	527.85	527.95	527.8	527.8	4421.0
2024-06-03 19:30:00	SPY	ETF	527.78	527.78	527.53	527.53	9627.0
2024-06-03 04:00:00	QQQ	ETF	452.88	453.43	452.46	453.36	54504.0
2024-06-03 04:30:00	QQQ	ETF	453.37	453.67	453.05	453.45	140285.0
2024-06-03 05:00:00	QQQ	ETF	453.43	453.59	453.16	453.35	32721.0
2024-06-03 05:30:00	QQQ	ETF	453.36	453.52	453.0	453.4	27095.0
2024-06-03 06:00:00	QQQ	ETF	453.48	453.62	453.4	453.6	12719.0
2024-06-03 06:30:00	QQQ	ETF	453.72	453.77	453.21	453.35	38207.0
2024-06-03 07:00:00	QQQ	ETF	453.25	453.77	453.25	453.45	59050.0
2024-06-03 07:30:00	QQQ	ETF	453.5	453.98	453.49	453.94	49729.0
2024-06-03 08:00:00	QQQ	ETF	453.25	454.25	452.38	454.17	148781.0
2024-06-03 08:30:00	QQQ	ETF	454.17	454.19	453.65	453.87	163054.0
2024-06-03 09:00:00	QQQ	ETF	453.86	454.61	453.86	454.58	417056.0
2024-06-03 09:30:00	QQQ	ETF	454.57	455.58	453.09	453.73	4213664.0
2024-06-03 10:00:00	QQQ	ETF	453.78	454.94	452.94	454.2	2195628.0
2024-06-03 10:30:00	QQQ	ETF	454.21	454.27	451.13	451.5999	1959952.0
2024-06-03 11:00:00	QQQ	ETF	451.6201	452.54	450.98	452.26	1551663.0
2024-06-03 11:30:00	QQQ	ETF	452.25	452.75	451.67	451.97	987234.0
2024-06-03 12:00:00	QQQ	ETF	451.97	452.295	449.17	449.52	2135145.0
2024-06-03 12:30:00	QQQ	ETF	449.52	449.8825	448.67	449.06	1546939.0
2024-06-03 13:00:00	QQQ	ETF	449.04	450.23	447.9	450.19	1645076.0
2024-06-03 13:30:00	QQQ	ETF	450.19	451.35	450.15	450.83	1443405.0

> showing 50 of 29,361 rows — these rows as CSV

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