PREVIEW / etf_30min / 2024-03-28

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-28.parquet
  size:    809 KB
  rows:    32,222

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-03-28 04:00:00	SPY	ETF	522.82	522.89	522.6	522.89	34464.0
2024-03-28 04:30:00	SPY	ETF	522.78	522.96	522.73	522.73	9442.0
2024-03-28 05:00:00	SPY	ETF	522.74	522.91	522.43	522.43	7127.0
2024-03-28 05:30:00	SPY	ETF	522.41	522.58	522.41	522.51	3492.0
2024-03-28 06:00:00	SPY	ETF	522.68	523.03	522.68	523.02	26274.0
2024-03-28 06:30:00	SPY	ETF	523.0	523.15	522.89	522.99	4891.0
2024-03-28 07:00:00	SPY	ETF	522.86	523.05	522.86	522.97	17653.0
2024-03-28 07:30:00	SPY	ETF	522.97	522.97	522.56	522.87	56540.0
2024-03-28 08:00:00	SPY	ETF	522.85	523.15	522.54	523.0	242023.0
2024-03-28 08:30:00	SPY	ETF	522.99	523.48	522.6	523.11	246110.0
2024-03-28 09:00:00	SPY	ETF	523.17	523.38	523.03	523.21	118090.0
2024-03-28 09:30:00	SPY	ETF	523.21	523.6707	522.78	523.24	3068074.0
2024-03-28 10:00:00	SPY	ETF	523.25	523.73	522.93	523.15	3350239.0
2024-03-28 10:30:00	SPY	ETF	523.15	523.55	523.04	523.43	1935253.0
2024-03-28 11:00:00	SPY	ETF	523.42	523.63	523.16	523.57	2013402.0
2024-03-28 11:30:00	SPY	ETF	523.5799	523.73	523.25	523.59	1674438.0
2024-03-28 12:00:00	SPY	ETF	523.59	523.6	523.14	523.47	1939579.0
2024-03-28 12:30:00	SPY	ETF	523.47	523.48	523.08	523.35	2319563.0
2024-03-28 13:00:00	SPY	ETF	523.35	523.49	522.98	523.125	1959730.0
2024-03-28 13:30:00	SPY	ETF	523.125	523.4801	522.92	523.38	1583371.0
2024-03-28 14:00:00	SPY	ETF	523.39	523.645	523.09	523.52	2626485.0
2024-03-28 14:30:00	SPY	ETF	523.525	524.285	523.02	524.13	3856544.0
2024-03-28 15:00:00	SPY	ETF	524.14	524.58	523.6	524.458	4565598.0
2024-03-28 15:30:00	SPY	ETF	524.46	524.61	522.93	523.12	14579855.0
2024-03-28 16:00:00	SPY	ETF	523.12	523.4758	522.77	523.19	6010663.0
2024-03-28 16:30:00	SPY	ETF	523.2	523.24	522.95	523.02	211373.0
2024-03-28 17:00:00	SPY	ETF	522.9905	523.0495	522.9	522.9	70114.0
2024-03-28 17:30:00	SPY	ETF	522.88	522.96	522.8002	522.85	71581.0
2024-03-28 18:00:00	SPY	ETF	522.86	523.55	522.86	523.43	67781.0
2024-03-28 18:30:00	SPY	ETF	523.37	523.45	523.2	523.2	15120.0
2024-03-28 19:00:00	SPY	ETF	523.19	523.19	522.93	523.19	7514.0
2024-03-28 19:30:00	SPY	ETF	523.08	523.08	522.95	522.95	5761.0
2024-03-28 04:00:00	QQQ	ETF	444.9	445.16	444.58	444.71	33641.0
2024-03-28 04:30:00	QQQ	ETF	444.57	444.79	444.5	444.5	6730.0
2024-03-28 05:00:00	QQQ	ETF	444.55	444.63	443.97	443.99	11457.0
2024-03-28 05:30:00	QQQ	ETF	443.97	444.33	443.88	444.32	15315.0
2024-03-28 06:00:00	QQQ	ETF	444.39	444.89	444.39	444.86	59738.0
2024-03-28 06:30:00	QQQ	ETF	444.89	444.95	444.6	444.6	18845.0
2024-03-28 07:00:00	QQQ	ETF	444.59	444.87	444.55	444.7	63788.0
2024-03-28 07:30:00	QQQ	ETF	444.65	444.65	444.27	444.62	63952.0
2024-03-28 08:00:00	QQQ	ETF	443.24	445.1296	443.24	444.85	72016.0
2024-03-28 08:30:00	QQQ	ETF	444.7	445.45	444.21	444.75	119340.0
2024-03-28 09:00:00	QQQ	ETF	444.83	445.06	444.71	444.79	138500.0
2024-03-28 09:30:00	QQQ	ETF	444.79	445.61	443.76	445.0399	2835131.0
2024-03-28 10:00:00	QQQ	ETF	445.04	445.64	444.14	444.4666	2193940.0
2024-03-28 10:30:00	QQQ	ETF	444.48	445.1	444.33	444.82	1628216.0
2024-03-28 11:00:00	QQQ	ETF	444.82	445.05	444.39	444.9	1628023.0
2024-03-28 11:30:00	QQQ	ETF	444.8988	445.08	444.35	445.0	1226180.0
2024-03-28 12:00:00	QQQ	ETF	445.011	445.03	444.0	444.5	1238702.0
2024-03-28 12:30:00	QQQ	ETF	444.5	444.5203	444.1	444.32	1205719.0

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

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