PREVIEW / etf_1hour / 2013-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-23.parquet
  size:    198 KB
  rows:    6,225

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
2013-01-23 04:00:00	SPY	ETF	149.21	149.21	148.94	149.2	10184.0
2013-01-23 05:00:00	SPY	ETF	149.18	149.22	149.14	149.17	22220.0
2013-01-23 06:00:00	SPY	ETF	149.17	149.18	149.14	149.17	28938.0
2013-01-23 07:00:00	SPY	ETF	149.16	149.3	149.14	149.14	168926.0
2013-01-23 08:00:00	SPY	ETF	149.14	149.3	149.01	149.09	664557.0
2013-01-23 09:00:00	SPY	ETF	149.09	149.24	149.02	149.13	10004333.0
2013-01-23 10:00:00	SPY	ETF	149.118	149.33	148.86	149.007	14874644.0
2013-01-23 11:00:00	SPY	ETF	149.01	149.16	148.94	149.09	10839636.0
2013-01-23 12:00:00	SPY	ETF	149.0901	149.23	149.04	149.225	7970292.0
2013-01-23 13:00:00	SPY	ETF	149.221	149.33	149.2	149.3001	6551048.0
2013-01-23 14:00:00	SPY	ETF	149.31	149.49	149.23	149.47	10591844.0
2013-01-23 15:00:00	SPY	ETF	149.47	149.5	149.24	149.37	18617603.0
2013-01-23 16:00:00	SPY	ETF	149.36	149.59	148.91	148.92	17461585.0
2013-01-23 17:00:00	SPY	ETF	148.95	149.0	148.65	148.71	927108.0
2013-01-23 18:00:00	SPY	ETF	148.74	148.86	148.71	148.85	131432.0
2013-01-23 19:00:00	SPY	ETF	148.81	148.91	148.78	148.79	178023.0
2013-01-23 07:00:00	QQQ	ETF	67.55	67.58	67.52	67.53	55326.0
2013-01-23 08:00:00	QQQ	ETF	67.52	67.58	67.45	67.57	315524.0
2013-01-23 09:00:00	QQQ	ETF	67.56	67.65	67.46	67.62	3292568.0
2013-01-23 10:00:00	QQQ	ETF	67.62	67.79	67.5	67.5896	5641077.0
2013-01-23 11:00:00	QQQ	ETF	67.58	67.66	67.52	67.56	3229666.0
2013-01-23 12:00:00	QQQ	ETF	67.55	67.6	67.4899	67.6	2595533.0
2013-01-23 13:00:00	QQQ	ETF	67.61	67.67	67.5799	67.62	1909047.0
2013-01-23 14:00:00	QQQ	ETF	67.62	67.71	67.549	67.69	1962956.0
2013-01-23 15:00:00	QQQ	ETF	67.69	67.7201	67.58	67.59	5166303.0
2013-01-23 16:00:00	QQQ	ETF	67.59	67.93	67.0	67.0	3674618.0
2013-01-23 17:00:00	QQQ	ETF	67.0	67.01	66.49	66.49	726361.0
2013-01-23 18:00:00	QQQ	ETF	66.55	66.6	66.37	66.56	1046059.0
2013-01-23 19:00:00	QQQ	ETF	66.56	66.6	66.53	66.58	61608.0
2013-01-23 07:00:00	IWM	ETF	89.33	89.35	89.28	89.32	22600.0
2013-01-23 08:00:00	IWM	ETF	89.29	89.29	89.21	89.22	38183.0
2013-01-23 09:00:00	IWM	ETF	89.2	89.285	89.09	89.24	2754144.0
2013-01-23 10:00:00	IWM	ETF	89.24	89.25	89.01	89.07	5678362.0
2013-01-23 11:00:00	IWM	ETF	89.08	89.23	89.03	89.11	3289265.0
2013-01-23 12:00:00	IWM	ETF	89.1	89.165	88.99	89.1038	2446291.0
2013-01-23 13:00:00	IWM	ETF	89.11	89.16	89.0399	89.1269	2456059.0
2013-01-23 14:00:00	IWM	ETF	89.1201	89.18	89.04	89.13	2042121.0
2013-01-23 15:00:00	IWM	ETF	89.13	89.18	88.91	88.99	6491659.0
2013-01-23 16:00:00	IWM	ETF	89.0	89.2499	88.82	88.83	1591943.0
2013-01-23 17:00:00	IWM	ETF	88.85	89.2499	88.65	88.73	548877.0
2013-01-23 18:00:00	IWM	ETF	88.7	88.7	88.64	88.7	13451.0
2013-01-23 19:00:00	IWM	ETF	88.7	88.7	88.64	88.64	12584.0
2013-01-23 07:00:00	DIA	ETF	137.3	137.3	137.23	137.3	900.0
2013-01-23 08:00:00	DIA	ETF	137.18	137.22	137.14	137.18	9200.0
2013-01-23 09:00:00	DIA	ETF	137.13	137.45	137.1	137.38	701587.0
2013-01-23 10:00:00	DIA	ETF	137.4	137.55	137.21	137.3103	823895.0
2013-01-23 11:00:00	DIA	ETF	137.32	137.42	137.2	137.37	395549.0
2013-01-23 12:00:00	DIA	ETF	137.36	137.48	137.3	137.48	284315.0
2013-01-23 13:00:00	DIA	ETF	137.48	137.55	137.45	137.51	298909.0
2013-01-23 14:00:00	DIA	ETF	137.52	137.61	137.42	137.591	272695.0

> showing 50 of 6,225 rows — these rows as CSV

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