PREVIEW / etf_1hour / 2005-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-02.parquet
  size:    29 KB
  rows:    870

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-02 06:00:00	SPY	ETF	120.46	120.46	120.46	120.46	1500.0
2005-06-02 07:00:00	SPY	ETF	120.47	120.49	120.47	120.47	20600.0
2005-06-02 08:00:00	SPY	ETF	120.44	120.44	120.23	120.29	157700.0
2005-06-02 09:00:00	SPY	ETF	120.3	120.4	120.1	120.36	5781800.0
2005-06-02 10:00:00	SPY	ETF	120.36	120.56	120.18	120.43	8836000.0
2005-06-02 11:00:00	SPY	ETF	120.42	120.56	120.33	120.48	3471900.0
2005-06-02 12:00:00	SPY	ETF	120.48	120.65	120.47	120.52	3061600.0
2005-06-02 13:00:00	SPY	ETF	120.53	120.59	120.37	120.5	3671500.0
2005-06-02 14:00:00	SPY	ETF	120.5	120.8	120.47	120.73	5119400.0
2005-06-02 15:00:00	SPY	ETF	120.73	120.84	120.59	120.72	5982500.0
2005-06-02 16:00:00	SPY	ETF	120.73	120.82	120.64	120.76	1838600.0
2005-06-02 17:00:00	SPY	ETF	120.77	120.78	120.73	120.75	54800.0
2005-06-02 18:00:00	SPY	ETF	120.78	120.78	120.76	120.76	1500.0
2005-06-02 19:00:00	SPY	ETF	120.77	120.77	120.74	120.77	4200.0
2005-06-02 09:00:00	QQQ	ETF	38.34	38.49	38.3	38.46	11682900.0
2005-06-02 10:00:00	QQQ	ETF	38.46	38.53	38.37	38.44	12666700.0
2005-06-02 11:00:00	QQQ	ETF	38.44	38.53	38.39	38.47	6749300.0
2005-06-02 12:00:00	QQQ	ETF	38.47	38.63	38.47	38.51	7144600.0
2005-06-02 13:00:00	QQQ	ETF	38.51	39.49	38.44	38.49	5099300.0
2005-06-02 14:00:00	QQQ	ETF	38.5	38.61	38.49	38.58	14850100.0
2005-06-02 15:00:00	QQQ	ETF	38.59	38.66	38.55	38.65	11370500.0
2005-06-02 08:00:00	IWM	ETF	62.125	62.125	62.035	62.035	3400.0
2005-06-02 09:00:00	IWM	ETF	62.035	62.145	61.845	62.045	1028400.0
2005-06-02 10:00:00	IWM	ETF	62.045	62.25	61.935	62.135	3825000.0
2005-06-02 11:00:00	IWM	ETF	62.135	62.31	62.05	62.2	1139600.0
2005-06-02 12:00:00	IWM	ETF	62.2	62.34	62.18	62.185	1724200.0
2005-06-02 13:00:00	IWM	ETF	62.19	62.215	61.91	62.035	3020200.0
2005-06-02 14:00:00	IWM	ETF	62.03	62.26	62.025	62.195	1183200.0
2005-06-02 15:00:00	IWM	ETF	62.21	62.245	62.095	62.17	1810800.0
2005-06-02 16:00:00	IWM	ETF	62.165	62.235	62.16	62.22	223200.0
2005-06-02 17:00:00	IWM	ETF	62.185	62.22	62.165	62.22	18000.0
2005-06-02 07:00:00	DIA	ETF	105.3	105.3	105.3	105.3	400.0
2005-06-02 08:00:00	DIA	ETF	105.25	105.31	105.2	105.2	1100.0
2005-06-02 09:00:00	DIA	ETF	105.19	105.26	105.04	105.19	740200.0
2005-06-02 10:00:00	DIA	ETF	105.2	105.34	105.07	105.18	561000.0
2005-06-02 11:00:00	DIA	ETF	105.21	105.38	105.13	105.3	231400.0
2005-06-02 12:00:00	DIA	ETF	105.3	105.45	105.29	105.33	527500.0
2005-06-02 13:00:00	DIA	ETF	105.34	105.35	105.18	105.2801	215400.0
2005-06-02 14:00:00	DIA	ETF	105.29	105.56	105.27	105.47	355900.0
2005-06-02 15:00:00	DIA	ETF	105.47	105.55	105.3	105.45	807500.0
2005-06-02 16:00:00	DIA	ETF	105.47	105.51	105.47	105.51	5200.0
2005-06-02 17:00:00	DIA	ETF	105.47	105.47	105.47	105.47	300.0
2005-06-02 18:00:00	DIA	ETF	105.47	105.47	105.47	105.47	100.0
2005-06-02 08:00:00	GLD	ETF	41.73	41.88	41.73	41.85	220700.0
2005-06-02 09:00:00	GLD	ETF	41.84	42.03	41.83	41.98	810400.0
2005-06-02 10:00:00	GLD	ETF	41.99	42.17	41.94	42.16	2767000.0
2005-06-02 11:00:00	GLD	ETF	42.14	42.16	42.03	42.08	429100.0
2005-06-02 12:00:00	GLD	ETF	42.08	42.26	42.06	42.22	424300.0
2005-06-02 13:00:00	GLD	ETF	42.23	42.28	42.11	42.16	217600.0
2005-06-02 14:00:00	GLD	ETF	42.16	42.19	42.14	42.15	186800.0

> showing 50 of 870 rows — these rows as CSV

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