PREVIEW / etf_1hour / 2006-01-17

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-17.parquet
  size:    39 KB
  rows:    1,234

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
2006-01-17 04:00:00	SPY	ETF	128.25	128.25	128.25	128.25	100.0
2006-01-17 06:00:00	SPY	ETF	128.25	128.25	128.25	128.25	100.0
2006-01-17 07:00:00	SPY	ETF	128.25	128.26	128.17	128.22	91100.0
2006-01-17 08:00:00	SPY	ETF	128.69	128.74	128.06	128.19	1940800.0
2006-01-17 09:00:00	SPY	ETF	128.19	128.35	128.06	128.23	7490000.0
2006-01-17 10:00:00	SPY	ETF	128.24	128.31	128.0	128.15	9936600.0
2006-01-17 11:00:00	SPY	ETF	128.15	128.3	128.07	128.13	3333100.0
2006-01-17 12:00:00	SPY	ETF	128.14	128.19	127.81	127.99	7378400.0
2006-01-17 13:00:00	SPY	ETF	127.97	128.31	127.81	128.19	5057300.0
2006-01-17 14:00:00	SPY	ETF	128.19	128.42	128.02	128.29	5664700.0
2006-01-17 15:00:00	SPY	ETF	128.29	128.36	128.16	128.25	6266300.0
2006-01-17 16:00:00	SPY	ETF	128.26	128.4	127.66	127.67	2772400.0
2006-01-17 17:00:00	SPY	ETF	127.69	127.75	127.55	127.61	263800.0
2006-01-17 18:00:00	SPY	ETF	127.66	127.73	127.61	127.67	33600.0
2006-01-17 19:00:00	SPY	ETF	127.65	127.65	127.51	127.58	6800.0
2006-01-17 09:00:00	QQQ	ETF	42.66	42.75	42.61	42.69	9335000.0
2006-01-17 10:00:00	QQQ	ETF	42.69	42.79	42.6	42.67	12445300.0
2006-01-17 11:00:00	QQQ	ETF	42.68	42.75	42.63	42.68	6256900.0
2006-01-17 12:00:00	QQQ	ETF	42.68	42.7	42.61	42.63	4453300.0
2006-01-17 13:00:00	QQQ	ETF	42.63	42.68	42.5	42.64	9105300.0
2006-01-17 14:00:00	QQQ	ETF	42.65	42.75	42.6	42.71	8759000.0
2006-01-17 15:00:00	QQQ	ETF	42.72	42.74	42.63	42.73	8133500.0
2006-01-17 07:00:00	IWM	ETF	70.02	70.02	69.98	69.98	1800.0
2006-01-17 08:00:00	IWM	ETF	69.95	69.98	69.82	69.88	334300.0
2006-01-17 09:00:00	IWM	ETF	69.91	70.01	69.79	69.87	4886100.0
2006-01-17 10:00:00	IWM	ETF	69.86	70.0	69.72	69.89	3587400.0
2006-01-17 11:00:00	IWM	ETF	69.91	70.05	69.86	69.91	1379300.0
2006-01-17 12:00:00	IWM	ETF	69.92	69.95	69.63	69.68	4327800.0
2006-01-17 13:00:00	IWM	ETF	69.68	69.79	69.54	69.74	2939600.0
2006-01-17 14:00:00	IWM	ETF	69.74	69.9	69.65	69.82	3382300.0
2006-01-17 15:00:00	IWM	ETF	69.83	69.95	69.76	69.89	4505900.0
2006-01-17 16:00:00	IWM	ETF	69.9	70.05	69.54	69.54	830200.0
2006-01-17 17:00:00	IWM	ETF	69.47	69.53	69.47	69.47	53700.0
2006-01-17 18:00:00	IWM	ETF	69.45	69.45	69.45	69.45	100.0
2006-01-17 19:00:00	IWM	ETF	69.45	69.45	69.45	69.45	300.0
2006-01-17 08:00:00	DIA	ETF	109.15	109.15	109.05	109.14	6900.0
2006-01-17 09:00:00	DIA	ETF	109.14	109.27	109.03	109.15	460900.0
2006-01-17 10:00:00	DIA	ETF	109.13	109.2301	108.93	109.06	831200.0
2006-01-17 11:00:00	DIA	ETF	109.06	109.2	108.94	109.01	353200.0
2006-01-17 12:00:00	DIA	ETF	109.03	109.2	108.78	108.89	259300.0
2006-01-17 13:00:00	DIA	ETF	108.88	109.1	108.74	109.02	351500.0
2006-01-17 14:00:00	DIA	ETF	109.04	109.19	108.91	109.07	605300.0
2006-01-17 15:00:00	DIA	ETF	109.08	109.12	108.93	108.95	745400.0
2006-01-17 16:00:00	DIA	ETF	108.96	109.08	108.44	108.44	162300.0
2006-01-17 17:00:00	DIA	ETF	108.52	108.54	108.52	108.52	500.0
2006-01-17 19:00:00	DIA	ETF	108.52	108.52	108.3	108.3	4900.0
2006-01-17 07:00:00	GLD	ETF	55.26	55.26	55.25	55.25	5400.0
2006-01-17 08:00:00	GLD	ETF	55.3	55.44	55.03	55.03	61600.0
2006-01-17 09:00:00	GLD	ETF	55.02	55.32	54.97	55.28	1292500.0
2006-01-17 10:00:00	GLD	ETF	55.29	55.72	55.04	55.59	1034700.0

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

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