PREVIEW / etf_1hour / 2005-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-04.parquet
  size:    31 KB
  rows:    932

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-08-04 07:00:00	SPY	ETF	124.42	124.42	124.32	124.32	100300.0
2005-08-04 08:00:00	SPY	ETF	124.37	124.4	124.2	124.23	2293600.0
2005-08-04 09:00:00	SPY	ETF	124.24	124.29	124.01	124.04	6061200.0
2005-08-04 10:00:00	SPY	ETF	124.03	124.23	123.97	124.17	6259300.0
2005-08-04 11:00:00	SPY	ETF	124.17	124.31	123.81	123.83	7695100.0
2005-08-04 12:00:00	SPY	ETF	123.83	123.9	123.66	123.74	8842200.0
2005-08-04 13:00:00	SPY	ETF	123.75	123.84	123.6	123.77	3632000.0
2005-08-04 14:00:00	SPY	ETF	123.77	123.92	123.61	123.8	4009100.0
2005-08-04 15:00:00	SPY	ETF	123.79	123.96	123.63	123.66	8685900.0
2005-08-04 16:00:00	SPY	ETF	123.68	123.77	123.57	123.75	1360900.0
2005-08-04 17:00:00	SPY	ETF	123.75	123.78	123.72	123.73	19500.0
2005-08-04 18:00:00	SPY	ETF	123.7	123.78	123.7	123.78	3700.0
2005-08-04 09:00:00	QQQ	ETF	39.89	39.93	39.83	39.85	9649600.0
2005-08-04 10:00:00	QQQ	ETF	39.85	39.92	39.81	39.89	8970600.0
2005-08-04 11:00:00	QQQ	ETF	39.89	39.94	39.7	39.7	11405600.0
2005-08-04 12:00:00	QQQ	ETF	39.7	39.7	39.6	39.65	9666800.0
2005-08-04 13:00:00	QQQ	ETF	39.65	39.69	39.57	39.66	7153200.0
2005-08-04 14:00:00	QQQ	ETF	39.65	40.1	39.64	39.66	7023000.0
2005-08-04 15:00:00	QQQ	ETF	39.67	39.72	39.6	39.67	11133400.0
2005-08-04 07:00:00	IWM	ETF	67.79	67.79	67.71	67.76	63700.0
2005-08-04 08:00:00	IWM	ETF	67.76	67.78	67.7	67.7	135400.0
2005-08-04 09:00:00	IWM	ETF	67.66	67.8	67.35	67.37	2099600.0
2005-08-04 10:00:00	IWM	ETF	67.36	67.39	67.24	67.34	3113500.0
2005-08-04 11:00:00	IWM	ETF	67.35	67.46	67.07	67.09	4127200.0
2005-08-04 12:00:00	IWM	ETF	67.08	67.13	66.96	67.02	2117500.0
2005-08-04 13:00:00	IWM	ETF	67.02	67.1	66.92	67.0	1534600.0
2005-08-04 14:00:00	IWM	ETF	66.99	67.09	66.97	67.02	1838300.0
2005-08-04 15:00:00	IWM	ETF	67.01	67.1	66.78	66.88	3321900.0
2005-08-04 16:00:00	IWM	ETF	66.89	66.94	66.8	66.88	163400.0
2005-08-04 18:00:00	IWM	ETF	66.89	66.89	66.89	66.89	500.0
2005-08-04 19:00:00	IWM	ETF	66.89	66.89	66.89	66.89	100.0
2005-08-04 07:00:00	DIA	ETF	106.8	106.8	106.8	106.8	300.0
2005-08-04 08:00:00	DIA	ETF	106.7	106.73	106.67	106.67	93500.0
2005-08-04 09:00:00	DIA	ETF	106.67	106.73	106.5	106.52	1263600.0
2005-08-04 10:00:00	DIA	ETF	106.52	106.63	106.45	106.6	1049700.0
2005-08-04 11:00:00	DIA	ETF	106.61	106.69	106.22	106.23	545300.0
2005-08-04 12:00:00	DIA	ETF	106.26	106.27	106.08	106.19	476000.0
2005-08-04 13:00:00	DIA	ETF	106.19	106.23	106.07	106.19	224000.0
2005-08-04 14:00:00	DIA	ETF	106.19	106.27	106.13	106.16	307000.0
2005-08-04 15:00:00	DIA	ETF	106.2	106.3	106.06	106.08	1116300.0
2005-08-04 16:00:00	DIA	ETF	106.12	106.17	106.03	106.16	22700.0
2005-08-04 17:00:00	DIA	ETF	106.18	106.18	106.18	106.18	500.0
2005-08-04 18:00:00	DIA	ETF	106.1	106.1	106.1	106.1	100.0
2005-08-04 08:00:00	GLD	ETF	43.52	43.56	43.52	43.56	2900.0
2005-08-04 09:00:00	GLD	ETF	43.62	43.78	43.62	43.77	147100.0
2005-08-04 10:00:00	GLD	ETF	43.76	43.82	43.74	43.8	288600.0
2005-08-04 11:00:00	GLD	ETF	43.79	43.82	43.68	43.72	109400.0
2005-08-04 12:00:00	GLD	ETF	43.72	43.78	43.7	43.77	100300.0
2005-08-04 13:00:00	GLD	ETF	43.76	43.77	43.69	43.73	58600.0
2005-08-04 14:00:00	GLD	ETF	43.7	43.7	43.63	43.67	45600.0

> showing 50 of 932 rows — these rows as CSV

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