PREVIEW / etf_1hour / 2004-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-29.parquet
  size:    28 KB
  rows:    787

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-29 08:00:00	SPY	ETF	118.97	119.06	118.78	118.86	136100.0
2004-11-29 09:00:00	SPY	ETF	118.87	119.01	118.64	118.64	5136900.0
2004-11-29 10:00:00	SPY	ETF	118.64	118.65	118.39	118.43	7418500.0
2004-11-29 11:00:00	SPY	ETF	118.44	118.5	117.48	117.71	11269000.0
2004-11-29 12:00:00	SPY	ETF	117.71	117.82	117.66	117.76	3579600.0
2004-11-29 13:00:00	SPY	ETF	117.76	118.23	117.74	118.13	5858300.0
2004-11-29 14:00:00	SPY	ETF	118.13	118.68	117.96	118.48	8030600.0
2004-11-29 15:00:00	SPY	ETF	118.48	118.59	118.07	118.13	9228400.0
2004-11-29 16:00:00	SPY	ETF	118.12	118.245	117.58	117.74	3132200.0
2004-11-29 17:00:00	SPY	ETF	117.74	117.85	117.74	117.82	163500.0
2004-11-29 18:00:00	SPY	ETF	117.81	118.16	117.79	117.8	190800.0
2004-11-29 19:00:00	SPY	ETF	117.78	117.78	117.78	117.78	2000.0
2004-11-29 08:00:00	QQQ	ETF	39.56	39.59	39.46	39.49	560500.0
2004-11-29 09:00:00	QQQ	ETF	39.5	39.64	39.44	39.462	12429400.0
2004-11-29 10:00:00	QQQ	ETF	39.462	39.52	39.35	39.36	14682600.0
2004-11-29 11:00:00	QQQ	ETF	39.365	39.43	38.97	39.08	18129900.0
2004-11-29 12:00:00	QQQ	ETF	39.08	39.13	39.06	39.08	6189300.0
2004-11-29 13:00:00	QQQ	ETF	39.08	39.28	39.08	39.22	9114100.0
2004-11-29 14:00:00	QQQ	ETF	39.221	39.411	39.14	39.35	12277500.0
2004-11-29 15:00:00	QQQ	ETF	39.35	39.42	39.21	39.3	17767300.0
2004-11-29 16:00:00	QQQ	ETF	39.3	39.31	39.151	39.151	2126200.0
2004-11-29 17:00:00	QQQ	ETF	39.153	39.2	39.153	39.18	256200.0
2004-11-29 18:00:00	QQQ	ETF	39.177	39.2	39.17	39.18	15400.0
2004-11-29 19:00:00	QQQ	ETF	39.18	39.18	39.18	39.18	5500.0
2004-11-29 09:00:00	IWM	ETF	63.225	63.375	63.14	63.14	1856000.0
2004-11-29 10:00:00	IWM	ETF	63.135	63.135	62.88	63.005	1226600.0
2004-11-29 11:00:00	IWM	ETF	63.0	63.06	62.475	62.7	3719400.0
2004-11-29 12:00:00	IWM	ETF	62.705	62.875	62.67	62.8	1784400.0
2004-11-29 13:00:00	IWM	ETF	62.79	63.435	62.79	63.34	2172800.0
2004-11-29 14:00:00	IWM	ETF	63.345	63.52	63.09	63.45	1746200.0
2004-11-29 15:00:00	IWM	ETF	63.45	63.54	63.125	63.125	2577400.0
2004-11-29 16:00:00	IWM	ETF	63.13	63.295	62.945	62.945	436600.0
2004-11-29 18:00:00	IWM	ETF	62.975	62.975	62.975	62.975	800.0
2004-11-29 19:00:00	IWM	ETF	62.96	62.96	62.96	62.96	3800.0
2004-11-29 08:00:00	DIA	ETF	105.48	105.52	105.37	105.37	9700.0
2004-11-29 09:00:00	DIA	ETF	105.31	105.51	105.26	105.26	839000.0
2004-11-29 10:00:00	DIA	ETF	105.25	105.25	104.91	104.94	950300.0
2004-11-29 11:00:00	DIA	ETF	104.94	105.01	104.02	104.23	2069200.0
2004-11-29 12:00:00	DIA	ETF	104.23	104.3	104.12	104.26	793500.0
2004-11-29 13:00:00	DIA	ETF	104.27	104.79	104.27	104.66	1073200.0
2004-11-29 14:00:00	DIA	ETF	104.67	105.17	104.5	105.04	737900.0
2004-11-29 15:00:00	DIA	ETF	105.03	105.11	104.59	104.69	1559400.0
2004-11-29 16:00:00	DIA	ETF	104.67	104.67	104.4	104.4	71900.0
2004-11-29 17:00:00	DIA	ETF	104.4	104.45	104.4	104.45	6100.0
2004-11-29 18:00:00	DIA	ETF	104.46	104.46	104.46	104.46	1100.0
2004-11-29 09:00:00	GLD	ETF	45.1	45.22	45.08	45.19	779700.0
2004-11-29 10:00:00	GLD	ETF	45.19	45.33	45.13	45.33	587700.0
2004-11-29 11:00:00	GLD	ETF	45.33	45.45	45.3	45.33	931900.0
2004-11-29 12:00:00	GLD	ETF	45.33	45.5	45.33	45.41	486700.0
2004-11-29 13:00:00	GLD	ETF	45.42	45.45	45.36	45.44	371700.0

> showing 50 of 787 rows — these rows as CSV

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