PREVIEW / etf_1hour / 2004-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-22.parquet
  size:    25 KB
  rows:    709

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-03-22 08:00:00	SPY	ETF	110.16	110.41	110.16	110.41	75900.0
2004-03-22 09:00:00	SPY	ETF	110.42	110.57	109.91	109.93	6401100.0
2004-03-22 10:00:00	SPY	ETF	109.94	110.07	109.4	110.03	10976500.0
2004-03-22 11:00:00	SPY	ETF	110.02	110.34	109.88	110.05	7296600.0
2004-03-22 12:00:00	SPY	ETF	110.05	110.09	109.72	110.0	3371200.0
2004-03-22 13:00:00	SPY	ETF	110.01	110.01	109.5	109.65	4521600.0
2004-03-22 14:00:00	SPY	ETF	109.6	109.82	109.1	109.52	10863900.0
2004-03-22 15:00:00	SPY	ETF	109.51	109.87	109.38	109.75	6159300.0
2004-03-22 16:00:00	SPY	ETF	109.74	109.77	109.6	109.7	3899100.0
2004-03-22 17:00:00	SPY	ETF	109.68	109.72	109.62	109.68	52000.0
2004-03-22 18:00:00	SPY	ETF	109.68	109.68	109.68	109.68	500.0
2004-03-22 19:00:00	SPY	ETF	109.65	109.65	109.6	109.6	2400.0
2004-03-22 08:00:00	QQQ	ETF	34.36	34.5	34.32	34.47	674500.0
2004-03-22 09:00:00	QQQ	ETF	34.48	34.55	34.31	34.33	18962600.0
2004-03-22 10:00:00	QQQ	ETF	34.33	34.4	34.17	34.36	22466700.0
2004-03-22 11:00:00	QQQ	ETF	34.382	34.47	34.28	34.37	14643400.0
2004-03-22 12:00:00	QQQ	ETF	34.342	34.37	34.19	34.308	5571600.0
2004-03-22 13:00:00	QQQ	ETF	34.3	34.32	34.08	34.17	10518400.0
2004-03-22 14:00:00	QQQ	ETF	34.17	34.29	34.03	34.15	20821500.0
2004-03-22 15:00:00	QQQ	ETF	34.15	34.36	34.11	34.343	22123600.0
2004-03-22 16:00:00	QQQ	ETF	34.344	34.35	34.25	34.32	2993600.0
2004-03-22 17:00:00	QQQ	ETF	34.32	34.36	34.29	34.32	1083000.0
2004-03-22 18:00:00	QQQ	ETF	34.3	34.32	34.3	34.3	29800.0
2004-03-22 19:00:00	QQQ	ETF	34.32	34.32	34.26	34.26	30200.0
2004-03-22 08:00:00	IWM	ETF	56.25	56.69	56.125	56.345	7200.0
2004-03-22 09:00:00	IWM	ETF	56.305	56.54	55.76	55.795	2564400.0
2004-03-22 10:00:00	IWM	ETF	55.79	56.16	55.655	56.14	4556600.0
2004-03-22 11:00:00	IWM	ETF	56.155	56.28	55.925	56.05	2262800.0
2004-03-22 12:00:00	IWM	ETF	56.025	56.055	55.88	55.995	1039600.0
2004-03-22 13:00:00	IWM	ETF	55.995	56.015	55.72	55.815	816200.0
2004-03-22 14:00:00	IWM	ETF	55.765	56.02	55.55	55.755	2713000.0
2004-03-22 15:00:00	IWM	ETF	55.75	55.96	55.635	55.81	2110800.0
2004-03-22 16:00:00	IWM	ETF	55.8	55.8	55.69	55.73	381400.0
2004-03-22 17:00:00	IWM	ETF	55.73	55.73	55.73	55.73	4600.0
2004-03-22 18:00:00	IWM	ETF	55.725	55.725	55.725	55.725	200.0
2004-03-22 19:00:00	IWM	ETF	55.735	55.75	55.735	55.75	4200.0
2004-03-22 08:00:00	DIA	ETF	101.09	101.33	101.09	101.33	17600.0
2004-03-22 09:00:00	DIA	ETF	101.26	101.32	100.76	100.8	843500.0
2004-03-22 10:00:00	DIA	ETF	100.79	100.99	100.45	100.96	1361500.0
2004-03-22 11:00:00	DIA	ETF	100.95	101.29	100.89	101.03	503300.0
2004-03-22 12:00:00	DIA	ETF	100.98	101.01	100.75	100.95	688600.0
2004-03-22 13:00:00	DIA	ETF	100.94	100.95	100.52	100.59	1256900.0
2004-03-22 14:00:00	DIA	ETF	100.58	100.8	100.19	100.58	1507000.0
2004-03-22 15:00:00	DIA	ETF	100.59	100.92	100.46	100.78	1427200.0
2004-03-22 16:00:00	DIA	ETF	100.8	100.8	100.63	100.71	83300.0
2004-03-22 17:00:00	DIA	ETF	100.7	100.74	100.69	100.74	4000.0
2004-03-22 19:00:00	DIA	ETF	100.7	100.7	100.69	100.69	5000.0
2004-03-22 09:00:00	TLT	ETF	90.59	90.75	90.59	90.75	157100.0
2004-03-22 10:00:00	TLT	ETF	90.75	90.86	90.69	90.71	234900.0
2004-03-22 11:00:00	TLT	ETF	90.7	90.75	90.6	90.7	27200.0

> showing 50 of 709 rows — these rows as CSV

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