PREVIEW / etf_1hour / 2013-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-30.parquet
  size:    202 KB
  rows:    6,291

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-04-30 04:00:00	SPY	ETF	159.11	159.11	159.1	159.1	300.0
2013-04-30 05:00:00	SPY	ETF	159.16	159.32	159.14	159.14	8000.0
2013-04-30 06:00:00	SPY	ETF	159.19	159.19	159.01	159.11	87400.0
2013-04-30 07:00:00	SPY	ETF	159.1	159.16	159.05	159.11	117108.0
2013-04-30 08:00:00	SPY	ETF	159.09	159.28	159.05	159.25	588191.0
2013-04-30 09:00:00	SPY	ETF	159.25	159.37	158.77	158.8	15449549.0
2013-04-30 10:00:00	SPY	ETF	158.81	159.21	158.61	159.15	24147117.0
2013-04-30 11:00:00	SPY	ETF	159.15	159.55	159.11	159.45	12495910.0
2013-04-30 12:00:00	SPY	ETF	159.46	159.64	159.3	159.615	8146330.0
2013-04-30 13:00:00	SPY	ETF	159.62	159.67	159.5	159.66	7428292.0
2013-04-30 14:00:00	SPY	ETF	159.66	159.67	159.32	159.6	10217853.0
2013-04-30 15:00:00	SPY	ETF	159.6	159.72	159.35	159.7	24745591.0
2013-04-30 16:00:00	SPY	ETF	159.71	159.83	158.7129	159.81	9570333.0
2013-04-30 17:00:00	SPY	ETF	159.82	159.87	159.78	159.83	264770.0
2013-04-30 18:00:00	SPY	ETF	159.83	159.83	159.68	159.74	99007.0
2013-04-30 19:00:00	SPY	ETF	159.74	159.84	159.74	159.75	43193.0
2013-04-30 04:00:00	QQQ	ETF	70.19	70.19	70.19	70.19	5600.0
2013-04-30 05:00:00	QQQ	ETF	70.23	70.23	70.19	70.19	3300.0
2013-04-30 06:00:00	QQQ	ETF	70.13	70.14	70.12	70.13	2200.0
2013-04-30 07:00:00	QQQ	ETF	70.16	70.19	70.16	70.16	14595.0
2013-04-30 08:00:00	QQQ	ETF	70.17	70.23	70.13	70.22	69011.0
2013-04-30 09:00:00	QQQ	ETF	70.22	70.33	70.07	70.12	4737213.0
2013-04-30 10:00:00	QQQ	ETF	70.12	70.42	70.04	70.35	5662273.0
2013-04-30 11:00:00	QQQ	ETF	70.35	70.54	70.32	70.49	3080083.0
2013-04-30 12:00:00	QQQ	ETF	70.49	70.69	70.43	70.67	3021507.0
2013-04-30 13:00:00	QQQ	ETF	70.67	70.73	70.62	70.69	1712447.0
2013-04-30 14:00:00	QQQ	ETF	70.69	70.71	70.54	70.71	1773531.0
2013-04-30 15:00:00	QQQ	ETF	70.71	70.72	70.56	70.72	4468387.0
2013-04-30 16:00:00	QQQ	ETF	70.73	70.76	70.2166	70.76	4801083.0
2013-04-30 17:00:00	QQQ	ETF	70.74	70.77	70.72	70.75	23309.0
2013-04-30 18:00:00	QQQ	ETF	70.73	70.76	70.73	70.73	4900.0
2013-04-30 19:00:00	QQQ	ETF	70.73	70.77	70.73	70.77	6020.0
2013-04-30 07:00:00	IWM	ETF	93.55	93.56	93.52	93.56	6500.0
2013-04-30 08:00:00	IWM	ETF	93.52	93.62	93.48	93.61	71787.0
2013-04-30 09:00:00	IWM	ETF	93.6	93.74	93.25	93.29	4103363.0
2013-04-30 10:00:00	IWM	ETF	93.28	93.74	93.17	93.63	5962521.0
2013-04-30 11:00:00	IWM	ETF	93.62	93.9751	93.6	93.9	1898940.0
2013-04-30 12:00:00	IWM	ETF	93.9	94.109	93.7999	94.09	1658184.0
2013-04-30 13:00:00	IWM	ETF	94.1	94.1	93.91	93.985	898223.0
2013-04-30 14:00:00	IWM	ETF	93.98	93.98	93.77	93.955	3798522.0
2013-04-30 15:00:00	IWM	ETF	93.95	94.11	93.82	94.1	7029307.0
2013-04-30 16:00:00	IWM	ETF	94.1	94.27	93.748	94.24	1681675.0
2013-04-30 17:00:00	IWM	ETF	94.25	94.28	94.25	94.25	60910.0
2013-04-30 18:00:00	IWM	ETF	94.25	94.25	94.19	94.19	4803.0
2013-04-30 19:00:00	IWM	ETF	94.2	94.24	94.2	94.24	5365.0
2013-04-30 07:00:00	DIA	ETF	147.77	147.77	147.74	147.74	350.0
2013-04-30 08:00:00	DIA	ETF	147.69	147.78	147.69	147.76	15360.0
2013-04-30 09:00:00	DIA	ETF	147.76	147.87	147.21	147.27	638145.0
2013-04-30 10:00:00	DIA	ETF	147.28	147.68	147.049	147.55	795967.0
2013-04-30 11:00:00	DIA	ETF	147.55	147.89	147.53	147.83	348026.0

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

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