PREVIEW / etf_1hour / 2004-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-08.parquet
  size:    25 KB
  rows:    684

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-08 08:00:00	SPY	ETF	115.29	115.4	115.19	115.31	93100.0
2004-04-08 09:00:00	SPY	ETF	115.31	115.43	114.99	115.01	4623900.0
2004-04-08 10:00:00	SPY	ETF	115.02	115.1	114.58	114.75	6562900.0
2004-04-08 11:00:00	SPY	ETF	114.76	114.79	114.39	114.69	4409400.0
2004-04-08 12:00:00	SPY	ETF	114.7	114.8	114.51	114.54	2744300.0
2004-04-08 13:00:00	SPY	ETF	114.54	114.76	114.46	114.51	1922000.0
2004-04-08 14:00:00	SPY	ETF	114.49	114.54	113.91	114.1	10581100.0
2004-04-08 15:00:00	SPY	ETF	114.1	114.35	113.74	114.23	11115200.0
2004-04-08 16:00:00	SPY	ETF	114.25	114.42	114.14	114.42	1551000.0
2004-04-08 17:00:00	SPY	ETF	114.35	114.39	114.31	114.36	2000.0
2004-04-08 19:00:00	SPY	ETF	114.36	114.36	114.31	114.31	900.0
2004-04-08 08:00:00	QQQ	ETF	37.32	37.38	37.29	37.34	257400.0
2004-04-08 09:00:00	QQQ	ETF	37.35	37.42	37.18	37.2	11323100.0
2004-04-08 10:00:00	QQQ	ETF	37.201	37.22	37.02	37.136	12882100.0
2004-04-08 11:00:00	QQQ	ETF	37.14	37.15	36.93	37.07	12533000.0
2004-04-08 12:00:00	QQQ	ETF	37.07	37.17	37.03	37.051	7731600.0
2004-04-08 13:00:00	QQQ	ETF	37.05	37.14	37.03	37.04	3558400.0
2004-04-08 14:00:00	QQQ	ETF	37.041	37.06	36.81	36.89	11464500.0
2004-04-08 15:00:00	QQQ	ETF	36.89	37.021	36.74	36.99	14225700.0
2004-04-08 16:00:00	QQQ	ETF	36.98	37.0	36.9	36.94	1697000.0
2004-04-08 17:00:00	QQQ	ETF	36.95	36.97	36.9	36.96	103000.0
2004-04-08 18:00:00	QQQ	ETF	36.95	36.99	36.91	36.91	37600.0
2004-04-08 19:00:00	QQQ	ETF	36.91	36.91	36.85	36.9	6800.0
2004-04-08 08:00:00	IWM	ETF	60.55	60.615	60.55	60.595	10400.0
2004-04-08 09:00:00	IWM	ETF	60.55	60.575	60.105	60.14	1178600.0
2004-04-08 10:00:00	IWM	ETF	60.145	60.225	59.905	60.14	1660600.0
2004-04-08 11:00:00	IWM	ETF	60.13	60.15	59.895	60.05	503400.0
2004-04-08 12:00:00	IWM	ETF	60.055	60.105	59.975	59.975	281000.0
2004-04-08 13:00:00	IWM	ETF	59.985	60.095	59.875	59.92	1187800.0
2004-04-08 14:00:00	IWM	ETF	59.905	59.91	59.58	59.645	1528200.0
2004-04-08 15:00:00	IWM	ETF	59.73	59.75	59.47	59.575	1709200.0
2004-04-08 16:00:00	IWM	ETF	59.585	59.695	59.55	59.55	105200.0
2004-04-08 17:00:00	IWM	ETF	59.57	59.57	59.57	59.57	335200.0
2004-04-08 08:00:00	DIA	ETF	105.72	105.95	105.72	105.87	5600.0
2004-04-08 09:00:00	DIA	ETF	105.86	105.95	105.5	105.53	539600.0
2004-04-08 10:00:00	DIA	ETF	105.53	105.56	105.07	105.18	1115000.0
2004-04-08 11:00:00	DIA	ETF	105.23	105.23	104.9	105.09	827300.0
2004-04-08 12:00:00	DIA	ETF	105.1	105.23	104.9	104.91	490000.0
2004-04-08 13:00:00	DIA	ETF	104.91	105.09	104.86	104.9	271100.0
2004-04-08 14:00:00	DIA	ETF	104.89	104.94	104.31	104.46	754400.0
2004-04-08 15:00:00	DIA	ETF	104.48	104.74	104.1	104.56	979700.0
2004-04-08 16:00:00	DIA	ETF	104.55	104.69	104.54	104.64	53000.0
2004-04-08 19:00:00	DIA	ETF	104.63	104.63	104.53	104.53	800.0
2004-04-08 09:00:00	TLT	ETF	86.17	86.17	86.05	86.11	114300.0
2004-04-08 10:00:00	TLT	ETF	86.15	86.29	86.11	86.17	248600.0
2004-04-08 11:00:00	TLT	ETF	86.2	86.42	86.2	86.36	133800.0
2004-04-08 12:00:00	TLT	ETF	86.36	86.36	86.12	86.18	21800.0
2004-04-08 13:00:00	TLT	ETF	86.11	86.17	86.05	86.15	212000.0
2004-04-08 14:00:00	TLT	ETF	86.14	86.15	85.98	86.1	45800.0
2004-04-08 15:00:00	TLT	ETF	86.1	86.14	86.0	86.02	112300.0

> showing 50 of 684 rows — these rows as CSV

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