PREVIEW / etf_1hour / 2005-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-19.parquet
  size:    32 KB
  rows:    965

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-19 07:00:00	SPY	ETF	123.37	123.38	123.32	123.35	22700.0
2005-09-19 08:00:00	SPY	ETF	123.41	123.55	123.33	123.53	375800.0
2005-09-19 09:00:00	SPY	ETF	123.54	123.57	123.31	123.4	7030100.0
2005-09-19 10:00:00	SPY	ETF	123.41	123.43	123.1	123.11	10805700.0
2005-09-19 11:00:00	SPY	ETF	123.11	123.18	122.93	122.98	9503400.0
2005-09-19 12:00:00	SPY	ETF	122.96	123.13	122.93	123.08	3664400.0
2005-09-19 13:00:00	SPY	ETF	123.07	123.15	122.96	123.02	2158300.0
2005-09-19 14:00:00	SPY	ETF	123.05	123.09	122.7	122.82	6990400.0
2005-09-19 15:00:00	SPY	ETF	122.82	123.39	122.64	122.96	9398800.0
2005-09-19 16:00:00	SPY	ETF	122.95	123.12	122.93	123.05	822900.0
2005-09-19 17:00:00	SPY	ETF	123.05	123.14	123.05	123.07	9500.0
2005-09-19 18:00:00	SPY	ETF	123.07	123.1	123.07	123.1	10600.0
2005-09-19 19:00:00	SPY	ETF	123.12	123.12	123.11	123.11	2400.0
2005-09-19 09:00:00	QQQ	ETF	39.33	39.38	39.26	39.29	9242300.0
2005-09-19 10:00:00	QQQ	ETF	39.29	39.29	39.14	39.15	14320200.0
2005-09-19 11:00:00	QQQ	ETF	39.15	39.16	37.3	39.02	14625600.0
2005-09-19 12:00:00	QQQ	ETF	39.02	39.09	39.0	39.06	4173100.0
2005-09-19 13:00:00	QQQ	ETF	39.07	39.09	39.01	39.06	2853800.0
2005-09-19 14:00:00	QQQ	ETF	39.05	39.07	38.91	38.94	10169500.0
2005-09-19 15:00:00	QQQ	ETF	38.95	39.1	38.94	39.1	12649300.0
2005-09-19 08:00:00	IWM	ETF	66.91	66.91	66.91	66.91	100.0
2005-09-19 09:00:00	IWM	ETF	66.87	66.98	66.83	66.92	2752400.0
2005-09-19 10:00:00	IWM	ETF	66.92	66.92	66.64	66.73	6153200.0
2005-09-19 11:00:00	IWM	ETF	66.73	66.77	66.55	66.62	2962900.0
2005-09-19 12:00:00	IWM	ETF	66.62	66.75	66.59	66.72	1161300.0
2005-09-19 13:00:00	IWM	ETF	66.72	66.76	66.63	66.67	1216900.0
2005-09-19 14:00:00	IWM	ETF	66.66	66.72	66.32	66.36	2269700.0
2005-09-19 15:00:00	IWM	ETF	66.36	66.53	66.3	66.53	4035600.0
2005-09-19 16:00:00	IWM	ETF	66.51	66.64	66.47	66.47	445200.0
2005-09-19 17:00:00	IWM	ETF	66.58	66.58	66.58	66.58	100.0
2005-09-19 08:00:00	DIA	ETF	106.09	106.16	106.08	106.16	3100.0
2005-09-19 09:00:00	DIA	ETF	106.15	106.15	105.89	105.98	345900.0
2005-09-19 10:00:00	DIA	ETF	105.97	106.02	105.62	105.62	2336300.0
2005-09-19 11:00:00	DIA	ETF	105.63	105.73	105.45	105.51	924700.0
2005-09-19 12:00:00	DIA	ETF	105.5	105.65	105.45	105.62	1099900.0
2005-09-19 13:00:00	DIA	ETF	105.62	105.64	105.41	105.48	613600.0
2005-09-19 14:00:00	DIA	ETF	105.48	105.53	105.21	105.31	850600.0
2005-09-19 15:00:00	DIA	ETF	105.31	105.5	105.13	105.47	2045500.0
2005-09-19 16:00:00	DIA	ETF	105.501	105.65	105.47	105.53	10000.0
2005-09-19 17:00:00	DIA	ETF	105.53	105.53	105.53	105.53	500.0
2005-09-19 19:00:00	DIA	ETF	105.45	105.57	105.45	105.57	200.0
2005-09-19 07:00:00	GLD	ETF	46.3	46.3	46.3	46.3	1000.0
2005-09-19 08:00:00	GLD	ETF	46.28	46.32	46.2	46.28	7200.0
2005-09-19 09:00:00	GLD	ETF	46.24	46.35	46.24	46.31	1457000.0
2005-09-19 10:00:00	GLD	ETF	46.31	46.49	46.29	46.44	526800.0
2005-09-19 11:00:00	GLD	ETF	46.41	46.73	46.28	46.6	1152300.0
2005-09-19 12:00:00	GLD	ETF	46.6	46.69	46.6	46.68	324800.0
2005-09-19 13:00:00	GLD	ETF	46.69	46.69	46.41	46.43	339500.0
2005-09-19 14:00:00	GLD	ETF	46.44	46.47	46.34	46.38	527600.0
2005-09-19 15:00:00	GLD	ETF	46.38	46.39	46.22	46.26	1646000.0

> showing 50 of 965 rows — these rows as CSV

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