PREVIEW / etf_1hour / 2005-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-07.parquet
  size:    34 KB
  rows:    1,037

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-11-07 07:00:00	SPY	ETF	122.25	122.35	122.25	122.32	4000.0
2005-11-07 08:00:00	SPY	ETF	122.3	122.47	122.14	122.46	472100.0
2005-11-07 09:00:00	SPY	ETF	122.44	122.53	122.17	122.21	5929000.0
2005-11-07 10:00:00	SPY	ETF	122.2	122.3	121.85	122.14	11264200.0
2005-11-07 11:00:00	SPY	ETF	122.13	122.22	121.88	122.12	3269100.0
2005-11-07 12:00:00	SPY	ETF	122.11	122.36	122.06	122.26	5148600.0
2005-11-07 13:00:00	SPY	ETF	122.27	122.36	122.1	122.23	4231700.0
2005-11-07 14:00:00	SPY	ETF	122.23	122.62	122.11	122.54	7236300.0
2005-11-07 15:00:00	SPY	ETF	122.55	122.58	122.21	122.44	7541200.0
2005-11-07 16:00:00	SPY	ETF	122.43	122.43	122.15	122.21	720300.0
2005-11-07 17:00:00	SPY	ETF	122.22	122.27	122.22	122.23	11000.0
2005-11-07 18:00:00	SPY	ETF	122.2	122.21	122.19	122.19	600.0
2005-11-07 19:00:00	SPY	ETF	122.22	122.22	122.22	122.22	200.0
2005-11-07 09:00:00	QQQ	ETF	40.2	40.29	40.1	40.11	12332500.0
2005-11-07 10:00:00	QQQ	ETF	40.12	40.18	39.95	40.09	11640100.0
2005-11-07 11:00:00	QQQ	ETF	40.09	40.15	40.02	40.09	6130700.0
2005-11-07 12:00:00	QQQ	ETF	40.09	40.22	40.09	40.19	7662100.0
2005-11-07 13:00:00	QQQ	ETF	40.19	40.21	40.11	40.14	5396900.0
2005-11-07 14:00:00	QQQ	ETF	40.15	40.27	40.11	40.2	10194200.0
2005-11-07 15:00:00	QQQ	ETF	40.2	40.23	40.06	40.13	8983200.0
2005-11-07 08:00:00	IWM	ETF	65.59	65.83	65.58	65.76	243600.0
2005-11-07 09:00:00	IWM	ETF	65.75	65.9	65.5	65.6	2009800.0
2005-11-07 10:00:00	IWM	ETF	65.61	65.66	65.28	65.54	2515600.0
2005-11-07 11:00:00	IWM	ETF	65.54	65.55	65.26	65.39	1264500.0
2005-11-07 12:00:00	IWM	ETF	65.4	65.76	65.34	65.74	2953900.0
2005-11-07 13:00:00	IWM	ETF	65.74	65.76	65.57	65.57	1299000.0
2005-11-07 14:00:00	IWM	ETF	65.56	66.05	65.51	65.98	3165700.0
2005-11-07 15:00:00	IWM	ETF	65.98	66.01	65.5	65.73	6587100.0
2005-11-07 16:00:00	IWM	ETF	65.7	65.79	65.51	65.63	262300.0
2005-11-07 17:00:00	IWM	ETF	65.63	65.63	65.62	65.62	5700.0
2005-11-07 18:00:00	IWM	ETF	65.79	65.79	65.61	65.61	12700.0
2005-11-07 08:00:00	DIA	ETF	105.35	105.49	105.33	105.49	19800.0
2005-11-07 09:00:00	DIA	ETF	105.5	105.6	105.39	105.42	523600.0
2005-11-07 10:00:00	DIA	ETF	105.44	105.53	105.17	105.37	576400.0
2005-11-07 11:00:00	DIA	ETF	105.37	105.5	105.23	105.45	327500.0
2005-11-07 12:00:00	DIA	ETF	105.44	105.65	105.44	105.561	392200.0
2005-11-07 13:00:00	DIA	ETF	105.56	105.66	105.47	105.58	241400.0
2005-11-07 14:00:00	DIA	ETF	105.56	105.86	105.5	105.85	445900.0
2005-11-07 15:00:00	DIA	ETF	105.84	105.87	105.61	105.79	649100.0
2005-11-07 16:00:00	DIA	ETF	105.78	105.78	105.61	105.62	6700.0
2005-11-07 17:00:00	DIA	ETF	105.67	105.67	105.67	105.67	100.0
2005-11-07 18:00:00	DIA	ETF	105.6	105.6	105.6	105.6	200.0
2005-11-07 19:00:00	DIA	ETF	105.64	105.64	105.64	105.64	300.0
2005-11-07 08:00:00	GLD	ETF	45.6	45.6	45.56	45.57	4700.0
2005-11-07 09:00:00	GLD	ETF	45.69	45.69	45.47	45.51	253300.0
2005-11-07 10:00:00	GLD	ETF	45.51	45.67	45.46	45.61	127100.0
2005-11-07 11:00:00	GLD	ETF	45.61	45.62	45.54	45.61	53100.0
2005-11-07 12:00:00	GLD	ETF	45.61	45.71	45.59	45.689	95400.0
2005-11-07 13:00:00	GLD	ETF	45.69	45.8	45.68	45.77	118800.0
2005-11-07 14:00:00	GLD	ETF	45.77	45.82	45.75	45.81	38400.0

> showing 50 of 1,037 rows — these rows as CSV

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