PREVIEW / etf_30min / 2024-05-01

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-01.parquet
  size:    800 KB
  rows:    32,201

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-01 04:00:00	SPY	ETF	500.76	501.09	500.65	500.86	15474.0
2024-05-01 04:30:00	SPY	ETF	500.85	500.9	500.64	500.64	5204.0
2024-05-01 05:00:00	SPY	ETF	500.75	500.75	500.0	500.0	7875.0
2024-05-01 05:30:00	SPY	ETF	499.97	500.26	499.64	500.12	12555.0
2024-05-01 06:00:00	SPY	ETF	499.95	500.04	499.66	499.66	26136.0
2024-05-01 06:30:00	SPY	ETF	499.61	500.34	499.5	500.34	67024.0
2024-05-01 07:00:00	SPY	ETF	500.28	500.65	500.14	500.39	106364.0
2024-05-01 07:30:00	SPY	ETF	500.37	500.509	499.91	500.08	61609.0
2024-05-01 08:00:00	SPY	ETF	500.27	502.1	499.4896	500.33	350924.0
2024-05-01 08:30:00	SPY	ETF	500.34	501.32	500.17	500.95	851948.0
2024-05-01 09:00:00	SPY	ETF	500.88	501.98	500.83	501.35	475251.0
2024-05-01 09:30:00	SPY	ETF	501.38	501.83	500.4187	500.81	3649933.0
2024-05-01 10:00:00	SPY	ETF	500.83	501.29	500.08	500.79	3688356.0
2024-05-01 10:30:00	SPY	ETF	500.82	501.61	500.58	501.345	1985432.0
2024-05-01 11:00:00	SPY	ETF	501.34	501.49	500.05	500.84	2663189.0
2024-05-01 11:30:00	SPY	ETF	500.84	501.4	500.22	500.24	1805184.0
2024-05-01 12:00:00	SPY	ETF	500.24	501.15	499.865	501.05	1600075.0
2024-05-01 12:30:00	SPY	ETF	501.05	501.075	500.29	500.425	1366172.0
2024-05-01 13:00:00	SPY	ETF	500.42	500.79	499.925	500.72	1453147.0
2024-05-01 13:30:00	SPY	ETF	500.73	501.3903	500.63	500.99	1647434.0
2024-05-01 14:00:00	SPY	ETF	501.03	503.169	500.75	503.06	5399040.0
2024-05-01 14:30:00	SPY	ETF	503.07	507.43	500.94	507.34	11136648.0
2024-05-01 15:00:00	SPY	ETF	507.35	508.19	505.48	506.465	7539630.0
2024-05-01 15:30:00	SPY	ETF	506.48	506.49	500.08	500.25	15701720.0
2024-05-01 16:00:00	SPY	ETF	500.25	501.08	500.1	500.69	2912822.0
2024-05-01 16:30:00	SPY	ETF	500.73	501.15	500.35	501.0	249486.0
2024-05-01 17:00:00	SPY	ETF	500.98	501.22	500.95	501.2	47487.0
2024-05-01 17:30:00	SPY	ETF	501.2	501.33	501.13	501.33	48307.0
2024-05-01 18:00:00	SPY	ETF	501.33	501.75	501.31	501.62	68970.0
2024-05-01 18:30:00	SPY	ETF	501.57	501.7	501.4	501.63	15649.0
2024-05-01 19:00:00	SPY	ETF	501.68	501.72	501.6	501.65	11791.0
2024-05-01 19:30:00	SPY	ETF	501.68	502.37	501.62	502.29	91215.0
2024-05-01 04:00:00	QQQ	ETF	422.33	422.78	422.26	422.49	14366.0
2024-05-01 04:30:00	QQQ	ETF	422.5	422.55	422.15	422.47	16366.0
2024-05-01 05:00:00	QQQ	ETF	422.46	422.47	421.38	421.5	16910.0
2024-05-01 05:30:00	QQQ	ETF	421.45	421.76	421.09	421.53	37640.0
2024-05-01 06:00:00	QQQ	ETF	421.54	421.54	421.02	421.02	25797.0
2024-05-01 06:30:00	QQQ	ETF	421.03	422.12	421.0	422.12	21586.0
2024-05-01 07:00:00	QQQ	ETF	422.13	422.44	421.87	421.93	88960.0
2024-05-01 07:30:00	QQQ	ETF	421.97	422.16	421.65	421.81	43896.0
2024-05-01 08:00:00	QQQ	ETF	422.14	424.908	421.15	422.3417	179746.0
2024-05-01 08:30:00	QQQ	ETF	422.34	424.59	422.24	423.04	176718.0
2024-05-01 09:00:00	QQQ	ETF	423.03	423.5398	422.93	423.1	155329.0
2024-05-01 09:30:00	QQQ	ETF	423.15	423.52	422.04	422.54	3951077.0
2024-05-01 10:00:00	QQQ	ETF	422.51	422.95	421.3	422.33	2378050.0
2024-05-01 10:30:00	QQQ	ETF	422.34	423.25	422.12	422.8	1315935.0
2024-05-01 11:00:00	QQQ	ETF	422.8	422.925	420.97	421.94	1802048.0
2024-05-01 11:30:00	QQQ	ETF	421.94	422.6696	421.165	421.2	1541349.0
2024-05-01 12:00:00	QQQ	ETF	421.19	422.31	420.66	422.19	1395600.0
2024-05-01 12:30:00	QQQ	ETF	422.2002	422.215	421.2	421.48	956702.0

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

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