PREVIEW / etf_30min / 2024-05-15

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-15.parquet
  size:    822 KB
  rows:    32,795

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-15 04:00:00	SPY	ETF	523.5	523.58	523.45	523.45	10357.0
2024-05-15 04:30:00	SPY	ETF	523.56	523.75	523.53	523.75	11447.0
2024-05-15 05:00:00	SPY	ETF	523.77	523.82	523.65	523.65	23658.0
2024-05-15 05:30:00	SPY	ETF	523.7	523.78	523.7	523.78	2289.0
2024-05-15 06:00:00	SPY	ETF	523.71	523.71	523.6	523.6	5008.0
2024-05-15 06:30:00	SPY	ETF	523.59	523.61	523.57	523.57	1700.0
2024-05-15 07:00:00	SPY	ETF	523.6	523.78	523.57	523.62	74739.0
2024-05-15 07:30:00	SPY	ETF	523.62	523.71	523.46	523.61	43048.0
2024-05-15 08:00:00	SPY	ETF	523.6098	523.87	523.12	523.66	221492.0
2024-05-15 08:30:00	SPY	ETF	523.79	527.0	523.79	526.08	1698720.0
2024-05-15 09:00:00	SPY	ETF	526.08	526.2	525.7	525.84	460300.0
2024-05-15 09:30:00	SPY	ETF	525.83	526.8	525.18	525.67	5852979.0
2024-05-15 10:00:00	SPY	ETF	525.67	526.64	525.635	526.39	3259854.0
2024-05-15 10:30:00	SPY	ETF	526.41	527.25	526.32	527.15	2572056.0
2024-05-15 11:00:00	SPY	ETF	527.16	528.11	527.142	528.08	2607880.0
2024-05-15 11:30:00	SPY	ETF	528.075	528.17	527.73	527.8812	1741971.0
2024-05-15 12:00:00	SPY	ETF	527.89	528.06	527.415	528.05	1678788.0
2024-05-15 12:30:00	SPY	ETF	528.04	528.59	527.945	528.5353	1599657.0
2024-05-15 13:00:00	SPY	ETF	528.56	528.845	528.415	528.79	1799681.0
2024-05-15 13:30:00	SPY	ETF	528.7915	528.99	528.34	528.96	1560222.0
2024-05-15 14:00:00	SPY	ETF	528.96	529.43	528.8	528.97	2405030.0
2024-05-15 14:30:00	SPY	ETF	528.99	529.0199	528.6	528.995	1825985.0
2024-05-15 15:00:00	SPY	ETF	528.995	529.3	528.7	529.06	2430464.0
2024-05-15 15:30:00	SPY	ETF	529.05	530.08	528.95	529.76	10922485.0
2024-05-15 16:00:00	SPY	ETF	529.76	529.84	528.93	529.18	3751485.0
2024-05-15 16:30:00	SPY	ETF	529.2	529.4	529.11	529.39	96060.0
2024-05-15 17:00:00	SPY	ETF	529.36	529.53	529.35	529.5	16487.0
2024-05-15 17:30:00	SPY	ETF	529.5	529.78	529.46	529.5	21702.0
2024-05-15 18:00:00	SPY	ETF	529.5	529.66	529.32	529.65	28858.0
2024-05-15 18:30:00	SPY	ETF	529.6501	529.83	529.6501	529.7	8896.0
2024-05-15 19:00:00	SPY	ETF	529.79	530.28	529.78	530.17	47366.0
2024-05-15 19:30:00	SPY	ETF	530.18	530.31	530.15	530.18	37947.0
2024-05-15 04:00:00	QQQ	ETF	445.85	445.92	445.76	445.87	7753.0
2024-05-15 04:30:00	QQQ	ETF	445.92	446.17	445.92	446.17	12065.0
2024-05-15 05:00:00	QQQ	ETF	446.18	446.21	446.0	446.0	4270.0
2024-05-15 05:30:00	QQQ	ETF	446.07	446.26	446.07	446.11	6574.0
2024-05-15 06:00:00	QQQ	ETF	446.1	446.12	445.94	446.03	9550.0
2024-05-15 06:30:00	QQQ	ETF	446.04	446.09	445.86	445.86	24067.0
2024-05-15 07:00:00	QQQ	ETF	445.92	446.18	445.9	446.08	18716.0
2024-05-15 07:30:00	QQQ	ETF	446.0	446.16	446.0	446.04	32227.0
2024-05-15 08:00:00	QQQ	ETF	445.94	446.37	445.59	445.99	67854.0
2024-05-15 08:30:00	QQQ	ETF	445.85	449.35	445.85	448.4	1182974.0
2024-05-15 09:00:00	QQQ	ETF	448.44	448.58	446.264	448.41	173606.0
2024-05-15 09:30:00	QQQ	ETF	448.43	449.0	446.9	447.78	4331032.0
2024-05-15 10:00:00	QQQ	ETF	447.78	449.21	447.76	448.915	2239889.0
2024-05-15 10:30:00	QQQ	ETF	448.95	449.93	448.84	449.91	2040473.0
2024-05-15 11:00:00	QQQ	ETF	449.91	450.79	449.87	450.48	1974614.0
2024-05-15 11:30:00	QQQ	ETF	450.49	450.75	450.28	450.45	1209055.0
2024-05-15 12:00:00	QQQ	ETF	450.47	450.89	450.055	450.87	1254430.0
2024-05-15 12:30:00	QQQ	ETF	450.88	451.34	450.79	451.2901	1197494.0

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

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