PREVIEW / etf_30min / 2024-05-31

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-31.parquet
  size:    803 KB
  rows:    32,062

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-31 04:00:00	SPY	ETF	521.98	522.72	521.92	522.7	8024.0
2024-05-31 04:30:00	SPY	ETF	522.7	522.7	522.19	522.2	5866.0
2024-05-31 05:00:00	SPY	ETF	522.17	522.18	521.89	522.03	10878.0
2024-05-31 05:30:00	SPY	ETF	522.18	522.18	521.85	522.01	2900.0
2024-05-31 06:00:00	SPY	ETF	522.05	522.05	521.33	521.51	6934.0
2024-05-31 06:30:00	SPY	ETF	521.53	521.8	521.0	521.61	29753.0
2024-05-31 07:00:00	SPY	ETF	521.71	522.08	521.57	521.99	56627.0
2024-05-31 07:30:00	SPY	ETF	521.99	522.61	521.98	522.56	43909.0
2024-05-31 08:00:00	SPY	ETF	521.78	523.0	521.0696	522.88	202609.0
2024-05-31 08:30:00	SPY	ETF	523.03	525.0	522.514	524.61	579922.0
2024-05-31 09:00:00	SPY	ETF	524.61	524.79	523.58	523.6	355170.0
2024-05-31 09:30:00	SPY	ETF	523.58	524.81	522.94	523.15	3478274.0
2024-05-31 10:00:00	SPY	ETF	523.14	523.21	520.86	521.105	3198183.0
2024-05-31 10:30:00	SPY	ETF	521.09	521.15	520.23	520.87	3343982.0
2024-05-31 11:00:00	SPY	ETF	520.88	520.94	520.03	520.15	2104541.0
2024-05-31 11:30:00	SPY	ETF	520.12	520.24	519.58	519.69	2110849.0
2024-05-31 12:00:00	SPY	ETF	519.69	519.79	518.36	518.81	2598724.0
2024-05-31 12:30:00	SPY	ETF	518.8	519.56	518.72	519.53	2105216.0
2024-05-31 13:00:00	SPY	ETF	519.53	520.935	519.52	520.815	1908963.0
2024-05-31 13:30:00	SPY	ETF	520.82	521.04	520.45	520.85	2110921.0
2024-05-31 14:00:00	SPY	ETF	520.86	521.295	520.58	520.7799	1864419.0
2024-05-31 14:30:00	SPY	ETF	520.78	521.8	520.59	521.47	2046756.0
2024-05-31 15:00:00	SPY	ETF	521.465	522.75	521.035	522.25	3330234.0
2024-05-31 15:30:00	SPY	ETF	522.24	527.5	522.0	527.35	21130860.0
2024-05-31 16:00:00	SPY	ETF	527.35	528.36	526.6	527.65	7725298.0
2024-05-31 16:30:00	SPY	ETF	527.64	528.0399	526.9109	527.62	596045.0
2024-05-31 17:00:00	SPY	ETF	527.5299	527.78	527.37	527.61	136294.0
2024-05-31 17:30:00	SPY	ETF	527.6	528.02	527.6	528.02	82874.0
2024-05-31 18:00:00	SPY	ETF	528.05	528.13	526.9052	527.98	642574.0
2024-05-31 18:30:00	SPY	ETF	528.07	528.07	527.9	528.0	18779.0
2024-05-31 19:00:00	SPY	ETF	528.04	528.05	528.0	528.04	8193.0
2024-05-31 19:30:00	SPY	ETF	528.07	528.2603	528.0	528.22	33828.0
2024-05-31 04:00:00	QQQ	ETF	450.24	450.99	449.8	450.95	47272.0
2024-05-31 04:30:00	QQQ	ETF	450.95	451.0	450.36	450.36	21413.0
2024-05-31 05:00:00	QQQ	ETF	450.19	450.25	449.9	450.16	10056.0
2024-05-31 05:30:00	QQQ	ETF	450.41	450.41	450.1	450.35	8225.0
2024-05-31 06:00:00	QQQ	ETF	450.4	450.42	449.57	449.73	13867.0
2024-05-31 06:30:00	QQQ	ETF	449.71	450.0	448.99	449.81	73809.0
2024-05-31 07:00:00	QQQ	ETF	449.85	450.25	449.68	450.19	64848.0
2024-05-31 07:30:00	QQQ	ETF	450.239	450.88	450.19	450.85	53041.0
2024-05-31 08:00:00	QQQ	ETF	450.18	451.888	449.0896	451.1	181623.0
2024-05-31 08:30:00	QQQ	ETF	451.23	453.38	451.0	452.88	826390.0
2024-05-31 09:00:00	QQQ	ETF	452.86	453.09	451.7	451.82	339469.0
2024-05-31 09:30:00	QQQ	ETF	451.79	452.48	450.01	450.36	2664849.0
2024-05-31 10:00:00	QQQ	ETF	450.35	450.45	447.28	447.395	3361692.0
2024-05-31 10:30:00	QQQ	ETF	447.35	447.35	445.821	446.55	3472895.0
2024-05-31 11:00:00	QQQ	ETF	446.57	446.61	445.19	445.37	2074463.0
2024-05-31 11:30:00	QQQ	ETF	445.37	445.52	444.35	444.5	1533361.0
2024-05-31 12:00:00	QQQ	ETF	444.49	444.8	443.055	443.52	2060779.0
2024-05-31 12:30:00	QQQ	ETF	443.51	444.41	443.36	444.31	1658539.0

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

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