PREVIEW / etf_1hour / 2004-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-06.parquet
  size:    25 KB
  rows:    697

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-07-06 08:00:00	SPY	ETF	112.33	112.37	112.18	112.36	146900.0
2004-07-06 09:00:00	SPY	ETF	112.35	112.45	112.16	112.37	4963800.0
2004-07-06 10:00:00	SPY	ETF	112.37	112.43	112.17	112.24	5277400.0
2004-07-06 11:00:00	SPY	ETF	112.24	112.29	111.72	111.84	7600900.0
2004-07-06 12:00:00	SPY	ETF	111.84	112.0	111.73	111.9	3225700.0
2004-07-06 13:00:00	SPY	ETF	111.9	111.98	111.73	111.74	2021000.0
2004-07-06 14:00:00	SPY	ETF	111.75	111.92	111.63	111.82	5138200.0
2004-07-06 15:00:00	SPY	ETF	111.82	112.29	111.79	111.96	5696600.0
2004-07-06 16:00:00	SPY	ETF	111.96	111.99	111.82	111.88	1442500.0
2004-07-06 17:00:00	SPY	ETF	111.92	111.94	111.92	111.92	12700.0
2004-07-06 18:00:00	SPY	ETF	111.91	111.94	111.89	111.94	3000.0
2004-07-06 19:00:00	SPY	ETF	111.9	111.9	111.9	111.9	100.0
2004-07-06 08:00:00	QQQ	ETF	36.66	36.66	36.56	36.6	192400.0
2004-07-06 09:00:00	QQQ	ETF	36.59	36.61	36.31	36.4	19525500.0
2004-07-06 10:00:00	QQQ	ETF	36.4	36.41	36.239	36.25	18889100.0
2004-07-06 11:00:00	QQQ	ETF	36.25	36.27	35.91	36.0	27850200.0
2004-07-06 12:00:00	QQQ	ETF	36.0	36.08	35.96	36.05	10761400.0
2004-07-06 13:00:00	QQQ	ETF	36.06	36.08	35.92	35.93	6970900.0
2004-07-06 14:00:00	QQQ	ETF	35.938	36.0	35.83	35.96	14513300.0
2004-07-06 15:00:00	QQQ	ETF	35.96	36.14	35.94	35.99	21585800.0
2004-07-06 16:00:00	QQQ	ETF	36.01	36.07	35.94	36.04	3865700.0
2004-07-06 17:00:00	QQQ	ETF	36.02	36.05	36.0	36.029	267500.0
2004-07-06 18:00:00	QQQ	ETF	36.029	36.04	36.015	36.03	13200.0
2004-07-06 19:00:00	QQQ	ETF	36.05	36.07	36.04	36.07	17400.0
2004-07-06 08:00:00	IWM	ETF	57.65	57.65	57.62	57.62	4000.0
2004-07-06 09:00:00	IWM	ETF	57.735	57.78	57.435	57.505	2709800.0
2004-07-06 10:00:00	IWM	ETF	57.505	57.515	57.2	57.23	2725400.0
2004-07-06 11:00:00	IWM	ETF	57.24	57.245	56.9	56.925	1647400.0
2004-07-06 12:00:00	IWM	ETF	56.915	57.115	56.905	57.065	1175200.0
2004-07-06 13:00:00	IWM	ETF	57.09	57.195	57.02	57.025	713000.0
2004-07-06 14:00:00	IWM	ETF	57.02	57.11	56.875	57.07	966200.0
2004-07-06 15:00:00	IWM	ETF	57.07	57.335	56.875	57.09	2253200.0
2004-07-06 16:00:00	IWM	ETF	57.095	57.15	56.965	57.05	372600.0
2004-07-06 17:00:00	IWM	ETF	57.045	57.045	57.035	57.035	4000.0
2004-07-06 08:00:00	DIA	ETF	102.65	102.67	102.5	102.6	20100.0
2004-07-06 09:00:00	DIA	ETF	102.63	102.76	102.55	102.74	723900.0
2004-07-06 10:00:00	DIA	ETF	102.75	102.91	102.6	102.74	526400.0
2004-07-06 11:00:00	DIA	ETF	102.72	102.75	102.19	102.29	792900.0
2004-07-06 12:00:00	DIA	ETF	102.23	102.46	102.17	102.36	586100.0
2004-07-06 13:00:00	DIA	ETF	102.37	102.41	102.2	102.24	187300.0
2004-07-06 14:00:00	DIA	ETF	102.24	102.41	102.06	102.3	1212800.0
2004-07-06 15:00:00	DIA	ETF	102.3	102.63	102.25	102.4	1384500.0
2004-07-06 16:00:00	DIA	ETF	102.38	102.43	102.27	102.35	120400.0
2004-07-06 18:00:00	DIA	ETF	102.4	102.4	102.4	102.4	200.0
2004-07-06 09:00:00	TLT	ETF	84.57	84.58	84.47	84.47	28300.0
2004-07-06 10:00:00	TLT	ETF	84.52	84.55	84.25	84.25	110400.0
2004-07-06 11:00:00	TLT	ETF	84.27	84.3	84.18	84.2	84000.0
2004-07-06 12:00:00	TLT	ETF	84.2	84.28	84.19	84.19	40000.0
2004-07-06 13:00:00	TLT	ETF	84.17	84.28	84.17	84.26	10300.0
2004-07-06 14:00:00	TLT	ETF	84.25	84.27	84.14	84.21	20000.0

> showing 50 of 697 rows — these rows as CSV

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