PREVIEW / etf_1hour / 2008-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-21.parquet
  size:    106 KB
  rows:    3,446

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
2008-08-21 04:00:00	SPY	ETF	126.81	127.14	126.81	127.14	32100.0
2008-08-21 06:00:00	SPY	ETF	127.0	127.19	127.0	127.1	179700.0
2008-08-21 07:00:00	SPY	ETF	127.05	127.23	126.87	126.9	746493.0
2008-08-21 08:00:00	SPY	ETF	126.9	127.24	126.7	126.77	3184404.0
2008-08-21 09:00:00	SPY	ETF	126.77	127.42	126.6	127.28	22022024.0
2008-08-21 10:00:00	SPY	ETF	127.28	127.63	126.84	127.15	38532812.0
2008-08-21 11:00:00	SPY	ETF	127.15	127.64	126.84	127.42	23673337.0
2008-08-21 12:00:00	SPY	ETF	127.42	127.69	127.23	127.42	15448926.0
2008-08-21 13:00:00	SPY	ETF	127.41	127.88	127.4	127.61	18261674.0
2008-08-21 14:00:00	SPY	ETF	127.61	128.36	127.52	128.15	23042269.0
2008-08-21 15:00:00	SPY	ETF	128.15	128.44	127.94	127.99	30924802.0
2008-08-21 16:00:00	SPY	ETF	127.96	128.2	127.8	127.8	3282150.0
2008-08-21 17:00:00	SPY	ETF	127.86	127.86	126.82	127.8	57384.0
2008-08-21 18:00:00	SPY	ETF	127.79	127.89	127.76	127.78	119780.0
2008-08-21 19:00:00	SPY	ETF	127.78	127.83	127.75	127.81	8403.0
2008-08-21 04:00:00	QQQ	ETF	46.77	46.77	46.77	46.77	200.0
2008-08-21 05:00:00	QQQ	ETF	46.74	46.77	46.73	46.77	10200.0
2008-08-21 06:00:00	QQQ	ETF	46.79	46.84	46.79	46.83	13500.0
2008-08-21 07:00:00	QQQ	ETF	46.81	46.92	46.74	46.79	336103.0
2008-08-21 08:00:00	QQQ	ETF	46.79	46.93	46.72	46.74	1080040.0
2008-08-21 09:00:00	QQQ	ETF	46.74	46.92	46.63	46.87	20243942.0
2008-08-21 10:00:00	QQQ	ETF	46.87	46.97	46.38	46.53	30577289.0
2008-08-21 11:00:00	QQQ	ETF	46.53	46.72	46.39	46.65	15954446.0
2008-08-21 12:00:00	QQQ	ETF	46.66	46.78	46.55	46.57	7229408.0
2008-08-21 13:00:00	QQQ	ETF	46.57	46.86	46.56	46.771	10680399.0
2008-08-21 14:00:00	QQQ	ETF	46.77	47.08	46.74	46.91	11810519.0
2008-08-21 15:00:00	QQQ	ETF	46.91	47.04	46.86	46.87	15973746.0
2008-08-21 16:00:00	QQQ	ETF	46.86	46.9487	46.7409	46.87	1583503.0
2008-08-21 17:00:00	QQQ	ETF	46.88	46.9	46.86	46.88	13416.0
2008-08-21 18:00:00	QQQ	ETF	46.86	46.86	46.84	46.84	11204.0
2008-08-21 19:00:00	QQQ	ETF	46.83	46.83	46.82	46.82	2700.0
2008-08-21 06:00:00	IWM	ETF	72.63	72.63	72.63	72.63	2000.0
2008-08-21 07:00:00	IWM	ETF	72.64	72.71	72.54	72.56	90849.0
2008-08-21 08:00:00	IWM	ETF	72.57	73.0	72.45	72.48	627576.0
2008-08-21 09:00:00	IWM	ETF	72.46	72.89	72.32	72.76	11015903.0
2008-08-21 10:00:00	IWM	ETF	72.76	73.0	72.08	72.28	18727444.0
2008-08-21 11:00:00	IWM	ETF	72.28	72.44	72.05	72.35	10735762.0
2008-08-21 12:00:00	IWM	ETF	72.36	72.59	72.18	72.3	4896860.0
2008-08-21 13:00:00	IWM	ETF	72.3	72.67	72.27	72.51	6723976.0
2008-08-21 14:00:00	IWM	ETF	72.5	72.87	72.45	72.65	6146198.0
2008-08-21 15:00:00	IWM	ETF	72.66	72.9	72.26	72.28	14247037.0
2008-08-21 16:00:00	IWM	ETF	72.28	73.02	72.15	72.2	6496023.0
2008-08-21 17:00:00	IWM	ETF	72.22	72.22	72.17	72.17	10500.0
2008-08-21 18:00:00	IWM	ETF	72.2	72.2	72.2	72.2	300.0
2008-08-21 07:00:00	DIA	ETF	113.64	113.8	113.45	113.45	6300.0
2008-08-21 08:00:00	DIA	ETF	113.44	113.88	113.27	113.36	139525.0
2008-08-21 09:00:00	DIA	ETF	113.3	113.79	113.07	113.71	2405109.0
2008-08-21 10:00:00	DIA	ETF	113.72	114.0	113.27	113.57	4875429.0
2008-08-21 11:00:00	DIA	ETF	113.56	113.97	113.25	113.71	2102194.0
2008-08-21 12:00:00	DIA	ETF	113.71	113.96	113.59	113.73	1078845.0

> showing 50 of 3,446 rows — these rows as CSV

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