PREVIEW / etf_1hour / 2005-01-20

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-20.parquet
  size:    28 KB
  rows:    811

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-01-20 08:00:00	SPY	ETF	117.82	117.89	117.8	117.86	316600.0
2005-01-20 09:00:00	SPY	ETF	117.86	118.05	117.67	117.77	8819600.0
2005-01-20 10:00:00	SPY	ETF	117.76	118.2	117.7	117.88	14274000.0
2005-01-20 11:00:00	SPY	ETF	117.89	118.19	117.87	118.01	4559900.0
2005-01-20 12:00:00	SPY	ETF	118.02	118.03	117.71	117.75	5757900.0
2005-01-20 13:00:00	SPY	ETF	117.75	117.85	117.29	117.5	10929700.0
2005-01-20 14:00:00	SPY	ETF	117.54	118.09	117.54	117.88	12235500.0
2005-01-20 15:00:00	SPY	ETF	117.88	117.95	117.42	117.56	11662200.0
2005-01-20 16:00:00	SPY	ETF	117.53	117.65	117.45	117.55	1899700.0
2005-01-20 17:00:00	SPY	ETF	117.55	117.65	117.54	117.61	38500.0
2005-01-20 18:00:00	SPY	ETF	117.63	117.68	117.61	117.61	14000.0
2005-01-20 19:00:00	SPY	ETF	117.62	117.62	117.59	117.59	500.0
2005-01-20 09:00:00	QQQ	ETF	37.65	37.73	37.53	37.57	18216400.0
2005-01-20 10:00:00	QQQ	ETF	37.57	37.81	37.56	37.69	23640100.0
2005-01-20 11:00:00	QQQ	ETF	37.69	37.81	37.66	37.75	11822300.0
2005-01-20 12:00:00	QQQ	ETF	37.75	37.75	37.56	37.57	10370200.0
2005-01-20 13:00:00	QQQ	ETF	37.57	37.67	37.4	37.48	15861500.0
2005-01-20 14:00:00	QQQ	ETF	37.48	37.67	37.47	37.57	13676700.0
2005-01-20 15:00:00	QQQ	ETF	37.56	37.57	37.32	37.36	19592900.0
2005-01-20 08:00:00	IWM	ETF	61.015	61.025	60.975	61.02	8600.0
2005-01-20 09:00:00	IWM	ETF	61.005	61.23	60.865	60.92	4624200.0
2005-01-20 10:00:00	IWM	ETF	60.9	61.175	60.815	61.065	4956600.0
2005-01-20 11:00:00	IWM	ETF	61.05	61.485	61.05	61.385	3533200.0
2005-01-20 12:00:00	IWM	ETF	61.365	61.39	61.165	61.185	1462200.0
2005-01-20 13:00:00	IWM	ETF	61.19	61.325	60.865	61.06	4638000.0
2005-01-20 14:00:00	IWM	ETF	61.06	61.405	61.06	61.23	3287200.0
2005-01-20 15:00:00	IWM	ETF	61.22	61.35	60.885	60.975	4470400.0
2005-01-20 16:00:00	IWM	ETF	60.93	61.0	60.82	60.86	1043400.0
2005-01-20 17:00:00	IWM	ETF	60.92	60.95	60.91	60.95	610400.0
2005-01-20 18:00:00	IWM	ETF	60.95	60.975	60.95	60.975	2400.0
2005-01-20 19:00:00	IWM	ETF	60.975	60.975	60.975	60.975	400.0
2005-01-20 08:00:00	DIA	ETF	105.02	105.05	105.02	105.05	600.0
2005-01-20 09:00:00	DIA	ETF	105.04	105.16	104.97	105.08	1055800.0
2005-01-20 10:00:00	DIA	ETF	105.07	105.48	105.01	105.17	1599600.0
2005-01-20 11:00:00	DIA	ETF	105.17	105.41	105.12	105.24	1143200.0
2005-01-20 12:00:00	DIA	ETF	105.27	105.27	105.0	105.0	918200.0
2005-01-20 13:00:00	DIA	ETF	105.0	105.1	104.58	104.77	804200.0
2005-01-20 14:00:00	DIA	ETF	104.78	105.23	104.78	105.02	1596500.0
2005-01-20 15:00:00	DIA	ETF	105.0	105.05	104.6	104.74	1245600.0
2005-01-20 16:00:00	DIA	ETF	104.7	104.82	104.68	104.74	29500.0
2005-01-20 18:00:00	DIA	ETF	104.75	104.81	104.75	104.8	3200.0
2005-01-20 19:00:00	DIA	ETF	104.75	104.75	104.75	104.75	300.0
2005-01-20 09:00:00	GLD	ETF	42.12	42.3	42.11	42.25	135000.0
2005-01-20 10:00:00	GLD	ETF	42.26	42.32	42.2	42.2	340900.0
2005-01-20 11:00:00	GLD	ETF	42.19	42.27	42.16	42.25	438000.0
2005-01-20 12:00:00	GLD	ETF	42.26	42.27	42.18	42.23	54200.0
2005-01-20 13:00:00	GLD	ETF	42.23	42.26	42.22	42.24	24500.0
2005-01-20 14:00:00	GLD	ETF	42.26	42.26	42.22	42.25	118300.0
2005-01-20 15:00:00	GLD	ETF	42.25	42.25	42.18	42.25	160500.0
2005-01-20 09:00:00	TLT	ETF	90.4	90.45	90.35	90.43	19700.0

> showing 50 of 811 rows — these rows as CSV

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