PREVIEW / etf_1hour / 2006-09-29

all etf 1-hour files

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

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-29 07:00:00	SPY	ETF	133.93	133.93	133.9	133.92	5900.0
2006-09-29 08:00:00	SPY	ETF	133.93	134.06	133.79	133.98	1122700.0
2006-09-29 09:00:00	SPY	ETF	133.96	134.02	133.6	133.7	5476100.0
2006-09-29 10:00:00	SPY	ETF	133.71	133.94	133.65	133.77	9893400.0
2006-09-29 11:00:00	SPY	ETF	133.77	133.94	133.59	133.82	6141600.0
2006-09-29 12:00:00	SPY	ETF	133.82	133.8501	133.7	133.77	2595400.0
2006-09-29 13:00:00	SPY	ETF	133.77	133.88	133.66	133.76	3638800.0
2006-09-29 14:00:00	SPY	ETF	133.76	133.83	133.65	133.69	3798100.0
2006-09-29 15:00:00	SPY	ETF	133.68	133.7	133.48	133.48	8556500.0
2006-09-29 16:00:00	SPY	ETF	133.49	133.66	133.48	133.56	3834800.0
2006-09-29 17:00:00	SPY	ETF	133.57	133.64	133.55	133.61	17300.0
2006-09-29 18:00:00	SPY	ETF	133.61	133.61	133.55	133.55	25000.0
2006-09-29 19:00:00	SPY	ETF	133.55	133.67	133.55	133.67	2500.0
2006-09-29 09:00:00	QQQ	ETF	40.89	40.92	40.65	40.75	15503200.0
2006-09-29 10:00:00	QQQ	ETF	40.75	40.91	40.75	40.88	17498400.0
2006-09-29 11:00:00	QQQ	ETF	40.88	40.93	40.78	40.91	7044300.0
2006-09-29 12:00:00	QQQ	ETF	40.91	40.91	40.81	40.87	5752700.0
2006-09-29 13:00:00	QQQ	ETF	40.87	40.91	40.77	40.82	6034500.0
2006-09-29 14:00:00	QQQ	ETF	40.81	40.84	40.72	40.75	6539500.0
2006-09-29 15:00:00	QQQ	ETF	40.75	40.77	40.62	40.64	19504400.0
2006-09-29 08:00:00	IWM	ETF	72.82	72.9	72.79	72.9	40300.0
2006-09-29 09:00:00	IWM	ETF	72.88	72.99	72.56	72.71	4780500.0
2006-09-29 10:00:00	IWM	ETF	72.72	72.97	72.66	72.8	5221200.0
2006-09-29 11:00:00	IWM	ETF	72.8	72.85	72.6	72.8	2609400.0
2006-09-29 12:00:00	IWM	ETF	72.79	72.8	72.67	72.79	1548100.0
2006-09-29 13:00:00	IWM	ETF	72.78	72.85	72.62	72.67	1880200.0
2006-09-29 14:00:00	IWM	ETF	72.66	72.77	72.55	72.59	2927800.0
2006-09-29 15:00:00	IWM	ETF	72.58	72.7	71.99	71.99	11926500.0
2006-09-29 16:00:00	IWM	ETF	71.96	72.08	71.93	72.03	1101400.0
2006-09-29 17:00:00	IWM	ETF	72.01	72.01	72.01	72.01	2500.0
2006-09-29 18:00:00	IWM	ETF	72.0	72.03	72.0	72.0	400.0
2006-09-29 08:00:00	DIA	ETF	117.14	117.18	117.08	117.16	20800.0
2006-09-29 09:00:00	DIA	ETF	117.15	117.17	116.91	117.08	1401100.0
2006-09-29 10:00:00	DIA	ETF	117.1	117.33	117.0	117.09	1564600.0
2006-09-29 11:00:00	DIA	ETF	117.09	117.22	116.99	117.19	453100.0
2006-09-29 12:00:00	DIA	ETF	117.18	117.18	117.03	117.04	212800.0
2006-09-29 13:00:00	DIA	ETF	117.04	117.1	116.87	116.93	321400.0
2006-09-29 14:00:00	DIA	ETF	116.93	117.04	116.88	116.92	245500.0
2006-09-29 15:00:00	DIA	ETF	116.9	116.92	116.67	116.7	1907200.0
2006-09-29 16:00:00	DIA	ETF	116.71	116.83	116.65	116.67	177500.0
2006-09-29 17:00:00	DIA	ETF	116.7	116.7	116.7	116.7	500.0
2006-09-29 08:00:00	GLD	ETF	59.66	59.78	59.39	59.52	35200.0
2006-09-29 09:00:00	GLD	ETF	59.45	59.63	59.4	59.5109	245000.0
2006-09-29 10:00:00	GLD	ETF	59.51	59.56	59.1	59.1	559400.0
2006-09-29 11:00:00	GLD	ETF	59.1	59.28	58.975	59.25	908800.0
2006-09-29 12:00:00	GLD	ETF	59.25	59.44	59.1702	59.25	212600.0
2006-09-29 13:00:00	GLD	ETF	59.24	59.53	59.2	59.5	523500.0
2006-09-29 14:00:00	GLD	ETF	59.5	59.55	59.44	59.54	217600.0
2006-09-29 15:00:00	GLD	ETF	59.53	59.56	59.3724	59.4699	497100.0
2006-09-29 16:00:00	GLD	ETF	59.4628	59.5	59.46	59.46	600.0

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

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