PREVIEW / etf_30min / 2023-06-26

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-26.parquet
  size:    691 KB
  rows:    27,513

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
2023-06-26 04:00:00	SPY	ETF	432.85	432.85	432.16	432.16	16142.0
2023-06-26 04:30:00	SPY	ETF	432.15	432.81	431.99	432.17	227026.0
2023-06-26 05:00:00	SPY	ETF	432.3	432.71	432.3	432.6	7454.0
2023-06-26 05:30:00	SPY	ETF	432.56	432.92	432.52	432.75	12332.0
2023-06-26 06:00:00	SPY	ETF	432.72	432.81	432.56	432.6	7432.0
2023-06-26 06:30:00	SPY	ETF	432.5	432.84	432.5	432.55	11267.0
2023-06-26 07:00:00	SPY	ETF	432.59	432.85	432.45	432.75	28801.0
2023-06-26 07:30:00	SPY	ETF	432.75	433.15	432.59	432.99	48079.0
2023-06-26 08:00:00	SPY	ETF	432.57	434.37	432.0	433.2	111654.0
2023-06-26 08:30:00	SPY	ETF	433.2	433.3	432.88	433.02	143249.0
2023-06-26 09:00:00	SPY	ETF	432.96	433.04	432.55	432.63	115076.0
2023-06-26 09:30:00	SPY	ETF	432.63	434.44	432.6	434.27	4628692.0
2023-06-26 10:00:00	SPY	ETF	434.27	434.61	433.73	433.98	3294239.0
2023-06-26 10:30:00	SPY	ETF	433.99	434.005	432.28	433.5	4688612.0
2023-06-26 11:00:00	SPY	ETF	433.49	433.52	432.275	432.4901	3551195.0
2023-06-26 11:30:00	SPY	ETF	432.48	433.22	432.36	433.15	2502896.0
2023-06-26 12:00:00	SPY	ETF	433.15	433.2796	431.84	432.35	3857278.0
2023-06-26 12:30:00	SPY	ETF	432.35	432.43	431.65	432.39	2827731.0
2023-06-26 13:00:00	SPY	ETF	432.395	432.68	431.965	432.5991	1892788.0
2023-06-26 13:30:00	SPY	ETF	432.6	432.715	432.1	432.1879	2042183.0
2023-06-26 14:00:00	SPY	ETF	432.18	432.32	431.75	432.115	2057010.0
2023-06-26 14:30:00	SPY	ETF	432.11	432.9	432.0401	432.665	2600119.0
2023-06-26 15:00:00	SPY	ETF	432.67	432.92	432.45	432.639	2398381.0
2023-06-26 15:30:00	SPY	ETF	432.64	432.85	431.19	431.43	13599885.0
2023-06-26 16:00:00	SPY	ETF	431.42	431.96	431.41	431.78	2918023.0
2023-06-26 16:30:00	SPY	ETF	431.72	431.86	431.65	431.8	224228.0
2023-06-26 17:00:00	SPY	ETF	431.85	431.85	431.44	431.73	14023.0
2023-06-26 17:30:00	SPY	ETF	431.73	431.8	431.73	431.77	20305.0
2023-06-26 18:00:00	SPY	ETF	431.79	432.0	431.7	431.72	53692.0
2023-06-26 18:30:00	SPY	ETF	431.71	431.98	431.71	431.97	48477.0
2023-06-26 19:00:00	SPY	ETF	431.98	432.13	431.97	432.05	42541.0
2023-06-26 19:30:00	SPY	ETF	432.08	432.25	432.08	432.22	50033.0
2023-06-26 04:00:00	QQQ	ETF	362.36	363.0	361.61	361.63	45610.0
2023-06-26 04:30:00	QQQ	ETF	361.51	362.0	361.27	361.39	18221.0
2023-06-26 05:00:00	QQQ	ETF	361.47	361.89	361.47	361.89	16150.0
2023-06-26 05:30:00	QQQ	ETF	361.71	362.14	361.71	361.94	15093.0
2023-06-26 06:00:00	QQQ	ETF	361.91	361.91	361.66	361.7	2976.0
2023-06-26 06:30:00	QQQ	ETF	361.74	362.04	361.6	361.7	12163.0
2023-06-26 07:00:00	QQQ	ETF	361.69	362.02	361.55	361.92	35356.0
2023-06-26 07:30:00	QQQ	ETF	361.97	362.43	361.83	362.31	48338.0
2023-06-26 08:00:00	QQQ	ETF	361.8718	363.6	361.5801	362.66	106537.0
2023-06-26 08:30:00	QQQ	ETF	362.7	362.83	362.39	362.61	76197.0
2023-06-26 09:00:00	QQQ	ETF	362.61	362.74	362.04	362.04	154965.0
2023-06-26 09:30:00	QQQ	ETF	362.0	364.555	361.78	364.49	3622620.0
2023-06-26 10:00:00	QQQ	ETF	364.49	364.84	363.81	364.2	2453421.0
2023-06-26 10:30:00	QQQ	ETF	364.19	364.25	361.91	363.15	3190752.0
2023-06-26 11:00:00	QQQ	ETF	363.14	363.185	360.78	361.158	2741593.0
2023-06-26 11:30:00	QQQ	ETF	361.15	361.88	360.67	361.51	2296513.0
2023-06-26 12:00:00	QQQ	ETF	361.5	361.53	359.0525	359.14	3415198.0
2023-06-26 12:30:00	QQQ	ETF	359.15	359.355	358.25	359.13	3114971.0

> showing 50 of 27,513 rows — these rows as CSV

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