PREVIEW / etf_1hour / 2004-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-06.parquet
  size:    25 KB
  rows:    693

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-02-06 08:00:00	SPY	ETF	113.36	113.66	112.93	113.36	1216200.0
2004-02-06 09:00:00	SPY	ETF	113.33	113.62	113.2	113.38	5152300.0
2004-02-06 10:00:00	SPY	ETF	113.37	114.47	113.34	114.35	9239600.0
2004-02-06 11:00:00	SPY	ETF	114.36	114.38	114.08	114.18	2427900.0
2004-02-06 12:00:00	SPY	ETF	114.16	114.36	114.09	114.22	2076200.0
2004-02-06 13:00:00	SPY	ETF	114.21	114.4	114.14	114.33	1759900.0
2004-02-06 14:00:00	SPY	ETF	114.32	114.57	114.19	114.471	1875200.0
2004-02-06 15:00:00	SPY	ETF	114.45	114.69	114.4	114.66	4178200.0
2004-02-06 16:00:00	SPY	ETF	114.66	114.7	114.3	114.4	2117100.0
2004-02-06 17:00:00	SPY	ETF	114.39	114.45	114.39	114.45	40600.0
2004-02-06 18:00:00	SPY	ETF	114.44	114.45	114.4	114.45	7900.0
2004-02-06 19:00:00	SPY	ETF	114.46	114.47	114.45	114.45	1000.0
2004-02-06 08:00:00	QQQ	ETF	36.61	36.67	36.39	36.54	845600.0
2004-02-06 09:00:00	QQQ	ETF	36.53	36.84	36.5	36.68	20020800.0
2004-02-06 10:00:00	QQQ	ETF	36.66	37.1	36.64	36.98	24195500.0
2004-02-06 11:00:00	QQQ	ETF	37.0	37.06	36.92	36.99	7951900.0
2004-02-06 12:00:00	QQQ	ETF	36.99	37.06	36.95	37.001	5412000.0
2004-02-06 13:00:00	QQQ	ETF	37.002	37.13	36.95	37.1	8885500.0
2004-02-06 14:00:00	QQQ	ETF	37.09	37.176	37.0	37.123	9069000.0
2004-02-06 15:00:00	QQQ	ETF	37.13	37.27	37.11	37.25	21301000.0
2004-02-06 16:00:00	QQQ	ETF	37.25	37.28	37.11	37.16	3224200.0
2004-02-06 17:00:00	QQQ	ETF	37.16	37.18	37.13	37.14	48300.0
2004-02-06 18:00:00	QQQ	ETF	37.14	37.18	37.14	37.17	54400.0
2004-02-06 19:00:00	QQQ	ETF	37.17	37.18	37.15	37.18	3100.0
2004-02-06 09:00:00	IWM	ETF	56.77	57.22	56.725	56.85	2255800.0
2004-02-06 10:00:00	IWM	ETF	56.861	57.5	56.811	57.5	2362400.0
2004-02-06 11:00:00	IWM	ETF	57.525	57.595	57.44	57.52	604000.0
2004-02-06 12:00:00	IWM	ETF	57.51	57.755	57.445	57.695	982800.0
2004-02-06 13:00:00	IWM	ETF	57.685	57.835	57.655	57.835	837800.0
2004-02-06 14:00:00	IWM	ETF	57.815	57.985	57.74	57.95	842000.0
2004-02-06 15:00:00	IWM	ETF	57.955	58.315	57.91	58.135	2587800.0
2004-02-06 16:00:00	IWM	ETF	58.12	58.205	58.005	58.1	489800.0
2004-02-06 17:00:00	IWM	ETF	58.125	58.125	58.125	58.125	3000.0
2004-02-06 18:00:00	IWM	ETF	58.125	58.125	58.125	58.125	1200.0
2004-02-06 08:00:00	DIA	ETF	105.27	105.51	105.03	105.23	41900.0
2004-02-06 09:00:00	DIA	ETF	105.22	105.4	104.83	104.99	1307900.0
2004-02-06 10:00:00	DIA	ETF	104.97	106.12	104.97	106.0	2005100.0
2004-02-06 11:00:00	DIA	ETF	105.98	106.044	105.71	105.75	1249700.0
2004-02-06 12:00:00	DIA	ETF	105.76	105.86	105.68	105.8	320100.0
2004-02-06 13:00:00	DIA	ETF	105.76	105.93	105.685	105.84	259800.0
2004-02-06 14:00:00	DIA	ETF	105.83	106.04	105.7	106.0	538500.0
2004-02-06 15:00:00	DIA	ETF	106.0	106.15	105.87	106.11	642000.0
2004-02-06 16:00:00	DIA	ETF	106.07	106.13	105.97	105.99	190200.0
2004-02-06 17:00:00	DIA	ETF	106.0	106.0	105.96	106.0	16800.0
2004-02-06 18:00:00	DIA	ETF	105.99	105.99	105.91	105.91	3000.0
2004-02-06 19:00:00	DIA	ETF	106.0	106.0	106.0	106.0	600.0
2004-02-06 09:00:00	TLT	ETF	87.14	87.3	87.03	87.26	80800.0
2004-02-06 10:00:00	TLT	ETF	87.2	87.37	87.12	87.31	570600.0
2004-02-06 11:00:00	TLT	ETF	87.31	87.31	87.14	87.27	10000.0
2004-02-06 12:00:00	TLT	ETF	87.3	87.45	87.3	87.4	28300.0

> showing 50 of 693 rows — these rows as CSV

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