PREVIEW / etf_1hour / 2004-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-09.parquet
  size:    24 KB
  rows:    667

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-09 08:00:00	SPY	ETF	111.78	111.8	111.72	111.78	20200.0
2004-07-09 09:00:00	SPY	ETF	111.78	111.94	111.65	111.72	5381300.0
2004-07-09 10:00:00	SPY	ETF	111.72	111.87	111.48	111.54	6124600.0
2004-07-09 11:00:00	SPY	ETF	111.54	111.82	111.48	111.68	3026300.0
2004-07-09 12:00:00	SPY	ETF	111.67	111.69	111.39	111.59	3996300.0
2004-07-09 13:00:00	SPY	ETF	111.59	111.73	111.51	111.64	1114900.0
2004-07-09 14:00:00	SPY	ETF	111.64	111.68	111.45	111.51	1718600.0
2004-07-09 15:00:00	SPY	ETF	111.5	111.76	111.38	111.64	3595800.0
2004-07-09 16:00:00	SPY	ETF	111.61	111.84	111.55	111.8	959000.0
2004-07-09 17:00:00	SPY	ETF	111.8	111.82	111.71	111.71	64800.0
2004-07-09 18:00:00	SPY	ETF	111.75	111.78	111.75	111.78	700.0
2004-07-09 19:00:00	SPY	ETF	111.65	111.65	111.62	111.62	1000.0
2004-07-09 08:00:00	QQQ	ETF	35.84	35.9	35.83	35.89	316800.0
2004-07-09 09:00:00	QQQ	ETF	35.88	36.0	35.82	35.88	17562500.0
2004-07-09 10:00:00	QQQ	ETF	35.88	36.037	35.75	35.778	18670400.0
2004-07-09 11:00:00	QQQ	ETF	35.778	35.91	35.73	35.79	9401200.0
2004-07-09 12:00:00	QQQ	ETF	35.79	35.81	35.67	35.762	9210500.0
2004-07-09 13:00:00	QQQ	ETF	35.76	35.8	35.7	35.77	4946500.0
2004-07-09 14:00:00	QQQ	ETF	35.78	35.78	35.63	35.7	6400400.0
2004-07-09 15:00:00	QQQ	ETF	35.693	35.89	35.63	35.79	15338600.0
2004-07-09 16:00:00	QQQ	ETF	35.79	35.82	35.74	35.79	1936500.0
2004-07-09 17:00:00	QQQ	ETF	35.761	35.79	35.761	35.77	27600.0
2004-07-09 18:00:00	QQQ	ETF	35.77	35.8	35.76	35.8	15300.0
2004-07-09 19:00:00	QQQ	ETF	35.78	35.78	35.76	35.76	2900.0
2004-07-09 08:00:00	IWM	ETF	56.1	56.17	56.1	56.14	3600.0
2004-07-09 09:00:00	IWM	ETF	56.15	56.355	56.025	56.125	2226800.0
2004-07-09 10:00:00	IWM	ETF	56.12	56.19	55.925	56.04	1820400.0
2004-07-09 11:00:00	IWM	ETF	56.015	56.15	56.0	56.07	998600.0
2004-07-09 12:00:00	IWM	ETF	56.04	56.27	56.0	56.225	839200.0
2004-07-09 13:00:00	IWM	ETF	56.22	56.315	56.185	56.255	855200.0
2004-07-09 14:00:00	IWM	ETF	56.255	56.27	56.12	56.125	928600.0
2004-07-09 15:00:00	IWM	ETF	56.125	56.285	56.1	56.185	872000.0
2004-07-09 16:00:00	IWM	ETF	56.2	56.325	56.19	56.325	243400.0
2004-07-09 17:00:00	IWM	ETF	56.2	56.325	56.2	56.325	8600.0
2004-07-09 08:00:00	DIA	ETF	102.38	102.38	102.3	102.33	4200.0
2004-07-09 09:00:00	DIA	ETF	102.34	102.62	102.26	102.42	811600.0
2004-07-09 10:00:00	DIA	ETF	102.4215	102.54	102.26	102.32	935400.0
2004-07-09 11:00:00	DIA	ETF	102.27	102.54	102.27	102.46	363000.0
2004-07-09 12:00:00	DIA	ETF	102.45	102.45	102.17	102.36	264800.0
2004-07-09 13:00:00	DIA	ETF	102.33	102.42	102.26	102.35	382800.0
2004-07-09 14:00:00	DIA	ETF	102.35	102.36	102.18	102.23	257800.0
2004-07-09 15:00:00	DIA	ETF	102.23	102.4	102.1	102.34	356800.0
2004-07-09 16:00:00	DIA	ETF	102.34	102.45	102.3	102.45	27400.0
2004-07-09 09:00:00	TLT	ETF	84.25	84.33	84.16	84.16	9100.0
2004-07-09 10:00:00	TLT	ETF	84.22	84.22	84.09	84.19	97600.0
2004-07-09 11:00:00	TLT	ETF	84.29	84.42	84.22	84.36	12800.0
2004-07-09 12:00:00	TLT	ETF	84.38	84.42	84.36	84.41	3800.0
2004-07-09 13:00:00	TLT	ETF	84.31	84.4	84.31	84.4	535700.0
2004-07-09 14:00:00	TLT	ETF	84.33	84.4	84.32	84.33	224500.0
2004-07-09 15:00:00	TLT	ETF	84.31	84.38	84.28	84.38	1217100.0

> showing 50 of 667 rows — these rows as CSV

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