PREVIEW / etf_30min / 2024-06-13

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-13.parquet
  size:    804 KB
  rows:    31,948

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-06-13 04:00:00	SPY	ETF	542.55	542.81	542.25	542.29	10970.0
2024-06-13 04:30:00	SPY	ETF	542.27	542.27	542.07	542.22	8351.0
2024-06-13 05:00:00	SPY	ETF	542.53	542.53	542.04	542.04	5172.0
2024-06-13 05:30:00	SPY	ETF	542.02	542.05	541.55	541.61	8751.0
2024-06-13 06:00:00	SPY	ETF	541.7	541.89	541.41	541.79	5850.0
2024-06-13 06:30:00	SPY	ETF	541.81	541.95	541.37	541.95	18097.0
2024-06-13 07:00:00	SPY	ETF	541.99	542.24	541.9	542.02	196824.0
2024-06-13 07:30:00	SPY	ETF	542.03	542.24	541.89	541.89	89257.0
2024-06-13 08:00:00	SPY	ETF	541.9782	542.88	541.8104	542.82	95689.0
2024-06-13 08:30:00	SPY	ETF	542.57	544.03	542.36	542.91	522840.0
2024-06-13 09:00:00	SPY	ETF	542.78	543.25	542.63	543.19	191141.0
2024-06-13 09:30:00	SPY	ETF	543.14	543.19	541.74	541.99	3443921.0
2024-06-13 10:00:00	SPY	ETF	541.99	542.285	540.43	541.04	2750720.0
2024-06-13 10:30:00	SPY	ETF	541.0404	541.35	540.51	540.56	1594306.0
2024-06-13 11:00:00	SPY	ETF	540.55	541.2	540.25	541.19	1405005.0
2024-06-13 11:30:00	SPY	ETF	541.17	541.65	541.115	541.21	1090960.0
2024-06-13 12:00:00	SPY	ETF	541.2	541.21	539.64	539.7512	1438321.0
2024-06-13 12:30:00	SPY	ETF	539.75	540.95	539.59	540.74	1401546.0
2024-06-13 13:00:00	SPY	ETF	540.72	541.9694	540.58	541.7201	1217919.0
2024-06-13 13:30:00	SPY	ETF	541.73	541.96	541.2	541.67	964527.0
2024-06-13 14:00:00	SPY	ETF	541.68	542.21	541.255	542.08	1378162.0
2024-06-13 14:30:00	SPY	ETF	542.075	542.58	541.98	542.49	1493287.0
2024-06-13 15:00:00	SPY	ETF	542.5	543.06	542.235	542.505	2200706.0
2024-06-13 15:30:00	SPY	ETF	542.51	543.325	542.18	542.4	5150621.0
2024-06-13 16:00:00	SPY	ETF	542.4	543.05	542.32	542.49	4249515.0
2024-06-13 16:30:00	SPY	ETF	542.49	542.55	542.15	542.32	155402.0
2024-06-13 17:00:00	SPY	ETF	542.3	542.39	542.25	542.26	13909.0
2024-06-13 17:30:00	SPY	ETF	542.28	542.31	542.22	542.28	10401.0
2024-06-13 18:00:00	SPY	ETF	542.28	542.45	542.01	542.45	58856.0
2024-06-13 18:30:00	SPY	ETF	542.28	542.45	542.28	542.38	4326.0
2024-06-13 19:00:00	SPY	ETF	542.45	542.46	542.25	542.46	5219.0
2024-06-13 19:30:00	SPY	ETF	542.45	542.53	542.42	542.5	12859.0
2024-06-13 04:00:00	QQQ	ETF	478.2	478.28	477.63	477.87	85902.0
2024-06-13 04:30:00	QQQ	ETF	477.83	477.9	477.5	477.76	34492.0
2024-06-13 05:00:00	QQQ	ETF	477.82	477.93	477.25	477.25	27155.0
2024-06-13 05:30:00	QQQ	ETF	477.25	477.3	476.5	476.72	83776.0
2024-06-13 06:00:00	QQQ	ETF	476.77	477.05	476.54	477.04	16918.0
2024-06-13 06:30:00	QQQ	ETF	477.04	477.22	476.65	477.22	11426.0
2024-06-13 07:00:00	QQQ	ETF	477.18	477.52	477.14	477.27	98108.0
2024-06-13 07:30:00	QQQ	ETF	477.23	477.36	477.0	477.1	35186.0
2024-06-13 08:00:00	QQQ	ETF	477.3089	478.58	473.795	477.77	182079.0
2024-06-13 08:30:00	QQQ	ETF	477.5	478.95	477.11	477.52	643672.0
2024-06-13 09:00:00	QQQ	ETF	477.5	477.85	477.2	477.75	218685.0
2024-06-13 09:30:00	QQQ	ETF	477.72	478.39	477.21	477.59	3146050.0
2024-06-13 10:00:00	QQQ	ETF	477.61	478.06	475.25	476.2	2306740.0
2024-06-13 10:30:00	QQQ	ETF	476.21	476.73	475.69	475.75	1393103.0
2024-06-13 11:00:00	QQQ	ETF	475.7901	476.67	475.51	476.34	958340.0
2024-06-13 11:30:00	QQQ	ETF	476.32	477.07	476.31	476.5325	884555.0
2024-06-13 12:00:00	QQQ	ETF	476.54	476.5593	474.42	474.6088	1454656.0
2024-06-13 12:30:00	QQQ	ETF	474.61	475.74	474.4201	475.48	1205156.0

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

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