PREVIEW / etf_1hour / 2005-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-26.parquet
  size:    29 KB
  rows:    869

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-26 06:00:00	SPY	ETF	119.8	119.8	119.8	119.8	500.0
2005-05-26 07:00:00	SPY	ETF	119.72	119.78	119.72	119.78	10700.0
2005-05-26 08:00:00	SPY	ETF	119.75	119.92	119.72	119.83	338900.0
2005-05-26 09:00:00	SPY	ETF	119.87	119.9	119.62	119.67	5634400.0
2005-05-26 10:00:00	SPY	ETF	119.67	120.1	119.62	119.98	11353100.0
2005-05-26 11:00:00	SPY	ETF	119.98	120.04	119.85	119.97	4136300.0
2005-05-26 12:00:00	SPY	ETF	119.97	120.03	119.9	119.98	2094600.0
2005-05-26 13:00:00	SPY	ETF	119.98	120.0	119.76	119.92	3956100.0
2005-05-26 14:00:00	SPY	ETF	119.92	120.1	119.85	119.9112	4876800.0
2005-05-26 15:00:00	SPY	ETF	119.92	120.21	119.91	120.05	7274700.0
2005-05-26 16:00:00	SPY	ETF	120.05	120.08	119.955	120.02	2166700.0
2005-05-26 17:00:00	SPY	ETF	120.01	120.02	119.97	120.01	66300.0
2005-05-26 18:00:00	SPY	ETF	120.03	120.03	119.95	119.95	6300.0
2005-05-26 19:00:00	SPY	ETF	119.95	120.0	119.95	120.0	3500.0
2005-05-26 09:00:00	QQQ	ETF	37.99	38.1	37.98	38.02	12076400.0
2005-05-26 10:00:00	QQQ	ETF	38.02	38.27	38.01	38.19	25056300.0
2005-05-26 11:00:00	QQQ	ETF	38.18	38.2	38.13	38.19	6739900.0
2005-05-26 12:00:00	QQQ	ETF	38.19	38.22	38.17	38.18	3358100.0
2005-05-26 13:00:00	QQQ	ETF	38.17	38.19	38.08	38.15	7120800.0
2005-05-26 14:00:00	QQQ	ETF	38.15	38.2	38.09	38.1	7215300.0
2005-05-26 15:00:00	QQQ	ETF	38.11	38.26	38.1	38.18	15031400.0
2005-05-26 08:00:00	IWM	ETF	60.55	60.63	60.55	60.625	11800.0
2005-05-26 09:00:00	IWM	ETF	60.58	60.84	60.545	60.71	2500600.0
2005-05-26 10:00:00	IWM	ETF	60.72	61.155	60.705	61.01	7171200.0
2005-05-26 11:00:00	IWM	ETF	60.995	61.01	60.865	60.965	2174600.0
2005-05-26 12:00:00	IWM	ETF	60.97	61.06	60.915	61.0	605800.0
2005-05-26 13:00:00	IWM	ETF	61.005	61.035	60.9	60.935	1289000.0
2005-05-26 14:00:00	IWM	ETF	60.935	61.005	60.91	60.955	1517800.0
2005-05-26 15:00:00	IWM	ETF	60.965	61.18	60.955	61.18	4540600.0
2005-05-26 16:00:00	IWM	ETF	61.18	61.185	61.11	61.135	71200.0
2005-05-26 07:00:00	DIA	ETF	104.96	105.0	104.95	104.98	12400.0
2005-05-26 08:00:00	DIA	ETF	104.93	105.05	104.93	105.04	16000.0
2005-05-26 09:00:00	DIA	ETF	105.05	105.07	104.84	104.89	343400.0
2005-05-26 10:00:00	DIA	ETF	104.89	105.25	104.86	105.16	1347500.0
2005-05-26 11:00:00	DIA	ETF	105.15	105.24	105.06	105.15	359200.0
2005-05-26 12:00:00	DIA	ETF	105.14	105.16	105.07	105.1	270000.0
2005-05-26 13:00:00	DIA	ETF	105.11	105.15	104.91	105.05	548600.0
2005-05-26 14:00:00	DIA	ETF	105.05	105.17	105.01	105.07	452900.0
2005-05-26 15:00:00	DIA	ETF	105.06	105.35	105.05	105.28	1327000.0
2005-05-26 16:00:00	DIA	ETF	105.28	105.3	105.21	105.21	57800.0
2005-05-26 17:00:00	DIA	ETF	105.25	105.3	105.25	105.3	2700.0
2005-05-26 08:00:00	GLD	ETF	41.79	41.79	41.79	41.79	100.0
2005-05-26 09:00:00	GLD	ETF	41.73	41.81	41.72	41.78	76800.0
2005-05-26 10:00:00	GLD	ETF	41.79	41.79	41.7	41.74	68300.0
2005-05-26 11:00:00	GLD	ETF	41.73	41.75	41.7	41.72	65200.0
2005-05-26 12:00:00	GLD	ETF	41.71	41.74	41.65	41.73	37900.0
2005-05-26 13:00:00	GLD	ETF	41.74	41.74	41.7	41.73	42900.0
2005-05-26 14:00:00	GLD	ETF	41.73	41.73	41.68	41.7	16200.0
2005-05-26 15:00:00	GLD	ETF	41.7	41.71	41.67	41.69	32700.0
2005-05-26 08:00:00	TLT	ETF	93.87	93.87	93.7	93.7	8400.0

> showing 50 of 869 rows — these rows as CSV

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