PREVIEW / etf_1hour / 2008-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-21.parquet
  size:    104 KB
  rows:    3,360

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-04-21 06:00:00	SPY	ETF	138.59	138.59	138.48	138.48	5100.0
2008-04-21 07:00:00	SPY	ETF	138.44	138.48	138.04	138.33	827397.0
2008-04-21 08:00:00	SPY	ETF	138.33	138.95	138.25	138.35	1248905.0
2008-04-21 09:00:00	SPY	ETF	138.35	138.65	138.07	138.46	13997937.0
2008-04-21 10:00:00	SPY	ETF	138.47	138.47	137.87	137.91	21518265.0
2008-04-21 11:00:00	SPY	ETF	137.91	138.45	136.87	138.36	16509724.0
2008-04-21 12:00:00	SPY	ETF	138.35	138.43	138.23	138.36	8944153.0
2008-04-21 13:00:00	SPY	ETF	138.36	138.6	138.15	138.26	12740541.0
2008-04-21 14:00:00	SPY	ETF	138.25	138.57	138.13	138.5	11413524.0
2008-04-21 15:00:00	SPY	ETF	138.49	138.98	138.48	138.79	20507227.0
2008-04-21 16:00:00	SPY	ETF	138.79	138.81	138.34	138.4	4918127.0
2008-04-21 17:00:00	SPY	ETF	138.42	138.42	138.23	138.3	131488.0
2008-04-21 18:00:00	SPY	ETF	138.3	138.33	138.22	138.33	12800.0
2008-04-21 19:00:00	SPY	ETF	138.3	138.31	138.25	138.25	7000.0
2008-04-21 05:00:00	QQQ	ETF	46.64	46.66	46.64	46.66	9500.0
2008-04-21 06:00:00	QQQ	ETF	46.57	46.59	46.51	46.52	5300.0
2008-04-21 07:00:00	QQQ	ETF	46.53	46.61	46.44	46.58	388119.0
2008-04-21 08:00:00	QQQ	ETF	46.59	46.83	46.56	46.58	514765.0
2008-04-21 09:00:00	QQQ	ETF	46.57	46.75	46.52	46.71	9162309.0
2008-04-21 10:00:00	QQQ	ETF	46.71	46.715	46.49	46.549	15929982.0
2008-04-21 11:00:00	QQQ	ETF	46.54	46.79	46.52	46.7519	10632407.0
2008-04-21 12:00:00	QQQ	ETF	46.76	46.83	46.73	46.78	6388726.0
2008-04-21 13:00:00	QQQ	ETF	46.79	46.9	46.67	46.74	8441246.0
2008-04-21 14:00:00	QQQ	ETF	46.73	46.96	46.66	46.91	7990959.0
2008-04-21 15:00:00	QQQ	ETF	46.9	47.08	46.9	47.04	13946360.0
2008-04-21 16:00:00	QQQ	ETF	47.03	47.07	46.7628	46.82	2956038.0
2008-04-21 17:00:00	QQQ	ETF	46.82	46.85	46.75	46.77	347815.0
2008-04-21 18:00:00	QQQ	ETF	46.77	47.04	46.75	46.79	4018420.0
2008-04-21 19:00:00	QQQ	ETF	46.79	46.79	46.74	46.74	93650.0
2008-04-21 07:00:00	IWM	ETF	71.5	71.5	71.3	71.42	33759.0
2008-04-21 08:00:00	IWM	ETF	71.54	71.63	71.29	71.37	2238519.0
2008-04-21 09:00:00	IWM	ETF	71.38	71.75	71.29	71.7	4113130.0
2008-04-21 10:00:00	IWM	ETF	71.69	71.69	71.26	71.37	5895998.0
2008-04-21 11:00:00	IWM	ETF	71.36	71.6	71.25	71.57	3191355.0
2008-04-21 12:00:00	IWM	ETF	71.57	71.6	71.38	71.41	3059119.0
2008-04-21 13:00:00	IWM	ETF	71.4	71.65	71.23	71.27	4647703.0
2008-04-21 14:00:00	IWM	ETF	71.28	71.58	71.24	71.51	3462861.0
2008-04-21 15:00:00	IWM	ETF	71.51	71.83	71.51	71.74	7415983.0
2008-04-21 16:00:00	IWM	ETF	71.73	71.78	71.41	71.42	4954995.0
2008-04-21 17:00:00	IWM	ETF	71.4	71.4	71.4	71.4	100.0
2008-04-21 18:00:00	IWM	ETF	71.37	71.4	71.37	71.4	4200.0
2008-04-21 07:00:00	DIA	ETF	127.77	127.91	127.58	127.91	42400.0
2008-04-21 08:00:00	DIA	ETF	127.85	127.92	127.73	127.87	74052.0
2008-04-21 09:00:00	DIA	ETF	127.86	127.97	127.64	127.88	1721209.0
2008-04-21 10:00:00	DIA	ETF	127.88	127.88	127.41	127.45	2200812.0
2008-04-21 11:00:00	DIA	ETF	127.45	127.93	127.42	127.87	1503970.0
2008-04-21 12:00:00	DIA	ETF	127.87	127.92	127.74	127.81	854853.0
2008-04-21 13:00:00	DIA	ETF	127.82	128.04	127.61	127.7	754133.0
2008-04-21 14:00:00	DIA	ETF	127.69	127.95	127.53	127.88	1261350.0
2008-04-21 15:00:00	DIA	ETF	127.87	128.34	127.87	128.11	2296748.0

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

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