PREVIEW / etf_1hour / 2005-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-16.parquet
  size:    29 KB
  rows:    878

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-06-16 07:00:00	SPY	ETF	121.19	121.24	121.19	121.2	32500.0
2005-06-16 08:00:00	SPY	ETF	121.21	121.21	121.05	121.13	141600.0
2005-06-16 09:00:00	SPY	ETF	121.14	121.21	120.92	121.1	4000700.0
2005-06-16 10:00:00	SPY	ETF	121.1	121.64	121.1	121.44	12149800.0
2005-06-16 11:00:00	SPY	ETF	121.44	121.5	121.28	121.45	5526000.0
2005-06-16 12:00:00	SPY	ETF	121.46	121.47	121.07	121.31	6150400.0
2005-06-16 13:00:00	SPY	ETF	121.31	121.46	121.18	121.28	6045000.0
2005-06-16 14:00:00	SPY	ETF	121.29	121.45	121.16	121.41	3258200.0
2005-06-16 15:00:00	SPY	ETF	121.41	121.63	121.33	121.49	6486100.0
2005-06-16 16:00:00	SPY	ETF	121.49	121.49	121.38	121.41	1223900.0
2005-06-16 17:00:00	SPY	ETF	121.41	121.46	121.4	121.46	43500.0
2005-06-16 18:00:00	SPY	ETF	121.43	121.44	121.41	121.44	24200.0
2005-06-16 19:00:00	SPY	ETF	121.42	121.42	121.42	121.42	400.0
2005-06-16 09:00:00	QQQ	ETF	37.74	37.91	37.66	37.8	14063300.0
2005-06-16 10:00:00	QQQ	ETF	37.8	38.0	37.79	37.94	16729200.0
2005-06-16 11:00:00	QQQ	ETF	37.94	37.95	37.84	37.94	12516800.0
2005-06-16 12:00:00	QQQ	ETF	37.94	37.94	37.76	37.86	11667100.0
2005-06-16 13:00:00	QQQ	ETF	37.86	37.88	37.76	37.81	5314700.0
2005-06-16 14:00:00	QQQ	ETF	37.81	37.87	37.71	37.85	12241800.0
2005-06-16 15:00:00	QQQ	ETF	37.84	37.96	37.82	37.9	11833500.0
2005-06-16 08:00:00	IWM	ETF	63.54	63.55	63.54	63.55	4900.0
2005-06-16 09:00:00	IWM	ETF	63.5	63.65	63.33	63.47	1797000.0
2005-06-16 10:00:00	IWM	ETF	63.47	63.88	63.45	63.73	4090400.0
2005-06-16 11:00:00	IWM	ETF	63.74	63.88	63.72	63.88	2297000.0
2005-06-16 12:00:00	IWM	ETF	63.88	63.89	63.66	63.78	1899800.0
2005-06-16 13:00:00	IWM	ETF	63.78	63.95	63.74	63.88	1108300.0
2005-06-16 14:00:00	IWM	ETF	63.87	64.0	63.8	63.96	2209900.0
2005-06-16 15:00:00	IWM	ETF	63.95	64.14	63.94	64.05	7388000.0
2005-06-16 16:00:00	IWM	ETF	64.07	64.14	63.95	64.02	618500.0
2005-06-16 17:00:00	IWM	ETF	64.05	64.07	64.0	64.0	410000.0
2005-06-16 08:00:00	DIA	ETF	105.8	105.8	105.8	105.8	200.0
2005-06-16 09:00:00	DIA	ETF	105.7	105.78	105.46	105.52	272100.0
2005-06-16 10:00:00	DIA	ETF	105.51	106.02	105.49	105.89	2048000.0
2005-06-16 11:00:00	DIA	ETF	105.88	106.0	105.77	105.91	812400.0
2005-06-16 12:00:00	DIA	ETF	105.91	105.93	105.55	105.71	1137600.0
2005-06-16 13:00:00	DIA	ETF	105.71	105.85	105.64	105.7	529400.0
2005-06-16 14:00:00	DIA	ETF	105.71	105.8	105.6	105.76	859100.0
2005-06-16 15:00:00	DIA	ETF	105.77	105.92	105.73	105.82	890600.0
2005-06-16 16:00:00	DIA	ETF	105.76	105.8	105.75	105.75	19300.0
2005-06-16 18:00:00	DIA	ETF	105.76	105.76	105.76	105.76	200.0
2005-06-16 07:00:00	GLD	ETF	43.06	43.06	43.06	43.06	1000.0
2005-06-16 08:00:00	GLD	ETF	43.1	43.28	43.1	43.28	25000.0
2005-06-16 09:00:00	GLD	ETF	43.27	43.33	43.2	43.21	357300.0
2005-06-16 10:00:00	GLD	ETF	43.2	43.31	43.17	43.27	417700.0
2005-06-16 11:00:00	GLD	ETF	43.26	43.36	43.26	43.33	401600.0
2005-06-16 12:00:00	GLD	ETF	43.31	43.47	43.31	43.47	239700.0
2005-06-16 13:00:00	GLD	ETF	43.46	43.55	43.43	43.5	148000.0
2005-06-16 14:00:00	GLD	ETF	43.5	43.5	43.44	43.45	60900.0
2005-06-16 15:00:00	GLD	ETF	43.45	43.46	43.42	43.42	147800.0
2005-06-16 16:00:00	GLD	ETF	43.47	43.47	43.41	43.41	4500.0

> showing 50 of 878 rows — these rows as CSV

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