PREVIEW / etf_1hour / 2005-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-22.parquet
  size:    31 KB
  rows:    865

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
2005-02-22 08:00:00	SPY	ETF	119.86	119.91	119.83	119.9	326900.0
2005-02-22 09:00:00	SPY	ETF	119.9	119.95	119.76	119.91	6111000.0
2005-02-22 10:00:00	SPY	ETF	119.91	120.47	119.77	120.26	13023100.0
2005-02-22 11:00:00	SPY	ETF	120.26	120.29	119.88	119.92	6580000.0
2005-02-22 12:00:00	SPY	ETF	119.92	120.07	119.27	119.4	14726400.0
2005-02-22 13:00:00	SPY	ETF	119.4	120.3576	119.19	119.25	8247700.0
2005-02-22 14:00:00	SPY	ETF	119.25	119.25	118.87	118.93	11026600.0
2005-02-22 15:00:00	SPY	ETF	118.94	119.375	118.58	118.59	11601900.0
2005-02-22 16:00:00	SPY	ETF	118.59	119.03	118.57	118.62	1709100.0
2005-02-22 17:00:00	SPY	ETF	118.65	118.7	118.56	118.7	132300.0
2005-02-22 18:00:00	SPY	ETF	118.62	118.7	118.6	118.7	17900.0
2005-02-22 19:00:00	SPY	ETF	118.68	118.68	118.66	118.68	11200.0
2005-02-22 09:00:00	QQQ	ETF	37.03	37.11	36.96	37.08	15247400.0
2005-02-22 10:00:00	QQQ	ETF	37.09	37.55	37.03	37.37	24561700.0
2005-02-22 11:00:00	QQQ	ETF	37.37	37.37	37.26	37.32	11088700.0
2005-02-22 12:00:00	QQQ	ETF	37.32	37.41	37.01	37.1	13191500.0
2005-02-22 13:00:00	QQQ	ETF	37.1	37.2	37.04	37.11	10352600.0
2005-02-22 14:00:00	QQQ	ETF	37.11	37.12	36.97	37.03	11640900.0
2005-02-22 15:00:00	QQQ	ETF	37.03	37.04	36.79	36.89	26698200.0
2005-02-22 08:00:00	IWM	ETF	62.425	62.425	62.425	62.425	400.0
2005-02-22 09:00:00	IWM	ETF	62.37	62.495	62.1465	62.325	1985600.0
2005-02-22 10:00:00	IWM	ETF	62.325	62.85	62.12	62.45	6010800.0
2005-02-22 11:00:00	IWM	ETF	62.45	62.535	62.345	62.405	2107400.0
2005-02-22 12:00:00	IWM	ETF	62.405	62.5	61.875	62.0	4355000.0
2005-02-22 13:00:00	IWM	ETF	62.0	62.115	61.805	61.865	2856800.0
2005-02-22 14:00:00	IWM	ETF	61.86	61.88	61.72	61.805	3828000.0
2005-02-22 15:00:00	IWM	ETF	61.805	61.805	61.5	61.56	4691200.0
2005-02-22 16:00:00	IWM	ETF	61.675	61.68	61.56	61.635	846200.0
2005-02-22 17:00:00	IWM	ETF	61.6441	61.6441	61.6441	61.6441	29400.0
2005-02-22 08:00:00	DIA	ETF	107.37	107.38	107.33	107.38	4500.0
2005-02-22 09:00:00	DIA	ETF	107.36	107.36	107.11	107.29	656400.0
2005-02-22 10:00:00	DIA	ETF	107.28	107.67	107.17	107.54	1508100.0
2005-02-22 11:00:00	DIA	ETF	107.53	107.57	107.2	107.25	921600.0
2005-02-22 12:00:00	DIA	ETF	107.24	107.34	106.64	106.78	993900.0
2005-02-22 13:00:00	DIA	ETF	106.77	106.89	106.6	106.65	1146600.0
2005-02-22 14:00:00	DIA	ETF	106.64	106.64	106.29	106.34	1944200.0
2005-02-22 15:00:00	DIA	ETF	106.34	106.43	106.03	106.05	1591800.0
2005-02-22 16:00:00	DIA	ETF	106.05	106.12	106.0	106.07	56100.0
2005-02-22 17:00:00	DIA	ETF	106.06	106.15	106.05	106.15	31800.0
2005-02-22 09:00:00	GLD	ETF	43.39	43.39	43.26	43.28	538300.0
2005-02-22 10:00:00	GLD	ETF	43.26	43.37	43.2	43.32	526000.0
2005-02-22 11:00:00	GLD	ETF	43.35	43.48	43.33	43.4	365200.0
2005-02-22 12:00:00	GLD	ETF	43.4	43.48	43.36	43.47	250900.0
2005-02-22 13:00:00	GLD	ETF	43.47	43.5	43.42	43.5	318600.0
2005-02-22 14:00:00	GLD	ETF	43.5	43.51	43.45	43.5	662300.0
2005-02-22 15:00:00	GLD	ETF	43.5	43.63	43.5	43.6	535500.0
2005-02-22 16:00:00	GLD	ETF	43.6	43.63	43.43	43.44	111100.0
2005-02-22 17:00:00	GLD	ETF	43.45	43.45	43.45	43.45	100.0
2005-02-22 08:00:00	TLT	ETF	90.53	90.53	90.41	90.43	36300.0
2005-02-22 09:00:00	TLT	ETF	90.46	90.64	90.46	90.6	140800.0

> showing 50 of 865 rows — these rows as CSV

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