PREVIEW / etf_1hour / 2005-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-23.parquet
  size:    30 KB
  rows:    880

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-05-23 07:00:00	SPY	ETF	119.29	119.4	119.26	119.32	228600.0
2005-05-23 08:00:00	SPY	ETF	119.32	119.36	119.24	119.26	103600.0
2005-05-23 09:00:00	SPY	ETF	119.24	119.53	119.18	119.51	6416400.0
2005-05-23 10:00:00	SPY	ETF	119.51	119.67	119.28	119.35	12054200.0
2005-05-23 11:00:00	SPY	ETF	119.34	119.52	119.2	119.51	6901200.0
2005-05-23 12:00:00	SPY	ETF	119.5	119.69	119.44	119.53	3912300.0
2005-05-23 13:00:00	SPY	ETF	119.52	119.63	119.39	119.54	2778400.0
2005-05-23 14:00:00	SPY	ETF	119.53	120.04	119.44	119.97	7143900.0
2005-05-23 15:00:00	SPY	ETF	119.97	120.03	119.6	119.65	9798600.0
2005-05-23 16:00:00	SPY	ETF	119.68	119.82	119.63	119.74	568700.0
2005-05-23 17:00:00	SPY	ETF	119.74	119.76	119.73	119.73	25200.0
2005-05-23 18:00:00	SPY	ETF	119.72	119.72	119.7	119.7	5700.0
2005-05-23 19:00:00	SPY	ETF	119.7	119.7	119.7	119.7	1600.0
2005-05-23 09:00:00	QQQ	ETF	37.66	37.83	37.64	37.81	11604100.0
2005-05-23 10:00:00	QQQ	ETF	37.81	37.88	37.66	37.67	14861200.0
2005-05-23 11:00:00	QQQ	ETF	37.67	37.77	37.6	37.76	8822500.0
2005-05-23 12:00:00	QQQ	ETF	37.76	37.85	37.73	37.76	9933900.0
2005-05-23 13:00:00	QQQ	ETF	37.76	37.84	37.74	37.82	4840800.0
2005-05-23 14:00:00	QQQ	ETF	37.82	37.99	37.79	37.94	13872800.0
2005-05-23 15:00:00	QQQ	ETF	37.95	37.96	37.8	37.84	24455300.0
2005-05-23 08:00:00	IWM	ETF	60.73	60.74	60.73	60.74	8400.0
2005-05-23 09:00:00	IWM	ETF	60.66	60.95	60.61	60.945	2644000.0
2005-05-23 10:00:00	IWM	ETF	60.95	61.025	60.78	60.835	3654200.0
2005-05-23 11:00:00	IWM	ETF	60.835	60.925	60.66	60.915	2727600.0
2005-05-23 12:00:00	IWM	ETF	60.915	60.995	60.83	60.9	1597200.0
2005-05-23 13:00:00	IWM	ETF	60.9	60.98	60.815	60.91	1451000.0
2005-05-23 14:00:00	IWM	ETF	60.915	61.25	60.86	61.2	2888200.0
2005-05-23 15:00:00	IWM	ETF	61.19	61.2	60.845	60.905	9047200.0
2005-05-23 16:00:00	IWM	ETF	60.86	61.06	60.855	61.0	607800.0
2005-05-23 19:00:00	IWM	ETF	61.0	61.0	61.0	61.0	200.0
2005-05-23 08:00:00	DIA	ETF	104.8	104.8	104.8	104.8	500.0
2005-05-23 09:00:00	DIA	ETF	104.67	105.01	104.63	105.0	654700.0
2005-05-23 10:00:00	DIA	ETF	105.01	105.22	104.85	104.91	976300.0
2005-05-23 11:00:00	DIA	ETF	104.91	104.99	104.79	104.98	335100.0
2005-05-23 12:00:00	DIA	ETF	104.99	105.13	104.95	105.03	497500.0
2005-05-23 13:00:00	DIA	ETF	105.03	105.09	104.93	105.07	258700.0
2005-05-23 14:00:00	DIA	ETF	105.07	105.5	105.0	105.45	991800.0
2005-05-23 15:00:00	DIA	ETF	105.42	105.5	105.09	105.15	1484800.0
2005-05-23 16:00:00	DIA	ETF	105.13	105.24	105.13	105.19	15800.0
2005-05-23 17:00:00	DIA	ETF	105.1	105.13	105.1	105.13	200.0
2005-05-23 08:00:00	GLD	ETF	41.65	41.65	41.62	41.62	34000.0
2005-05-23 09:00:00	GLD	ETF	41.67	41.74	41.62	41.74	3369900.0
2005-05-23 10:00:00	GLD	ETF	41.73	41.75	41.66	41.66	981700.0
2005-05-23 11:00:00	GLD	ETF	41.66	41.72	41.66	41.68	124900.0
2005-05-23 12:00:00	GLD	ETF	41.66	41.66	41.6	41.61	180000.0
2005-05-23 13:00:00	GLD	ETF	41.61	41.64	41.55	41.58	91800.0
2005-05-23 14:00:00	GLD	ETF	41.58	41.61	41.58	41.61	73900.0
2005-05-23 15:00:00	GLD	ETF	41.61	41.63	41.6	41.61	143600.0
2005-05-23 16:00:00	GLD	ETF	41.63	41.63	41.63	41.63	100.0
2005-05-23 08:00:00	TLT	ETF	93.27	93.27	93.27	93.27	5300.0

> showing 50 of 880 rows — these rows as CSV

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