PREVIEW / etf_1hour / 2004-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-07.parquet
  size:    26 KB
  rows:    699

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-05-07 08:00:00	SPY	ETF	111.61	112.02	110.96	111.03	1343300.0
2004-05-07 09:00:00	SPY	ETF	111.03	112.23	111.0	111.61	8500900.0
2004-05-07 10:00:00	SPY	ETF	111.57	111.86	111.1	111.6	8671200.0
2004-05-07 11:00:00	SPY	ETF	111.56	111.7	111.33	111.47	3500300.0
2004-05-07 12:00:00	SPY	ETF	111.46	111.63	111.26	111.51	2423500.0
2004-05-07 13:00:00	SPY	ETF	111.51	111.66	110.78	110.8	4967300.0
2004-05-07 14:00:00	SPY	ETF	110.93	111.05	110.38	110.72	12782300.0
2004-05-07 15:00:00	SPY	ETF	110.73	110.85	110.26	110.3	9613600.0
2004-05-07 16:00:00	SPY	ETF	110.29	111.8339	109.82	109.84	2577800.0
2004-05-07 17:00:00	SPY	ETF	109.86	109.98	109.84	109.98	48200.0
2004-05-07 18:00:00	SPY	ETF	109.96	110.11	109.96	110.11	4200.0
2004-05-07 19:00:00	SPY	ETF	110.04	110.04	109.88	109.97	1600.0
2004-05-07 08:00:00	QQQ	ETF	35.17	35.33	34.95	34.96	1950600.0
2004-05-07 09:00:00	QQQ	ETF	34.96	35.64	34.95	35.37	23928400.0
2004-05-07 10:00:00	QQQ	ETF	35.37	35.59	35.14	35.5	26266900.0
2004-05-07 11:00:00	QQQ	ETF	35.5	35.58	35.41	35.52	9248100.0
2004-05-07 12:00:00	QQQ	ETF	35.51	35.59	35.41	35.53	8861400.0
2004-05-07 13:00:00	QQQ	ETF	35.53	35.6	35.26	35.31	10047000.0
2004-05-07 14:00:00	QQQ	ETF	35.31	35.41	35.14	35.25	21067600.0
2004-05-07 15:00:00	QQQ	ETF	35.25	35.32	34.96	34.98	25905400.0
2004-05-07 16:00:00	QQQ	ETF	34.99	35.05	34.91	34.98	5163900.0
2004-05-07 17:00:00	QQQ	ETF	34.98	35.01	34.93	34.94	104900.0
2004-05-07 18:00:00	QQQ	ETF	34.97	34.97	34.94	34.95	16200.0
2004-05-07 19:00:00	QQQ	ETF	34.96	35.0	34.95	35.0	9400.0
2004-05-07 08:00:00	IWM	ETF	55.885	55.895	55.55	55.55	154000.0
2004-05-07 09:00:00	IWM	ETF	55.64	56.58	55.53	56.07	2680600.0
2004-05-07 10:00:00	IWM	ETF	56.05	56.22	55.62	55.925	3129400.0
2004-05-07 11:00:00	IWM	ETF	55.945	55.98	55.68	55.77	934000.0
2004-05-07 12:00:00	IWM	ETF	55.77	55.79	55.6	55.725	2154800.0
2004-05-07 13:00:00	IWM	ETF	55.7	55.75	55.05	55.09	1231200.0
2004-05-07 14:00:00	IWM	ETF	55.08	55.215	54.76	55.0	3849000.0
2004-05-07 15:00:00	IWM	ETF	55.03	55.125	54.5	54.555	3571600.0
2004-05-07 16:00:00	IWM	ETF	54.585	54.695	54.425	54.695	485000.0
2004-05-07 17:00:00	IWM	ETF	54.5	54.5	54.45	54.45	600.0
2004-05-07 18:00:00	IWM	ETF	54.505	54.505	54.505	54.505	2000.0
2004-05-07 08:00:00	DIA	ETF	102.42	102.55	101.96	101.96	65900.0
2004-05-07 09:00:00	DIA	ETF	101.98	103.03	101.95	102.55	973200.0
2004-05-07 10:00:00	DIA	ETF	102.47	102.77	102.08	102.58	1137700.0
2004-05-07 11:00:00	DIA	ETF	102.58	102.62	102.3	102.38	391700.0
2004-05-07 12:00:00	DIA	ETF	102.43	102.58	102.27	102.44	332700.0
2004-05-07 13:00:00	DIA	ETF	102.47	102.56	101.91	102.02	842800.0
2004-05-07 14:00:00	DIA	ETF	102.01	102.1	101.48	101.75	1973500.0
2004-05-07 15:00:00	DIA	ETF	101.8	101.87	101.36	101.38	1371400.0
2004-05-07 16:00:00	DIA	ETF	101.4	101.46	101.06	101.1	311400.0
2004-05-07 17:00:00	DIA	ETF	101.11	101.15	101.11	101.15	2100.0
2004-05-07 18:00:00	DIA	ETF	101.15	101.25	101.12	101.25	3100.0
2004-05-07 08:00:00	TLT	ETF	82.64	82.64	81.3	81.48	63100.0
2004-05-07 09:00:00	TLT	ETF	81.54	81.55	81.27	81.48	362600.0
2004-05-07 10:00:00	TLT	ETF	81.48	81.5	81.32	81.42	258600.0
2004-05-07 11:00:00	TLT	ETF	81.42	81.42	81.3	81.38	291100.0

> showing 50 of 699 rows — these rows as CSV

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