PREVIEW / etf_1hour / 2014-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-22.parquet
  size:    238 KB
  rows:    7,632

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
2014-12-22 04:00:00	SPY	ETF	207.12	207.23	207.08	207.1	35429.0
2014-12-22 05:00:00	SPY	ETF	207.0	207.02	207.0	207.02	300.0
2014-12-22 06:00:00	SPY	ETF	207.05	207.13	206.94	207.08	15210.0
2014-12-22 07:00:00	SPY	ETF	206.9	206.99	206.8	206.93	75214.0
2014-12-22 08:00:00	SPY	ETF	206.93	207.11	206.12	206.95	757713.0
2014-12-22 09:00:00	SPY	ETF	206.94	207.04	206.51	206.73	12648437.0
2014-12-22 10:00:00	SPY	ETF	206.75	207.02	206.51	206.78	19771442.0
2014-12-22 11:00:00	SPY	ETF	206.76	206.86	206.46	206.6353	14728120.0
2014-12-22 12:00:00	SPY	ETF	206.63	206.9	206.53	206.825	8097974.0
2014-12-22 13:00:00	SPY	ETF	206.83	207.01	206.8	207.0	10673123.0
2014-12-22 14:00:00	SPY	ETF	207.01	207.17	206.87	206.995	15994799.0
2014-12-22 15:00:00	SPY	ETF	207.0	207.47	207.0	207.45	29593278.0
2014-12-22 16:00:00	SPY	ETF	207.45	207.56	206.4838	207.23	11756171.0
2014-12-22 17:00:00	SPY	ETF	207.23	207.47	207.22	207.33	12267514.0
2014-12-22 18:00:00	SPY	ETF	207.34	207.36	207.22	207.33	57138.0
2014-12-22 19:00:00	SPY	ETF	207.33	207.38	207.26	207.38	81772.0
2014-12-22 04:00:00	QQQ	ETF	104.44	104.51	104.44	104.45	12850.0
2014-12-22 06:00:00	QQQ	ETF	104.56	104.57	104.55	104.57	800.0
2014-12-22 07:00:00	QQQ	ETF	104.49	104.49	104.4	104.4	16450.0
2014-12-22 08:00:00	QQQ	ETF	104.34	104.77	103.84	104.24	163078.0
2014-12-22 09:00:00	QQQ	ETF	104.3	104.55	104.06	104.38	4607612.0
2014-12-22 10:00:00	QQQ	ETF	104.38	104.59	104.33	104.41	5615636.0
2014-12-22 11:00:00	QQQ	ETF	104.4	104.47	104.19	104.308	2421674.0
2014-12-22 12:00:00	QQQ	ETF	104.3	104.55	104.25	104.54	2912214.0
2014-12-22 13:00:00	QQQ	ETF	104.54	104.61	104.41	104.57	3223727.0
2014-12-22 14:00:00	QQQ	ETF	104.57	104.57	104.36	104.36	2691414.0
2014-12-22 15:00:00	QQQ	ETF	104.37	104.59	104.37	104.56	3505316.0
2014-12-22 16:00:00	QQQ	ETF	104.57	104.58	104.2714	104.49	1163096.0
2014-12-22 17:00:00	QQQ	ETF	104.52	104.52	104.52	104.52	200.0
2014-12-22 18:00:00	QQQ	ETF	104.5	104.5	104.46	104.47	7495.0
2014-12-22 19:00:00	QQQ	ETF	104.51	104.52	104.49	104.52	8100.0
2014-12-22 07:00:00	IWM	ETF	119.36	119.36	119.2	119.3	6500.0
2014-12-22 08:00:00	IWM	ETF	119.29	119.4	119.11	119.2	69789.0
2014-12-22 09:00:00	IWM	ETF	119.2	119.43	118.92	119.39	3051555.0
2014-12-22 10:00:00	IWM	ETF	119.39	119.52	119.03	119.11	3328801.0
2014-12-22 11:00:00	IWM	ETF	119.11	119.151	118.82	118.87	2707565.0
2014-12-22 12:00:00	IWM	ETF	118.87	119.28	118.8035	119.26	2073426.0
2014-12-22 13:00:00	IWM	ETF	119.26	119.37	119.11	119.37	1522891.0
2014-12-22 14:00:00	IWM	ETF	119.37	119.51	119.26	119.435	2263443.0
2014-12-22 15:00:00	IWM	ETF	119.44	119.7	119.41	119.69	5485956.0
2014-12-22 16:00:00	IWM	ETF	119.69	119.82	119.1965	119.65	1165757.0
2014-12-22 17:00:00	IWM	ETF	119.63	119.7	119.62	119.62	20281.0
2014-12-22 18:00:00	IWM	ETF	119.67	119.67	119.67	119.67	600.0
2014-12-22 19:00:00	IWM	ETF	119.67	119.67	119.67	119.67	100.0
2014-12-22 07:00:00	DIA	ETF	178.04	178.04	178.04	178.04	100.0
2014-12-22 08:00:00	DIA	ETF	178.1	178.2	178.0	178.1	2900.0
2014-12-22 09:00:00	DIA	ETF	178.22	178.7	178.02	178.499	1053388.0
2014-12-22 10:00:00	DIA	ETF	178.48	178.83	178.25	178.59	1358992.0
2014-12-22 11:00:00	DIA	ETF	178.56	178.74	178.36	178.6001	580633.0
2014-12-22 12:00:00	DIA	ETF	178.6	178.8	178.47	178.75	897737.0

> showing 50 of 7,632 rows — these rows as CSV

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