PREVIEW / etf_30min / 2024-04-25

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-25.parquet
  size:    795 KB
  rows:    31,581

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-04-25 04:00:00	SPY	ETF	502.45	503.2	502.38	502.92	41197.0
2024-04-25 04:30:00	SPY	ETF	502.95	503.34	502.92	503.03	10233.0
2024-04-25 05:00:00	SPY	ETF	503.05	503.2	502.99	503.15	9561.0
2024-04-25 05:30:00	SPY	ETF	503.15	503.39	503.05	503.2	9149.0
2024-04-25 06:00:00	SPY	ETF	503.1	503.32	502.83	502.95	17025.0
2024-04-25 06:30:00	SPY	ETF	502.88	503.08	502.41	502.49	49270.0
2024-04-25 07:00:00	SPY	ETF	502.44	502.81	502.1	502.44	72561.0
2024-04-25 07:30:00	SPY	ETF	502.4	502.89	502.08	502.84	103512.0
2024-04-25 08:00:00	SPY	ETF	502.3808	503.3196	501.98	502.35	99956.0
2024-04-25 08:30:00	SPY	ETF	502.55	503.16	499.46	499.69	1294177.0
2024-04-25 09:00:00	SPY	ETF	499.72	499.93	498.65	499.17	560072.0
2024-04-25 09:30:00	SPY	ETF	499.19	499.355	497.865	498.2	7603791.0
2024-04-25 10:00:00	SPY	ETF	498.2	499.76	497.49	499.6	5242602.0
2024-04-25 10:30:00	SPY	ETF	499.61	499.82	498.15	498.41	3257369.0
2024-04-25 11:00:00	SPY	ETF	498.4	499.78	498.36	499.71	2987240.0
2024-04-25 11:30:00	SPY	ETF	499.7	500.4	498.95	500.25	2654504.0
2024-04-25 12:00:00	SPY	ETF	500.25	501.49	499.91	501.36	2631284.0
2024-04-25 12:30:00	SPY	ETF	501.38	502.04	500.93	501.77	2393646.0
2024-04-25 13:00:00	SPY	ETF	501.77	502.37	500.97	501.68	2213400.0
2024-04-25 13:30:00	SPY	ETF	501.68	503.82	501.54	503.49	3222885.0
2024-04-25 14:00:00	SPY	ETF	503.5	503.715	501.97	501.97	3020784.0
2024-04-25 14:30:00	SPY	ETF	501.95	502.79	501.68	502.49	3143396.0
2024-04-25 15:00:00	SPY	ETF	502.5	504.27	502.44	504.15	3001722.0
2024-04-25 15:30:00	SPY	ETF	504.15	504.18	502.69	503.44	6000623.0
2024-04-25 16:00:00	SPY	ETF	503.45	508.3	503.12	507.5501	3545652.0
2024-04-25 16:30:00	SPY	ETF	507.5	508.39	507.41	508.26	442711.0
2024-04-25 17:00:00	SPY	ETF	508.3075	508.35	507.47	507.5	97083.0
2024-04-25 17:30:00	SPY	ETF	507.49	508.1	507.24	508.08	89783.0
2024-04-25 18:00:00	SPY	ETF	508.09	508.5	507.02	507.25	214757.0
2024-04-25 18:30:00	SPY	ETF	507.23	507.539	503.49	507.47	68144.0
2024-04-25 19:00:00	SPY	ETF	507.37	507.43	507.0	507.02	21063.0
2024-04-25 19:30:00	SPY	ETF	507.06	507.28	506.85	507.09	68123.0
2024-04-25 04:00:00	QQQ	ETF	421.63	422.59	421.63	422.21	95234.0
2024-04-25 04:30:00	QQQ	ETF	422.24	423.0	422.2	422.7	36316.0
2024-04-25 05:00:00	QQQ	ETF	422.71	423.19	422.71	423.06	30407.0
2024-04-25 05:30:00	QQQ	ETF	423.06	423.39	422.93	423.19	28888.0
2024-04-25 06:00:00	QQQ	ETF	423.16	423.24	422.68	423.05	23248.0
2024-04-25 06:30:00	QQQ	ETF	423.06	423.18	422.2	422.45	59091.0
2024-04-25 07:00:00	QQQ	ETF	422.43	422.72	421.9	422.34	126939.0
2024-04-25 07:30:00	QQQ	ETF	422.35	422.85	422.06	422.82	109950.0
2024-04-25 08:00:00	QQQ	ETF	422.24	423.4	420.6	422.2295	247814.0
2024-04-25 08:30:00	QQQ	ETF	422.27	426.829	419.62	419.9	838121.0
2024-04-25 09:00:00	QQQ	ETF	419.92	420.17	418.74	419.2291	695093.0
2024-04-25 09:30:00	QQQ	ETF	419.24	419.945	418.14	419.33	7221096.0
2024-04-25 10:00:00	QQQ	ETF	419.36	421.53	418.68	421.165	3779866.0
2024-04-25 10:30:00	QQQ	ETF	421.17	421.29	418.98	419.25	3357857.0
2024-04-25 11:00:00	QQQ	ETF	419.26	420.625	419.19	420.55	2279108.0
2024-04-25 11:30:00	QQQ	ETF	420.55	420.88	419.4	420.74	2128593.0
2024-04-25 12:00:00	QQQ	ETF	420.69	421.94	420.34	421.8206	2223263.0
2024-04-25 12:30:00	QQQ	ETF	421.85	423.01	421.46	422.7	2015500.0

> showing 50 of 31,581 rows — these rows as CSV

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