PREVIEW / etf_1hour / 2005-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-22.parquet
  size:    31 KB
  rows:    937

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-22 06:00:00	SPY	ETF	122.73	122.73	122.73	122.73	27300.0
2005-08-22 07:00:00	SPY	ETF	122.77	122.82	122.77	122.78	23700.0
2005-08-22 08:00:00	SPY	ETF	122.7	122.78	122.29	122.73	895900.0
2005-08-22 09:00:00	SPY	ETF	122.26	123.06	122.26	123.05	7174800.0
2005-08-22 10:00:00	SPY	ETF	123.04	123.23	123.0	123.12	9600700.0
2005-08-22 11:00:00	SPY	ETF	123.12	123.15	122.67	122.73	7659400.0
2005-08-22 12:00:00	SPY	ETF	122.73	122.85	122.08	122.21	11448900.0
2005-08-22 13:00:00	SPY	ETF	122.21	122.72	121.88	122.38	12106600.0
2005-08-22 14:00:00	SPY	ETF	122.38	122.39	122.1	122.23	6882700.0
2005-08-22 15:00:00	SPY	ETF	122.23	122.49	122.08	122.47	8391200.0
2005-08-22 16:00:00	SPY	ETF	122.48	122.52	122.37	122.5	380000.0
2005-08-22 17:00:00	SPY	ETF	122.52	122.52	122.5	122.5	2900.0
2005-08-22 18:00:00	SPY	ETF	122.5	122.5	122.5	122.5	200.0
2005-08-22 19:00:00	SPY	ETF	122.53	122.55	122.53	122.55	1800.0
2005-08-22 09:00:00	QQQ	ETF	38.89	39.08	38.86	39.05	11736200.0
2005-08-22 10:00:00	QQQ	ETF	39.05	39.18	39.05	39.11	17378000.0
2005-08-22 11:00:00	QQQ	ETF	39.12	39.12	38.9	38.91	11316800.0
2005-08-22 12:00:00	QQQ	ETF	38.92	38.92	38.61	38.65	16583700.0
2005-08-22 13:00:00	QQQ	ETF	38.66	38.82	38.6	38.8	10321600.0
2005-08-22 14:00:00	QQQ	ETF	38.79	38.8	38.7	38.77	6497300.0
2005-08-22 15:00:00	QQQ	ETF	38.76	38.84	38.69	38.84	9597900.0
2005-08-22 07:00:00	IWM	ETF	65.33	65.33	65.32	65.32	2000.0
2005-08-22 08:00:00	IWM	ETF	65.2	65.28	65.2	65.26	30400.0
2005-08-22 09:00:00	IWM	ETF	65.26	65.44	65.1	65.37	2994600.0
2005-08-22 10:00:00	IWM	ETF	65.37	65.5	65.2	65.37	2959700.0
2005-08-22 11:00:00	IWM	ETF	65.37	65.37	65.17	65.19	3337200.0
2005-08-22 12:00:00	IWM	ETF	65.18	65.22	64.88	65.0	2342300.0
2005-08-22 13:00:00	IWM	ETF	64.99	65.36	64.87	65.31	3462800.0
2005-08-22 14:00:00	IWM	ETF	65.32	65.36	65.2	65.22	2289100.0
2005-08-22 15:00:00	IWM	ETF	65.22	65.48	65.12	65.43	3253800.0
2005-08-22 16:00:00	IWM	ETF	65.44	66.45	65.44	65.49	261800.0
2005-08-22 17:00:00	IWM	ETF	65.52	65.52	65.52	65.52	500.0
2005-08-22 18:00:00	IWM	ETF	65.54	65.54	65.54	65.54	500.0
2005-08-22 07:00:00	DIA	ETF	106.02	106.02	106.02	106.02	700.0
2005-08-22 08:00:00	DIA	ETF	105.99	106.05	105.99	106.05	6100.0
2005-08-22 09:00:00	DIA	ETF	105.98	106.19	105.76	106.18	1015700.0
2005-08-22 10:00:00	DIA	ETF	106.18	106.38	106.16	106.23	865900.0
2005-08-22 11:00:00	DIA	ETF	106.21	106.23	105.87	105.87	567500.0
2005-08-22 12:00:00	DIA	ETF	105.85	105.88	105.35	105.45	1253000.0
2005-08-22 13:00:00	DIA	ETF	105.46	105.67	105.17	105.6	1316300.0
2005-08-22 14:00:00	DIA	ETF	105.6	105.64	105.43	105.48	565700.0
2005-08-22 15:00:00	DIA	ETF	105.5	105.69	105.37	105.69	1075200.0
2005-08-22 16:00:00	DIA	ETF	105.64	105.7	105.6	105.7	14200.0
2005-08-22 17:00:00	DIA	ETF	105.66	105.66	105.66	105.66	25000.0
2005-08-22 08:00:00	GLD	ETF	43.85	43.96	43.77	43.77	16500.0
2005-08-22 09:00:00	GLD	ETF	43.84	43.89	43.77	43.83	149300.0
2005-08-22 10:00:00	GLD	ETF	43.81	43.95	43.8	43.93	200700.0
2005-08-22 11:00:00	GLD	ETF	43.93	43.94	43.74	43.81	224500.0
2005-08-22 12:00:00	GLD	ETF	43.8	43.8	43.68	43.72	123000.0
2005-08-22 13:00:00	GLD	ETF	43.71	43.75	43.66	43.72	95600.0

> showing 50 of 937 rows — these rows as CSV

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