PREVIEW / etf_30min / 2024-01-04

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-04.parquet
  size:    788 KB
  rows:    31,264

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-01-04 04:00:00	SPY	ETF	469.4	469.74	469.26	469.64	6888.0
2024-01-04 04:30:00	SPY	ETF	469.74	469.81	469.5	469.71	3379.0
2024-01-04 05:00:00	SPY	ETF	469.72	469.78	469.4	469.78	30493.0
2024-01-04 05:30:00	SPY	ETF	469.54	469.62	469.24	469.52	3138.0
2024-01-04 06:00:00	SPY	ETF	469.46	469.74	469.46	469.71	10337.0
2024-01-04 06:30:00	SPY	ETF	469.67	469.67	468.95	469.1	31769.0
2024-01-04 07:00:00	SPY	ETF	469.07	469.4	468.68	469.39	67204.0
2024-01-04 07:30:00	SPY	ETF	469.4	469.74	469.32	469.35	58520.0
2024-01-04 08:00:00	SPY	ETF	469.08	469.89	468.74	469.32	148469.0
2024-01-04 08:30:00	SPY	ETF	469.2	469.25	468.5	468.66	198438.0
2024-01-04 09:00:00	SPY	ETF	468.66	468.98	468.1	468.32	279175.0
2024-01-04 09:30:00	SPY	ETF	468.3	469.26	468.11	468.92	5704367.0
2024-01-04 10:00:00	SPY	ETF	468.9	470.15	468.685	469.765	4984839.0
2024-01-04 10:30:00	SPY	ETF	469.76	470.24	469.62	469.851	2357797.0
2024-01-04 11:00:00	SPY	ETF	469.87	470.96	469.87	470.65	2921265.0
2024-01-04 11:30:00	SPY	ETF	470.66	470.82	469.46	469.72	3121172.0
2024-01-04 12:00:00	SPY	ETF	469.72	469.8382	469.26	469.61	2309039.0
2024-01-04 12:30:00	SPY	ETF	469.6088	469.62	468.665	469.132	2536657.0
2024-01-04 13:00:00	SPY	ETF	469.13	469.4103	468.97	469.3201	1663192.0
2024-01-04 13:30:00	SPY	ETF	469.33	469.47	468.9701	469.07	1612660.0
2024-01-04 14:00:00	SPY	ETF	469.08	469.33	468.5096	468.5799	3859062.0
2024-01-04 14:30:00	SPY	ETF	468.57	468.985	468.17	468.68	3486925.0
2024-01-04 15:00:00	SPY	ETF	468.6832	469.04	468.07	468.269	4384743.0
2024-01-04 15:30:00	SPY	ETF	468.26	468.6795	467.05	467.27	14305053.0
2024-01-04 16:00:00	SPY	ETF	467.27	467.67	467.07	467.54	4650652.0
2024-01-04 16:30:00	SPY	ETF	467.55	467.8	467.5	467.57	211562.0
2024-01-04 17:00:00	SPY	ETF	467.57	467.7	467.55	467.69	19592.0
2024-01-04 17:30:00	SPY	ETF	467.68	467.73	467.28	467.73	44946.0
2024-01-04 18:00:00	SPY	ETF	467.67	467.96	467.6	467.87	31104.0
2024-01-04 18:30:00	SPY	ETF	467.8	467.95	467.75	467.75	17792.0
2024-01-04 19:00:00	SPY	ETF	467.74	467.89	467.71	467.79	19520.0
2024-01-04 19:30:00	SPY	ETF	467.92	467.96	467.78	467.8	26158.0
2024-01-04 04:00:00	QQQ	ETF	398.81	399.45	398.67	399.34	17042.0
2024-01-04 04:30:00	QQQ	ETF	399.47	399.47	399.28	399.41	3007.0
2024-01-04 05:00:00	QQQ	ETF	399.42	399.42	399.05	399.3	22110.0
2024-01-04 05:30:00	QQQ	ETF	399.2	399.21	398.9	399.02	5565.0
2024-01-04 06:00:00	QQQ	ETF	399.08	399.32	399.08	399.24	4368.0
2024-01-04 06:30:00	QQQ	ETF	399.2	399.2	398.25	398.25	42833.0
2024-01-04 07:00:00	QQQ	ETF	398.27	398.4	397.71	398.19	76414.0
2024-01-04 07:30:00	QQQ	ETF	398.2	398.35	397.95	398.0	63521.0
2024-01-04 08:00:00	QQQ	ETF	398.3205	399.66	397.21	397.57	206660.0
2024-01-04 08:30:00	QQQ	ETF	397.53	397.63	396.43	396.581	181780.0
2024-01-04 09:00:00	QQQ	ETF	396.58	396.86	396.12	396.42	175081.0
2024-01-04 09:30:00	QQQ	ETF	396.45	397.56	396.1928	396.61	4336924.0
2024-01-04 10:00:00	QQQ	ETF	396.6	398.3689	396.26	397.76	4242577.0
2024-01-04 10:30:00	QQQ	ETF	397.75	398.59	397.64	398.175	1756332.0
2024-01-04 11:00:00	QQQ	ETF	398.19	399.59	398.19	399.15	2277944.0
2024-01-04 11:30:00	QQQ	ETF	399.16	399.36	397.94	398.1501	2181280.0
2024-01-04 12:00:00	QQQ	ETF	398.16	398.28	397.64	398.17	1303280.0
2024-01-04 12:30:00	QQQ	ETF	398.19	398.21	397.17	397.76	1461966.0

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

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