PREVIEW / etf_1hour / 2004-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-12.parquet
  size:    28 KB
  rows:    777

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
2004-11-12 08:00:00	SPY	ETF	117.89	118.05	117.86	118.02	119500.0
2004-11-12 09:00:00	SPY	ETF	117.99	118.04	117.68	117.85	8099100.0
2004-11-12 10:00:00	SPY	ETF	117.84	118.11	117.75	117.93	8514600.0
2004-11-12 11:00:00	SPY	ETF	117.93	118.19	117.85	117.98	5701400.0
2004-11-12 12:00:00	SPY	ETF	117.98	118.35	117.96	118.26	4781100.0
2004-11-12 13:00:00	SPY	ETF	118.26	118.38	118.2	118.27	3194700.0
2004-11-12 14:00:00	SPY	ETF	118.27	118.83	118.25	118.64	9209300.0
2004-11-12 15:00:00	SPY	ETF	118.66	118.97	118.63	118.91	10493800.0
2004-11-12 16:00:00	SPY	ETF	118.95	119.0	118.7	118.8	3362300.0
2004-11-12 17:00:00	SPY	ETF	118.8	118.95	118.72	118.8	54900.0
2004-11-12 18:00:00	SPY	ETF	118.78	118.79	118.78	118.78	4400.0
2004-11-12 19:00:00	SPY	ETF	118.78	118.79	118.78	118.78	1700.0
2004-11-12 08:00:00	QQQ	ETF	38.38	38.42	38.26	38.37	380400.0
2004-11-12 09:00:00	QQQ	ETF	38.37	38.4	38.17	38.24	15796700.0
2004-11-12 10:00:00	QQQ	ETF	38.25	38.49	38.22	38.37	21427400.0
2004-11-12 11:00:00	QQQ	ETF	38.38	38.508	38.32	38.335	11048600.0
2004-11-12 12:00:00	QQQ	ETF	38.335	38.46	38.31	38.402	7766800.0
2004-11-12 13:00:00	QQQ	ETF	38.409	38.47	38.388	38.42	4957100.0
2004-11-12 14:00:00	QQQ	ETF	38.42	38.62	38.41	38.53	16272800.0
2004-11-12 15:00:00	QQQ	ETF	38.53	38.68	38.51	38.66	19171500.0
2004-11-12 16:00:00	QQQ	ETF	38.66	38.7	38.4712	38.7	3697600.0
2004-11-12 17:00:00	QQQ	ETF	38.68	38.7	38.5233	38.68	279800.0
2004-11-12 18:00:00	QQQ	ETF	38.68	38.69	38.68	38.69	5600.0
2004-11-12 19:00:00	QQQ	ETF	38.69	38.7	38.69	38.7	7200.0
2004-11-12 09:00:00	IWM	ETF	61.36	61.475	61.175	61.225	1447400.0
2004-11-12 10:00:00	IWM	ETF	61.22	61.45	61.205	61.335	1319800.0
2004-11-12 11:00:00	IWM	ETF	61.33	61.54	61.3	61.455	654600.0
2004-11-12 12:00:00	IWM	ETF	61.425	61.6	61.415	61.54	1174400.0
2004-11-12 13:00:00	IWM	ETF	61.525	61.57	61.495	61.54	677400.0
2004-11-12 14:00:00	IWM	ETF	61.545	61.915	61.54	61.835	3596000.0
2004-11-12 15:00:00	IWM	ETF	61.835	62.025	61.8	61.995	2623800.0
2004-11-12 16:00:00	IWM	ETF	61.995	62.025	61.925	61.95	506200.0
2004-11-12 17:00:00	IWM	ETF	61.915	61.915	61.915	61.915	1800.0
2004-11-12 18:00:00	IWM	ETF	62.015	62.015	62.015	62.015	400.0
2004-11-12 08:00:00	DIA	ETF	105.02	105.21	105.02	105.19	5700.0
2004-11-12 09:00:00	DIA	ETF	105.14	105.24	105.0	105.06	434400.0
2004-11-12 10:00:00	DIA	ETF	105.07	105.33	105.01	105.12	591300.0
2004-11-12 11:00:00	DIA	ETF	105.12	105.28	105.04	105.08	493700.0
2004-11-12 12:00:00	DIA	ETF	105.07	105.39	105.06	105.29	428900.0
2004-11-12 13:00:00	DIA	ETF	105.28	105.37	105.19	105.2484	343400.0
2004-11-12 14:00:00	DIA	ETF	105.25	105.74	105.23	105.55	779900.0
2004-11-12 15:00:00	DIA	ETF	105.54	105.76	105.53	105.73	900900.0
2004-11-12 16:00:00	DIA	ETF	105.74	105.75	105.62	105.69	88100.0
2004-11-12 17:00:00	DIA	ETF	105.65	105.65	105.65	105.65	2500.0
2004-11-12 19:00:00	DIA	ETF	105.64	105.64	105.63	105.63	200.0
2004-11-12 08:00:00	TLT	ETF	87.31	87.31	87.3	87.3	1500.0
2004-11-12 09:00:00	TLT	ETF	87.33	87.51	87.31	87.45	183700.0
2004-11-12 10:00:00	TLT	ETF	87.44	87.79	87.39	87.79	116100.0
2004-11-12 11:00:00	TLT	ETF	87.82	88.11	87.78	88.02	366300.0
2004-11-12 12:00:00	TLT	ETF	88.02	88.1	87.96	88.01	121500.0

> showing 50 of 777 rows — these rows as CSV

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