PREVIEW / etf_30min / 2024-05-03

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-03.parquet
  size:    782 KB
  rows:    31,471

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-03 04:00:00	SPY	ETF	506.25	506.6	506.25	506.6	9217.0
2024-05-03 04:30:00	SPY	ETF	506.61	506.82	506.56	506.69	6621.0
2024-05-03 05:00:00	SPY	ETF	506.71	506.73	506.45	506.45	5886.0
2024-05-03 05:30:00	SPY	ETF	506.46	506.81	506.46	506.8	2023.0
2024-05-03 06:00:00	SPY	ETF	506.97	507.21	506.97	507.08	15575.0
2024-05-03 06:30:00	SPY	ETF	507.14	507.14	506.8	506.8	10576.0
2024-05-03 07:00:00	SPY	ETF	506.71	507.06	506.12	507.06	144167.0
2024-05-03 07:30:00	SPY	ETF	507.05	507.08	506.45	506.64	36761.0
2024-05-03 08:00:00	SPY	ETF	506.75	507.3	505.86	506.67	242845.0
2024-05-03 08:30:00	SPY	ETF	507.24	511.51	506.91	510.55	1452122.0
2024-05-03 09:00:00	SPY	ETF	510.63	511.15	510.06	511.13	674703.0
2024-05-03 09:30:00	SPY	ETF	511.16	511.98	509.61	511.57	7341462.0
2024-05-03 10:00:00	SPY	ETF	511.59	512.55	508.64	509.67	7758404.0
2024-05-03 10:30:00	SPY	ETF	509.67	510.41	508.675	509.17	4239477.0
2024-05-03 11:00:00	SPY	ETF	509.17	509.86	508.56	509.735	3017040.0
2024-05-03 11:30:00	SPY	ETF	509.75	510.92	509.7401	510.485	3403946.0
2024-05-03 12:00:00	SPY	ETF	510.48	511.1099	510.42	510.89	2368643.0
2024-05-03 12:30:00	SPY	ETF	510.92	511.3986	510.4271	510.7	2332281.0
2024-05-03 13:00:00	SPY	ETF	510.71	511.4885	510.6	511.1101	1923787.0
2024-05-03 13:30:00	SPY	ETF	511.11	511.62	510.68	511.3	1906740.0
2024-05-03 14:00:00	SPY	ETF	511.29	511.99	511.29	511.75	1709927.0
2024-05-03 14:30:00	SPY	ETF	511.74	511.99	511.24	511.54	2301953.0
2024-05-03 15:00:00	SPY	ETF	511.54	511.8499	511.25	511.64	2967883.0
2024-05-03 15:30:00	SPY	ETF	511.64	511.755	511.14	511.29	8571368.0
2024-05-03 16:00:00	SPY	ETF	511.28	512.07	511.25	511.83	4257829.0
2024-05-03 16:30:00	SPY	ETF	511.85	511.99	511.713	511.9	224975.0
2024-05-03 17:00:00	SPY	ETF	511.9	511.99	511.6	511.83	76263.0
2024-05-03 17:30:00	SPY	ETF	511.82	512.17	511.7	512.17	18882.0
2024-05-03 18:00:00	SPY	ETF	512.13	512.56	512.09	512.44	42083.0
2024-05-03 18:30:00	SPY	ETF	512.38	512.38	512.2	512.29	18424.0
2024-05-03 19:00:00	SPY	ETF	512.33	512.55	512.33	512.45	23946.0
2024-05-03 19:30:00	SPY	ETF	512.39	512.46	512.2	512.32	22496.0
2024-05-03 04:00:00	QQQ	ETF	429.32	429.62	429.24	429.6	25361.0
2024-05-03 04:30:00	QQQ	ETF	429.5	429.89	429.49	429.71	14428.0
2024-05-03 05:00:00	QQQ	ETF	429.71	429.71	429.31	429.39	6780.0
2024-05-03 05:30:00	QQQ	ETF	429.37	429.64	429.37	429.58	5599.0
2024-05-03 06:00:00	QQQ	ETF	429.73	430.12	429.73	429.93	46386.0
2024-05-03 06:30:00	QQQ	ETF	429.98	429.98	429.52	429.52	9679.0
2024-05-03 07:00:00	QQQ	ETF	429.5	429.91	429.5	429.9	32457.0
2024-05-03 07:30:00	QQQ	ETF	429.93	429.98	429.25	429.37	34380.0
2024-05-03 08:00:00	QQQ	ETF	429.5617	430.3	428.78	429.5	148019.0
2024-05-03 08:30:00	QQQ	ETF	430.49	434.54	430.48	433.6	667781.0
2024-05-03 09:00:00	QQQ	ETF	433.62	434.63	433.43	434.43	280809.0
2024-05-03 09:30:00	QQQ	ETF	434.44	435.88	433.49	435.4207	5454673.0
2024-05-03 10:00:00	QQQ	ETF	435.44	436.48	432.62	434.04	5445989.0
2024-05-03 10:30:00	QQQ	ETF	434.07	435.16	433.27	433.62	2583598.0
2024-05-03 11:00:00	QQQ	ETF	433.64	434.25	432.89	434.12	2198260.0
2024-05-03 11:30:00	QQQ	ETF	434.125	435.54	434.125	435.0985	1990917.0
2024-05-03 12:00:00	QQQ	ETF	435.09	435.42	434.8195	435.0929	1542180.0
2024-05-03 12:30:00	QQQ	ETF	435.11	435.59	434.51	434.74	1136835.0

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

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