PREVIEW / etf_30min / 2005-06-30

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-06-30.parquet
  size:    44 KB
  rows:    1,536

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
2005-06-30 07:00:00	SPY	ETF	120.08	120.12	120.08	120.12	8000.0
2005-06-30 07:30:00	SPY	ETF	120.11	120.11	120.11	120.11	3500.0
2005-06-30 08:00:00	SPY	ETF	120.12	120.15	120.1	120.12	35700.0
2005-06-30 08:30:00	SPY	ETF	120.13	120.29	120.13	120.29	54100.0
2005-06-30 09:00:00	SPY	ETF	120.29	120.3	120.18	120.2	410300.0
2005-06-30 09:30:00	SPY	ETF	120.22	120.32	120.15	120.23	4956000.0
2005-06-30 10:00:00	SPY	ETF	120.23	120.25	120.13	120.17	2336900.0
2005-06-30 10:30:00	SPY	ETF	120.17	120.22	120.01	120.04	3387300.0
2005-06-30 11:00:00	SPY	ETF	120.03	120.04	119.87	119.95	2624600.0
2005-06-30 11:30:00	SPY	ETF	119.95	120.02	119.89	119.98	1459300.0
2005-06-30 12:00:00	SPY	ETF	119.97	120.02	119.93	119.96	1091900.0
2005-06-30 12:30:00	SPY	ETF	119.96	120.01	119.9	119.93	1136100.0
2005-06-30 13:00:00	SPY	ETF	119.92	119.99	119.88	119.91	1348900.0
2005-06-30 13:30:00	SPY	ETF	119.91	120.06	119.75	120.03	3433900.0
2005-06-30 14:00:00	SPY	ETF	120.03	120.2	119.57	119.72	9739600.0
2005-06-30 14:30:00	SPY	ETF	119.72	120.03	119.29	119.59	11441200.0
2005-06-30 15:00:00	SPY	ETF	119.6	119.73	119.39	119.45	4850800.0
2005-06-30 15:30:00	SPY	ETF	119.45	119.99	118.95	119.06	10008500.0
2005-06-30 16:00:00	SPY	ETF	119.06	119.18	119.06	119.17	2290300.0
2005-06-30 16:30:00	SPY	ETF	119.16	119.17	119.11	119.17	126700.0
2005-06-30 17:00:00	SPY	ETF	119.14	119.17	119.14	119.17	7000.0
2005-06-30 17:30:00	SPY	ETF	119.19	119.19	119.19	119.19	1400.0
2005-06-30 18:00:00	SPY	ETF	119.14	119.14	119.13	119.14	4400.0
2005-06-30 18:30:00	SPY	ETF	119.16	119.16	119.16	119.16	500.0
2005-06-30 19:30:00	SPY	ETF	119.17	119.17	119.17	119.17	1600.0
2005-06-30 09:30:00	QQQ	ETF	37.14	37.21	37.1	37.12	7257800.0
2005-06-30 10:00:00	QQQ	ETF	37.12	37.15	37.06	37.14	3614900.0
2005-06-30 10:30:00	QQQ	ETF	37.14	37.17	37.07	37.09	3660200.0
2005-06-30 11:00:00	QQQ	ETF	37.09	37.09	36.96	36.99	7248200.0
2005-06-30 11:30:00	QQQ	ETF	37.0	37.05	36.98	37.01	4113000.0
2005-06-30 12:00:00	QQQ	ETF	37.01	37.04	37.0	37.0	1878800.0
2005-06-30 12:30:00	QQQ	ETF	37.0	37.04	36.99	37.0	1109400.0
2005-06-30 13:00:00	QQQ	ETF	37.01	37.06	37.0	37.03	972100.0
2005-06-30 13:30:00	QQQ	ETF	37.03	37.15	36.99	37.13	3252100.0
2005-06-30 14:00:00	QQQ	ETF	37.14	37.21	36.96	37.04	10285400.0
2005-06-30 14:30:00	QQQ	ETF	37.04	37.06	36.84	36.94	14100700.0
2005-06-30 15:00:00	QQQ	ETF	36.94	37.03	36.91	36.95	7517500.0
2005-06-30 15:30:00	QQQ	ETF	36.95	36.97	36.75	36.78	13864300.0
2005-06-30 08:00:00	IWM	ETF	63.96	63.96	63.96	63.96	100.0
2005-06-30 08:30:00	IWM	ETF	64.06	64.1	64.06	64.1	2100.0
2005-06-30 09:00:00	IWM	ETF	64.08	64.1	64.08	64.1	5600.0
2005-06-30 09:30:00	IWM	ETF	64.07	64.17	64.0	64.07	3804300.0
2005-06-30 10:00:00	IWM	ETF	64.09	64.11	63.94	63.98	2010900.0
2005-06-30 10:30:00	IWM	ETF	63.98	64.06	63.91	63.93	959300.0
2005-06-30 11:00:00	IWM	ETF	63.92	63.92	63.84	63.9	1050900.0
2005-06-30 11:30:00	IWM	ETF	63.89	64.0	63.89	63.93	844100.0
2005-06-30 12:00:00	IWM	ETF	63.94	64.01	63.92	63.97	967800.0
2005-06-30 12:30:00	IWM	ETF	63.97	64.0	63.95	63.99	172100.0
2005-06-30 13:00:00	IWM	ETF	63.98	64.03	63.98	64.0	793500.0
2005-06-30 13:30:00	IWM	ETF	64.0	64.17	63.94	64.14	667300.0

> showing 50 of 1,536 rows — these rows as CSV

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