PREVIEW / etf_1hour / 2005-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-08.parquet
  size:    30 KB
  rows:    943

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-09-08 07:00:00	SPY	ETF	123.67	123.68	123.55	123.55	59500.0
2005-09-08 08:00:00	SPY	ETF	123.54	123.65	123.54	123.58	620100.0
2005-09-08 09:00:00	SPY	ETF	123.58	123.7	123.46	123.59	3437900.0
2005-09-08 10:00:00	SPY	ETF	123.59	124.0	123.55	123.68	9908800.0
2005-09-08 11:00:00	SPY	ETF	123.68	123.94	123.56	123.8	3720900.0
2005-09-08 12:00:00	SPY	ETF	123.8	123.85	123.7	123.75	2039400.0
2005-09-08 13:00:00	SPY	ETF	123.75	123.79	123.58	123.68	1778500.0
2005-09-08 14:00:00	SPY	ETF	123.68	123.77	123.45	123.49	4190500.0
2005-09-08 15:00:00	SPY	ETF	123.49	123.705	123.31	123.58	8636400.0
2005-09-08 16:00:00	SPY	ETF	123.5985	123.6	123.46	123.54	1390300.0
2005-09-08 17:00:00	SPY	ETF	123.52	123.53	123.5	123.51	60300.0
2005-09-08 18:00:00	SPY	ETF	123.52	123.57	123.5	123.57	5600.0
2005-09-08 09:00:00	QQQ	ETF	39.29	39.34	39.27	39.33	6508800.0
2005-09-08 10:00:00	QQQ	ETF	39.33	39.56	39.32	39.42	15659800.0
2005-09-08 11:00:00	QQQ	ETF	39.41	39.54	39.4	39.49	7413600.0
2005-09-08 12:00:00	QQQ	ETF	39.49	39.57	39.46	39.52	7598500.0
2005-09-08 13:00:00	QQQ	ETF	39.52	39.54	39.4	39.44	5277900.0
2005-09-08 14:00:00	QQQ	ETF	39.44	39.5	39.36	39.41	9661700.0
2005-09-08 15:00:00	QQQ	ETF	39.41	39.41	39.3	39.41	12340600.0
2005-09-08 08:00:00	IWM	ETF	67.2	67.2	67.12	67.13	31100.0
2005-09-08 09:00:00	IWM	ETF	67.13	67.3	66.94	67.01	2085400.0
2005-09-08 10:00:00	IWM	ETF	67.0	67.25	66.94	67.09	2605400.0
2005-09-08 11:00:00	IWM	ETF	67.09	67.22	67.02	67.17	1558800.0
2005-09-08 12:00:00	IWM	ETF	67.17	67.27	67.16	67.25	564200.0
2005-09-08 13:00:00	IWM	ETF	67.25	67.26	67.06	67.1108	450300.0
2005-09-08 14:00:00	IWM	ETF	67.1	67.16	66.9	66.91	2529000.0
2005-09-08 15:00:00	IWM	ETF	66.91	67.05	66.74	67.01	2899500.0
2005-09-08 16:00:00	IWM	ETF	66.99	67.08	66.98	66.98	51000.0
2005-09-08 17:00:00	IWM	ETF	66.91	66.91	66.88	66.88	400.0
2005-09-08 18:00:00	IWM	ETF	66.95	67.06	66.85	67.06	1500.0
2005-09-08 07:00:00	DIA	ETF	105.96	105.96	105.95	105.95	6200.0
2005-09-08 08:00:00	DIA	ETF	105.95	106.0	105.94	105.94	25800.0
2005-09-08 09:00:00	DIA	ETF	105.94	106.06	105.87	105.96	417800.0
2005-09-08 10:00:00	DIA	ETF	105.96	106.29	105.92	106.04	2289900.0
2005-09-08 11:00:00	DIA	ETF	106.04	106.19	105.92	106.09	684400.0
2005-09-08 12:00:00	DIA	ETF	106.11	106.15	105.99	106.06	296300.0
2005-09-08 13:00:00	DIA	ETF	106.07	106.09	105.91	106.0	317700.0
2005-09-08 14:00:00	DIA	ETF	105.98	106.06	105.8	105.82	505500.0
2005-09-08 15:00:00	DIA	ETF	105.8	105.99	105.67	105.96	1167500.0
2005-09-08 16:00:00	DIA	ETF	105.9615	106.0	105.9	106.0	23300.0
2005-09-08 17:00:00	DIA	ETF	106.0	106.0	106.0	106.0	100.0
2005-09-08 18:00:00	DIA	ETF	106.03	106.03	106.03	106.03	400.0
2005-09-08 08:00:00	GLD	ETF	44.44	44.88	44.44	44.84	31400.0
2005-09-08 09:00:00	GLD	ETF	44.84	44.84	44.67	44.77	236500.0
2005-09-08 10:00:00	GLD	ETF	44.78	44.78	44.62	44.68	260600.0
2005-09-08 11:00:00	GLD	ETF	44.66	44.69	44.47	44.53	190900.0
2005-09-08 12:00:00	GLD	ETF	44.54	44.59	44.52	44.59	67200.0
2005-09-08 13:00:00	GLD	ETF	44.63	44.64	44.51	44.56	69400.0
2005-09-08 14:00:00	GLD	ETF	44.57	44.6	44.51	44.6	51000.0
2005-09-08 15:00:00	GLD	ETF	44.58	44.64	44.57	44.6	125600.0

> showing 50 of 943 rows — these rows as CSV

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