PREVIEW / etf_1hour / 2004-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-24.parquet
  size:    24 KB
  rows:    670

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-24 08:00:00	SPY	ETF	109.53	109.66	109.34	109.54	129900.0
2004-03-24 09:00:00	SPY	ETF	109.56	109.95	109.43	109.7	5461500.0
2004-03-24 10:00:00	SPY	ETF	109.7	109.83	109.19	109.35	7109400.0
2004-03-24 11:00:00	SPY	ETF	109.33	109.77	108.85	109.75	10629200.0
2004-03-24 12:00:00	SPY	ETF	109.74	110.14	109.72	109.92	5025700.0
2004-03-24 13:00:00	SPY	ETF	109.92	109.96	109.62	109.85	3707900.0
2004-03-24 14:00:00	SPY	ETF	109.85	109.88	109.4	109.51	3772100.0
2004-03-24 15:00:00	SPY	ETF	109.52	109.56	109.0	109.41	6460100.0
2004-03-24 16:00:00	SPY	ETF	109.41	109.66	109.36	109.57	1645500.0
2004-03-24 17:00:00	SPY	ETF	109.51	109.54	109.39	109.47	243700.0
2004-03-24 18:00:00	SPY	ETF	109.48	109.55	109.48	109.52	7100.0
2004-03-24 19:00:00	SPY	ETF	109.55	109.57	109.55	109.57	500.0
2004-03-24 08:00:00	QQQ	ETF	34.07	34.13	34.02	34.12	324100.0
2004-03-24 09:00:00	QQQ	ETF	34.12	34.296	34.09	34.25	11141500.0
2004-03-24 10:00:00	QQQ	ETF	34.247	34.34	34.078	34.176	19386000.0
2004-03-24 11:00:00	QQQ	ETF	34.17	34.39	34.01	34.38	17789900.0
2004-03-24 12:00:00	QQQ	ETF	34.38	34.63	34.37	34.528	14985600.0
2004-03-24 13:00:00	QQQ	ETF	34.53	34.61	34.41	34.56	9838300.0
2004-03-24 14:00:00	QQQ	ETF	34.56	34.59	34.38	34.44	8612800.0
2004-03-24 15:00:00	QQQ	ETF	34.43	34.48	34.22	34.41	16182200.0
2004-03-24 16:00:00	QQQ	ETF	34.41	34.45	34.36	34.43	2958700.0
2004-03-24 17:00:00	QQQ	ETF	34.42	34.42	34.32	34.35	1264500.0
2004-03-24 18:00:00	QQQ	ETF	34.35	34.38	34.337	34.36	65200.0
2004-03-24 19:00:00	QQQ	ETF	34.36	34.38	34.36	34.38	30200.0
2004-03-24 08:00:00	IWM	ETF	56.0	56.02	55.89	55.9	30600.0
2004-03-24 09:00:00	IWM	ETF	56.09	56.155	55.725	55.97	1361000.0
2004-03-24 10:00:00	IWM	ETF	55.96	56.02	55.64	55.76	1590400.0
2004-03-24 11:00:00	IWM	ETF	55.735	55.905	55.36	55.835	2744400.0
2004-03-24 12:00:00	IWM	ETF	55.83	56.18	55.83	56.025	1754600.0
2004-03-24 13:00:00	IWM	ETF	56.035	56.085	55.885	56.05	989400.0
2004-03-24 14:00:00	IWM	ETF	56.01	56.05	55.81	55.895	722400.0
2004-03-24 15:00:00	IWM	ETF	55.87	55.895	55.58	55.715	1461800.0
2004-03-24 16:00:00	IWM	ETF	55.72	55.775	55.65	55.775	363200.0
2004-03-24 17:00:00	IWM	ETF	55.725	55.725	55.7	55.71	5400.0
2004-03-24 08:00:00	DIA	ETF	100.65	100.74	100.57	100.67	33900.0
2004-03-24 09:00:00	DIA	ETF	100.73	101.02	100.55	100.8	1131800.0
2004-03-24 10:00:00	DIA	ETF	100.8	100.91	100.35	100.49	1501700.0
2004-03-24 11:00:00	DIA	ETF	100.47	100.91	100.12	100.88	1371200.0
2004-03-24 12:00:00	DIA	ETF	100.89	101.21	100.86	101.01	731600.0
2004-03-24 13:00:00	DIA	ETF	101.01	101.04	100.76	100.95	510300.0
2004-03-24 14:00:00	DIA	ETF	100.92	100.99	100.6	100.65	521200.0
2004-03-24 15:00:00	DIA	ETF	100.65	100.79	100.25	100.62	1521200.0
2004-03-24 16:00:00	DIA	ETF	100.64	100.85	100.6	100.79	123100.0
2004-03-24 17:00:00	DIA	ETF	100.74	100.74	100.65	100.65	26100.0
2004-03-24 09:00:00	TLT	ETF	91.22	91.22	91.06	91.06	52300.0
2004-03-24 10:00:00	TLT	ETF	91.16	91.17	91.02	91.11	18600.0
2004-03-24 11:00:00	TLT	ETF	91.11	91.23	91.07	91.07	63300.0
2004-03-24 12:00:00	TLT	ETF	91.07	91.09	90.97	90.97	24300.0
2004-03-24 13:00:00	TLT	ETF	91.0	91.03	90.93	91.0	84700.0
2004-03-24 14:00:00	TLT	ETF	91.06	91.08	90.99	91.07	36300.0

> showing 50 of 670 rows — these rows as CSV

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