PREVIEW / etf_1hour / 2004-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-22.parquet
  size:    25 KB
  rows:    693

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-04-22 08:00:00	SPY	ETF	112.72	112.74	112.32	112.56	168000.0
2004-04-22 09:00:00	SPY	ETF	112.53	112.88	112.44	112.8	2986600.0
2004-04-22 10:00:00	SPY	ETF	112.83	113.01	112.5	112.93	7432200.0
2004-04-22 11:00:00	SPY	ETF	112.95	114.11	112.94	114.0	18274100.0
2004-04-22 12:00:00	SPY	ETF	113.96	114.22	113.89	114.05	4208900.0
2004-04-22 13:00:00	SPY	ETF	113.99	114.66	113.96	114.53	7942700.0
2004-04-22 14:00:00	SPY	ETF	114.53	114.67	114.32	114.59	5819800.0
2004-04-22 15:00:00	SPY	ETF	114.59	114.64	114.21	114.44	8660300.0
2004-04-22 16:00:00	SPY	ETF	114.45	114.6	114.15	114.47	2884900.0
2004-04-22 17:00:00	SPY	ETF	114.49	114.6	114.445	114.6	259300.0
2004-04-22 18:00:00	SPY	ETF	114.52	114.52	114.46	114.49	15600.0
2004-04-22 19:00:00	SPY	ETF	114.48	114.49	114.48	114.49	1600.0
2004-04-22 08:00:00	QQQ	ETF	36.03	36.05	35.87	35.98	376100.0
2004-04-22 09:00:00	QQQ	ETF	35.99	36.232	35.97	36.181	12445600.0
2004-04-22 10:00:00	QQQ	ETF	36.181	36.38	36.05	36.35	21850100.0
2004-04-22 11:00:00	QQQ	ETF	36.367	36.87	36.35	36.742	37479900.0
2004-04-22 12:00:00	QQQ	ETF	36.75	36.85	36.69	36.77	11370500.0
2004-04-22 13:00:00	QQQ	ETF	36.78	36.99	36.76	36.932	12338500.0
2004-04-22 14:00:00	QQQ	ETF	36.932	37.01	36.889	36.99	12506500.0
2004-04-22 15:00:00	QQQ	ETF	36.986	37.0	36.81	36.92	19609800.0
2004-04-22 16:00:00	QQQ	ETF	36.92	37.213	36.79	37.132	5480200.0
2004-04-22 17:00:00	QQQ	ETF	37.138	37.25	37.13	37.19	703700.0
2004-04-22 18:00:00	QQQ	ETF	37.19	37.19	37.15	37.17	116200.0
2004-04-22 19:00:00	QQQ	ETF	37.18	37.18	37.15	37.17	33600.0
2004-04-22 08:00:00	IWM	ETF	58.0	58.14	58.0	58.14	1600.0
2004-04-22 09:00:00	IWM	ETF	58.07	58.485	58.05	58.485	2020400.0
2004-04-22 10:00:00	IWM	ETF	58.475	58.585	58.145	58.545	2097200.0
2004-04-22 11:00:00	IWM	ETF	58.53	59.125	58.53	59.075	3195000.0
2004-04-22 12:00:00	IWM	ETF	59.07	59.14	58.95	58.955	942000.0
2004-04-22 13:00:00	IWM	ETF	58.955	59.26	58.94	59.165	1592800.0
2004-04-22 14:00:00	IWM	ETF	59.155	59.205	58.95	59.175	926200.0
2004-04-22 15:00:00	IWM	ETF	59.165	59.195	58.88	59.04	2655600.0
2004-04-22 16:00:00	IWM	ETF	59.01	59.3	58.985	59.3	191200.0
2004-04-22 17:00:00	IWM	ETF	59.27	59.27	59.12	59.12	172200.0
2004-04-22 08:00:00	DIA	ETF	103.18	103.39	102.98	103.32	21500.0
2004-04-22 09:00:00	DIA	ETF	103.32	103.54	103.12	103.46	682600.0
2004-04-22 10:00:00	DIA	ETF	103.45	103.66	103.15	103.56	1255300.0
2004-04-22 11:00:00	DIA	ETF	103.55	104.58	103.55	104.47	2395400.0
2004-04-22 12:00:00	DIA	ETF	104.48	104.75	104.41	104.49	735200.0
2004-04-22 13:00:00	DIA	ETF	104.48	105.06	104.46	104.94	670700.0
2004-04-22 14:00:00	DIA	ETF	104.97	105.17	104.81	105.09	635900.0
2004-04-22 15:00:00	DIA	ETF	105.09	105.1	104.71	104.94	1241900.0
2004-04-22 16:00:00	DIA	ETF	104.95	105.02	104.67	104.89	467600.0
2004-04-22 17:00:00	DIA	ETF	104.96	104.96	104.89	104.89	400.0
2004-04-22 18:00:00	DIA	ETF	104.87	105.0	104.87	105.0	800.0
2004-04-22 09:00:00	TLT	ETF	84.25	84.36	84.18	84.3	33500.0
2004-04-22 10:00:00	TLT	ETF	84.29	84.4	84.22	84.26	147000.0
2004-04-22 11:00:00	TLT	ETF	84.26	84.34	84.14	84.22	111100.0
2004-04-22 12:00:00	TLT	ETF	84.28	84.46	84.28	84.44	80400.0
2004-04-22 13:00:00	TLT	ETF	84.43	84.47	84.34	84.34	75900.0

> showing 50 of 693 rows — these rows as CSV

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