PREVIEW / etf_1hour / 2004-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-05.parquet
  size:    25 KB
  rows:    728

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-05 08:00:00	SPY	ETF	114.43	114.55	114.43	114.46	36600.0
2004-04-05 09:00:00	SPY	ETF	114.41	114.74	114.41	114.58	3906500.0
2004-04-05 10:00:00	SPY	ETF	114.59	114.88	114.47	114.48	9169600.0
2004-04-05 11:00:00	SPY	ETF	114.48	114.63	114.44	114.57	2478400.0
2004-04-05 12:00:00	SPY	ETF	114.56	114.81	114.51	114.73	3170000.0
2004-04-05 13:00:00	SPY	ETF	114.73	114.8	114.6	114.72	1364600.0
2004-04-05 14:00:00	SPY	ETF	114.72	114.83	114.64	114.77	2009200.0
2004-04-05 15:00:00	SPY	ETF	114.77	115.37	114.74	115.34	5604500.0
2004-04-05 16:00:00	SPY	ETF	115.33	115.38	115.2	115.26	1419500.0
2004-04-05 17:00:00	SPY	ETF	115.24	115.25	115.15	115.2	3800.0
2004-04-05 18:00:00	SPY	ETF	115.16	115.17	115.15	115.17	27900.0
2004-04-05 19:00:00	SPY	ETF	115.21	115.21	115.21	115.21	300.0
2004-04-05 08:00:00	QQQ	ETF	37.04	37.12	36.99	36.99	181700.0
2004-04-05 09:00:00	QQQ	ETF	36.98	37.14	36.97	37.1	9055200.0
2004-04-05 10:00:00	QQQ	ETF	37.1	37.23	37.01	37.048	14830700.0
2004-04-05 11:00:00	QQQ	ETF	37.05	37.12	37.02	37.096	5227700.0
2004-04-05 12:00:00	QQQ	ETF	37.09	37.2	37.05	37.15	4804100.0
2004-04-05 13:00:00	QQQ	ETF	37.158	37.19	37.12	37.16	3226000.0
2004-04-05 14:00:00	QQQ	ETF	37.15	37.24	37.117	37.2	7337200.0
2004-04-05 15:00:00	QQQ	ETF	37.202	37.48	37.18	37.46	17338500.0
2004-04-05 16:00:00	QQQ	ETF	37.46	37.5	37.1669	37.43	3298900.0
2004-04-05 17:00:00	QQQ	ETF	37.433	37.445	37.36	37.4	82800.0
2004-04-05 18:00:00	QQQ	ETF	37.41	37.43	37.387	37.39	32300.0
2004-04-05 19:00:00	QQQ	ETF	37.42	37.44	37.4	37.43	11200.0
2004-04-05 09:00:00	IWM	ETF	60.165	60.34	60.105	60.2	853800.0
2004-04-05 10:00:00	IWM	ETF	60.195	60.39	60.05	60.06	1637800.0
2004-04-05 11:00:00	IWM	ETF	60.065	60.085	59.955	60.005	540200.0
2004-04-05 12:00:00	IWM	ETF	59.975	60.135	59.9	60.085	336200.0
2004-04-05 13:00:00	IWM	ETF	60.065	60.15	59.985	60.075	270800.0
2004-04-05 14:00:00	IWM	ETF	60.07	60.15	59.995	60.03	832600.0
2004-04-05 15:00:00	IWM	ETF	60.035	60.425	60.03	60.39	2001200.0
2004-04-05 16:00:00	IWM	ETF	60.395	60.795	60.25	60.395	703200.0
2004-04-05 17:00:00	IWM	ETF	60.425	60.43	60.425	60.43	2600.0
2004-04-05 18:00:00	IWM	ETF	60.365	60.43	60.36	60.43	2200.0
2004-04-05 08:00:00	DIA	ETF	104.95	104.96	104.86	104.86	2900.0
2004-04-05 09:00:00	DIA	ETF	104.81	105.08	104.77	104.89	510500.0
2004-04-05 10:00:00	DIA	ETF	104.9	105.28	104.88	104.91	629700.0
2004-04-05 11:00:00	DIA	ETF	104.9	105.11	104.87	105.02	340700.0
2004-04-05 12:00:00	DIA	ETF	105.02	105.29	104.99	105.24	312000.0
2004-04-05 13:00:00	DIA	ETF	105.25	105.3	105.15	105.22	217700.0
2004-04-05 14:00:00	DIA	ETF	105.24	105.33	105.19	105.25	275700.0
2004-04-05 15:00:00	DIA	ETF	105.27	105.809	105.25	105.72	992700.0
2004-04-05 16:00:00	DIA	ETF	105.7	105.74	105.62	105.63	82700.0
2004-04-05 17:00:00	DIA	ETF	105.62	105.65	105.59	105.61	1800.0
2004-04-05 18:00:00	DIA	ETF	105.66	105.67	105.6	105.6	600.0
2004-04-05 08:00:00	TLT	ETF	86.36	86.44	86.36	86.44	1000.0
2004-04-05 09:00:00	TLT	ETF	86.44	86.44	86.16	86.18	497200.0
2004-04-05 10:00:00	TLT	ETF	86.18	86.27	85.96	86.19	231600.0
2004-04-05 11:00:00	TLT	ETF	86.18	86.3	86.17	86.18	103700.0
2004-04-05 12:00:00	TLT	ETF	86.2	86.2	86.0	86.03	144400.0

> showing 50 of 728 rows — these rows as CSV

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