PREVIEW / etf_1hour / 2006-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-21.parquet
  size:    52 KB
  rows:    1,617

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-21 06:00:00	SPY	ETF	132.76	132.8	132.76	132.8	1900.0
2006-09-21 07:00:00	SPY	ETF	132.74	132.83	132.73	132.79	43700.0
2006-09-21 08:00:00	SPY	ETF	132.76	132.83	132.66	132.7	1024700.0
2006-09-21 09:00:00	SPY	ETF	132.7	132.74	132.37	132.39	7650200.0
2006-09-21 10:00:00	SPY	ETF	132.39	132.54	132.15	132.45	9073400.0
2006-09-21 11:00:00	SPY	ETF	132.44	132.75	132.44	132.599	8721300.0
2006-09-21 12:00:00	SPY	ETF	132.59	132.62	131.84	131.91	19431100.0
2006-09-21 13:00:00	SPY	ETF	131.91	132.03	131.7	131.94	10477300.0
2006-09-21 14:00:00	SPY	ETF	131.95	132.05	131.63	131.6601	10931100.0
2006-09-21 15:00:00	SPY	ETF	131.67	131.87	131.42	131.69	15650100.0
2006-09-21 16:00:00	SPY	ETF	131.71	132.4267	131.7	131.83	4262400.0
2006-09-21 17:00:00	SPY	ETF	131.88	131.89	131.85	131.88	6800.0
2006-09-21 18:00:00	SPY	ETF	131.88	131.9	131.81	131.83	14100.0
2006-09-21 19:00:00	SPY	ETF	131.87	131.87	131.87	131.87	500.0
2006-09-21 09:00:00	QQQ	ETF	40.52	40.64	40.44	40.48	14955000.0
2006-09-21 10:00:00	QQQ	ETF	40.48	40.57	40.31	40.5	20485800.0
2006-09-21 11:00:00	QQQ	ETF	40.5	40.67	40.49	40.53	11541800.0
2006-09-21 12:00:00	QQQ	ETF	40.54	40.55	40.25	40.32	20425500.0
2006-09-21 13:00:00	QQQ	ETF	40.31	40.38	40.2	40.3	11320400.0
2006-09-21 14:00:00	QQQ	ETF	40.3	40.34	40.14	40.15	12707800.0
2006-09-21 15:00:00	QQQ	ETF	40.16	40.22	40.08	40.17	23680100.0
2006-09-21 07:00:00	IWM	ETF	73.5	73.7	73.5	73.6	8600.0
2006-09-21 08:00:00	IWM	ETF	73.6	73.6	73.29	73.49	255200.0
2006-09-21 09:00:00	IWM	ETF	73.49	73.5	72.99	72.99	4511200.0
2006-09-21 10:00:00	IWM	ETF	72.98	73.3	72.72	73.06	7163300.0
2006-09-21 11:00:00	IWM	ETF	73.04	73.57	73.04	73.41	9223500.0
2006-09-21 12:00:00	IWM	ETF	73.42	73.45	72.5	72.57	12437700.0
2006-09-21 13:00:00	IWM	ETF	72.57	73.0	72.35	72.57	8214300.0
2006-09-21 14:00:00	IWM	ETF	72.59	73.34	72.22	72.25	6817800.0
2006-09-21 15:00:00	IWM	ETF	72.25	72.49	72.09	72.37	9901100.0
2006-09-21 16:00:00	IWM	ETF	72.35	72.5	72.35	72.5	256300.0
2006-09-21 17:00:00	IWM	ETF	72.5	72.51	72.5	72.5	5008600.0
2006-09-21 18:00:00	IWM	ETF	72.44	72.44	72.43	72.43	5100.0
2006-09-21 07:00:00	DIA	ETF	116.29	116.29	116.29	116.29	2000.0
2006-09-21 08:00:00	DIA	ETF	116.31	116.31	116.19	116.22	38200.0
2006-09-21 09:00:00	DIA	ETF	116.23	116.23	115.93	115.94	523100.0
2006-09-21 10:00:00	DIA	ETF	115.94	116.03	115.8	115.98	846100.0
2006-09-21 11:00:00	DIA	ETF	115.97	116.2	115.93	116.08	591600.0
2006-09-21 12:00:00	DIA	ETF	116.09	116.11	115.27	115.31	3152200.0
2006-09-21 13:00:00	DIA	ETF	115.31	115.43	115.19	115.38	582900.0
2006-09-21 14:00:00	DIA	ETF	115.4	115.43	115.08	115.1	696000.0
2006-09-21 15:00:00	DIA	ETF	115.1	115.27	114.95	115.27	1954600.0
2006-09-21 16:00:00	DIA	ETF	115.26	115.38	115.26	115.38	184100.0
2006-09-21 07:00:00	GLD	ETF	57.76	57.76	57.76	57.76	200.0
2006-09-21 08:00:00	GLD	ETF	57.75	57.9	57.42	57.42	86900.0
2006-09-21 09:00:00	GLD	ETF	57.41	57.55	57.27	57.38	340400.0
2006-09-21 10:00:00	GLD	ETF	57.36	57.62	57.22	57.42	728800.0
2006-09-21 11:00:00	GLD	ETF	57.45	57.86	57.45	57.79	613400.0
2006-09-21 12:00:00	GLD	ETF	57.79	58.08	57.67	57.92	911100.0
2006-09-21 13:00:00	GLD	ETF	57.91	57.98	57.78	57.97	358100.0

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

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