PREVIEW / etf_1hour / 2006-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-10.parquet
  size:    38 KB
  rows:    1,203

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-10 07:00:00	SPY	ETF	128.43	128.47	128.4	128.41	63800.0
2006-01-10 08:00:00	SPY	ETF	128.4	128.44	128.3	128.34	849500.0
2006-01-10 09:00:00	SPY	ETF	128.35	128.54	128.24	128.4	6938200.0
2006-01-10 10:00:00	SPY	ETF	128.3901	128.66	128.38	128.51	6366700.0
2006-01-10 11:00:00	SPY	ETF	128.48	128.67	128.31	128.56	5123100.0
2006-01-10 12:00:00	SPY	ETF	128.55	128.75	128.54	128.64	3720100.0
2006-01-10 13:00:00	SPY	ETF	128.64	128.97	128.63	128.69	6402400.0
2006-01-10 14:00:00	SPY	ETF	128.69	128.79	128.43	128.55	4862000.0
2006-01-10 15:00:00	SPY	ETF	128.55	128.92	128.48	128.88	6506500.0
2006-01-10 16:00:00	SPY	ETF	128.9	128.95	128.84	128.9	600000.0
2006-01-10 17:00:00	SPY	ETF	128.9	128.92	128.86	128.92	12900.0
2006-01-10 18:00:00	SPY	ETF	128.9	128.9	128.84	128.84	3600.0
2006-01-10 19:00:00	SPY	ETF	128.85	128.85	128.83	128.83	1000.0
2006-01-10 09:00:00	QQQ	ETF	42.63	42.7	42.55	42.59	13562500.0
2006-01-10 10:00:00	QQQ	ETF	42.59	42.76	42.59	42.65	12265200.0
2006-01-10 11:00:00	QQQ	ETF	42.64	42.74	42.55	42.69	8353000.0
2006-01-10 12:00:00	QQQ	ETF	42.69	42.83	42.69	42.77	7481400.0
2006-01-10 13:00:00	QQQ	ETF	42.77	42.92	42.71	42.71	9368900.0
2006-01-10 14:00:00	QQQ	ETF	42.72	42.76	42.6	42.64	9685600.0
2006-01-10 15:00:00	QQQ	ETF	42.65	42.88	42.59	42.88	14428800.0
2006-01-10 07:00:00	IWM	ETF	69.76	69.76	69.76	69.76	2500.0
2006-01-10 08:00:00	IWM	ETF	69.81	69.81	69.67	69.74	49000.0
2006-01-10 09:00:00	IWM	ETF	69.7	69.97	69.67	69.94	2818100.0
2006-01-10 10:00:00	IWM	ETF	69.95	70.39	69.93	70.1601	5659300.0
2006-01-10 11:00:00	IWM	ETF	70.18	70.42	69.99	70.34	2709000.0
2006-01-10 12:00:00	IWM	ETF	70.33	70.55	70.33	70.43	2117200.0
2006-01-10 13:00:00	IWM	ETF	70.43	70.63	70.39	70.52	2005100.0
2006-01-10 14:00:00	IWM	ETF	70.51	70.57	70.26	70.43	4364600.0
2006-01-10 15:00:00	IWM	ETF	70.43	70.66	70.35	70.55	3975500.0
2006-01-10 16:00:00	IWM	ETF	70.54	70.63	70.52	70.53	398800.0
2006-01-10 17:00:00	IWM	ETF	70.55	70.73	70.55	70.73	500.0
2006-01-10 07:00:00	DIA	ETF	109.7	109.7	109.67	109.67	200.0
2006-01-10 08:00:00	DIA	ETF	109.66	109.7	109.54	109.62	43400.0
2006-01-10 09:00:00	DIA	ETF	109.6	109.7	109.47	109.55	1380100.0
2006-01-10 10:00:00	DIA	ETF	109.57	109.83	109.54	109.73	1023500.0
2006-01-10 11:00:00	DIA	ETF	109.73	109.9	109.59	109.81	638400.0
2006-01-10 12:00:00	DIA	ETF	109.81	109.95	109.75	109.8601	1184200.0
2006-01-10 13:00:00	DIA	ETF	109.87	110.13	109.83	109.92	388900.0
2006-01-10 14:00:00	DIA	ETF	109.91	109.92	109.67	109.78	410600.0
2006-01-10 15:00:00	DIA	ETF	109.81	110.11	109.75	110.08	765500.0
2006-01-10 16:00:00	DIA	ETF	110.09	110.13	110.06	110.06	523700.0
2006-01-10 07:00:00	GLD	ETF	54.07	54.07	54.07	54.07	5000.0
2006-01-10 08:00:00	GLD	ETF	54.06	54.19	53.9	54.07	191400.0
2006-01-10 09:00:00	GLD	ETF	54.04	54.72	53.93	54.31	1242100.0
2006-01-10 10:00:00	GLD	ETF	54.3	54.32	53.77	53.92	1090100.0
2006-01-10 11:00:00	GLD	ETF	53.92	54.09	53.76	53.88	701700.0
2006-01-10 12:00:00	GLD	ETF	53.88	54.25	53.88	54.0	625900.0
2006-01-10 13:00:00	GLD	ETF	54.03	54.29	54.0	54.24	599600.0
2006-01-10 14:00:00	GLD	ETF	54.23	54.25	54.02	54.09	219400.0
2006-01-10 15:00:00	GLD	ETF	54.08	54.13	53.99	54.09	357800.0

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

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