PREVIEW / etf_1hour / 2006-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-26.parquet
  size:    54 KB
  rows:    1,686

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-09-26 07:00:00	SPY	ETF	132.45	132.49	132.4	132.46	42400.0
2006-09-26 08:00:00	SPY	ETF	132.43	132.62	132.41	132.59	381400.0
2006-09-26 09:00:00	SPY	ETF	132.59	132.64	132.4	132.59	5399700.0
2006-09-26 10:00:00	SPY	ETF	132.6	133.24	132.56	132.95	20744600.0
2006-09-26 11:00:00	SPY	ETF	132.94	133.21	132.71	132.71	7845600.0
2006-09-26 12:00:00	SPY	ETF	132.7	133.18	132.69	133.02	7782500.0
2006-09-26 13:00:00	SPY	ETF	133.01	133.35	132.89	133.25	6489000.0
2006-09-26 14:00:00	SPY	ETF	133.25	133.43	133.01	133.35	7917400.0
2006-09-26 15:00:00	SPY	ETF	133.35	133.59	133.23	133.54	10536300.0
2006-09-26 16:00:00	SPY	ETF	133.53	133.61	133.44	133.47	1653100.0
2006-09-26 17:00:00	SPY	ETF	133.45	133.57	133.45	133.57	551800.0
2006-09-26 18:00:00	SPY	ETF	133.53	133.53	133.45	133.46	4400.0
2006-09-26 19:00:00	SPY	ETF	133.5	133.51	133.47	133.47	3000.0
2006-09-26 09:00:00	QQQ	ETF	40.51	40.59	40.43	40.56	10904900.0
2006-09-26 10:00:00	QQQ	ETF	40.56	40.8	40.51	40.58	28794600.0
2006-09-26 11:00:00	QQQ	ETF	40.58	40.66	40.41	40.41	14885700.0
2006-09-26 12:00:00	QQQ	ETF	40.41	40.59	40.4	40.53	10014000.0
2006-09-26 13:00:00	QQQ	ETF	40.52	40.73	40.47	40.67	10197700.0
2006-09-26 14:00:00	QQQ	ETF	40.67	40.77	40.56	40.72	15649900.0
2006-09-26 15:00:00	QQQ	ETF	40.72	40.79	40.66	40.76	13597500.0
2006-09-26 07:00:00	IWM	ETF	72.2	72.2	72.2	72.2	2000.0
2006-09-26 08:00:00	IWM	ETF	72.21	72.31	72.21	72.3	78100.0
2006-09-26 09:00:00	IWM	ETF	72.27	72.37	71.96	72.13	3473900.0
2006-09-26 10:00:00	IWM	ETF	72.13	72.75	72.13	72.36	14177800.0
2006-09-26 11:00:00	IWM	ETF	72.36	72.56	72.04	72.04	4400000.0
2006-09-26 12:00:00	IWM	ETF	72.02	72.28	71.98	72.19	4239000.0
2006-09-26 13:00:00	IWM	ETF	72.18	72.48	72.07	72.41	2959300.0
2006-09-26 14:00:00	IWM	ETF	72.43	72.57	72.18	72.49	3061000.0
2006-09-26 15:00:00	IWM	ETF	72.5	72.53	72.33	72.42	5395700.0
2006-09-26 16:00:00	IWM	ETF	72.42	72.49	72.37	72.4	912500.0
2006-09-26 17:00:00	IWM	ETF	72.37	72.41	72.35	72.41	40200.0
2006-09-26 18:00:00	IWM	ETF	72.39	72.39	72.39	72.39	200.0
2006-09-26 19:00:00	IWM	ETF	72.34	72.34	72.34	72.34	1000.0
2006-09-26 08:00:00	DIA	ETF	115.58	115.72	115.58	115.71	31100.0
2006-09-26 09:00:00	DIA	ETF	115.68	115.86	115.56	115.86	519000.0
2006-09-26 10:00:00	DIA	ETF	115.86	116.33	115.81	116.08	1165600.0
2006-09-26 11:00:00	DIA	ETF	116.08	116.25	115.83	115.84	674400.0
2006-09-26 12:00:00	DIA	ETF	115.83	116.17	115.81	116.08	498000.0
2006-09-26 13:00:00	DIA	ETF	116.06	116.4299	115.98	116.35	532500.0
2006-09-26 14:00:00	DIA	ETF	116.37	116.53	116.18	116.5	904000.0
2006-09-26 15:00:00	DIA	ETF	116.51	116.6	116.39	116.58	1231900.0
2006-09-26 16:00:00	DIA	ETF	116.57	116.64	116.51	116.51	36500.0
2006-09-26 17:00:00	DIA	ETF	116.5	116.5	116.5	116.5	300.0
2006-09-26 18:00:00	DIA	ETF	116.53	116.53	116.53	116.53	400.0
2006-09-26 07:00:00	GLD	ETF	58.33	58.38	58.3	58.3	3000.0
2006-09-26 08:00:00	GLD	ETF	58.33	58.35	58.2	58.22	36500.0
2006-09-26 09:00:00	GLD	ETF	58.28	58.56	58.28	58.3202	429000.0
2006-09-26 10:00:00	GLD	ETF	58.3	58.66	58.25	58.5526	672100.0
2006-09-26 11:00:00	GLD	ETF	58.55	58.86	58.49	58.76	621300.0
2006-09-26 12:00:00	GLD	ETF	58.75	58.97	58.67	58.83	401600.0

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

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