PREVIEW / etf_30min / 2005-10-27

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-10-27.parquet
  size:    51 KB
  rows:    1,745

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-10-27 05:00:00	SPY	ETF	118.95	118.95	118.95	118.95	500.0
2005-10-27 07:00:00	SPY	ETF	119.06	119.11	119.06	119.1	7800.0
2005-10-27 07:30:00	SPY	ETF	119.11	119.11	119.0	119.05	53200.0
2005-10-27 08:00:00	SPY	ETF	119.06	119.13	118.96	119.04	825100.0
2005-10-27 08:30:00	SPY	ETF	119.06	119.1	118.92	119.09	427800.0
2005-10-27 09:00:00	SPY	ETF	119.08	119.22	118.94	119.21	225600.0
2005-10-27 09:30:00	SPY	ETF	119.2	119.37	118.93	119.16	6215600.0
2005-10-27 10:00:00	SPY	ETF	119.13	119.19	118.88	118.95	4527600.0
2005-10-27 10:30:00	SPY	ETF	118.95	119.0	118.61	118.83	8030300.0
2005-10-27 11:00:00	SPY	ETF	118.81	119.1	118.75	118.98	3977500.0
2005-10-27 11:30:00	SPY	ETF	118.98	119.01	118.66	118.8	1898400.0
2005-10-27 12:00:00	SPY	ETF	118.83	119.05	118.75	118.96	1335900.0
2005-10-27 12:30:00	SPY	ETF	118.95	119.06	118.81	118.95	3003600.0
2005-10-27 13:00:00	SPY	ETF	118.9501	119.01	118.46	118.47	4724200.0
2005-10-27 13:30:00	SPY	ETF	118.46	118.83	118.44	118.78	4452600.0
2005-10-27 14:00:00	SPY	ETF	118.7501	118.77	118.57	118.59	2316000.0
2005-10-27 14:30:00	SPY	ETF	118.6	118.69	118.3	118.35	4151700.0
2005-10-27 15:00:00	SPY	ETF	118.36	118.39	118.07	118.13	8170500.0
2005-10-27 15:30:00	SPY	ETF	118.13	118.36	117.94	117.98	9390800.0
2005-10-27 16:00:00	SPY	ETF	117.97	118.29	117.85	118.29	2017200.0
2005-10-27 16:30:00	SPY	ETF	117.93	118.05	117.89	118.01	1392700.0
2005-10-27 17:00:00	SPY	ETF	118.03	118.03	117.94	117.94	21300.0
2005-10-27 17:30:00	SPY	ETF	117.92	117.98	117.89	117.98	20300.0
2005-10-27 18:00:00	SPY	ETF	117.92	118.2173	117.83	117.84	27200.0
2005-10-27 18:30:00	SPY	ETF	117.82	117.82	117.81	117.81	900.0
2005-10-27 19:00:00	SPY	ETF	117.81	117.86	117.8	117.8	4400.0
2005-10-27 19:30:00	SPY	ETF	117.79	117.84	117.79	117.84	2500.0
2005-10-27 09:30:00	QQQ	ETF	38.78	38.81	38.66	38.67	12160700.0
2005-10-27 10:00:00	QQQ	ETF	38.67	38.7	38.54	38.58	11117800.0
2005-10-27 10:30:00	QQQ	ETF	38.58	38.62	38.42	38.46	17658400.0
2005-10-27 11:00:00	QQQ	ETF	38.46	38.56	38.44	38.53	6627400.0
2005-10-27 11:30:00	QQQ	ETF	38.53	38.54	38.42	38.47	7533800.0
2005-10-27 12:00:00	QQQ	ETF	38.47	38.56	38.47	38.53	3208000.0
2005-10-27 12:30:00	QQQ	ETF	38.53	38.55	38.47	38.52	2347400.0
2005-10-27 13:00:00	QQQ	ETF	38.52	38.53	38.26	38.27	10868500.0
2005-10-27 13:30:00	QQQ	ETF	38.28	38.44	38.26	38.41	7015500.0
2005-10-27 14:00:00	QQQ	ETF	38.41	38.42	38.3	38.32	4615200.0
2005-10-27 14:30:00	QQQ	ETF	38.32	38.35	38.2	38.21	5497000.0
2005-10-27 15:00:00	QQQ	ETF	38.21	39.04	38.04	38.1	16838200.0
2005-10-27 15:30:00	QQQ	ETF	38.1	38.24	38.03	38.05	16319100.0
2005-10-27 07:30:00	IWM	ETF	63.18	63.18	63.18	63.18	1000.0
2005-10-27 08:00:00	IWM	ETF	63.28	63.28	63.08	63.09	117200.0
2005-10-27 08:30:00	IWM	ETF	63.15	63.15	63.09	63.15	22400.0
2005-10-27 09:00:00	IWM	ETF	63.21	63.29	63.21	63.26	17600.0
2005-10-27 09:30:00	IWM	ETF	63.265	63.33	62.86	62.94	3624700.0
2005-10-27 10:00:00	IWM	ETF	62.94	63.0	62.72	62.75	1742700.0
2005-10-27 10:30:00	IWM	ETF	62.73	62.73	62.53	62.67	3197600.0
2005-10-27 11:00:00	IWM	ETF	62.65	62.85	62.62	62.81	1344500.0
2005-10-27 11:30:00	IWM	ETF	62.8	62.81	62.56	62.66	851300.0
2005-10-27 12:00:00	IWM	ETF	62.66	62.77	62.62	62.73	374000.0

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

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