PREVIEW / etf_1hour / 2014-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-31.parquet
  size:    226 KB
  rows:    7,078

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-01-31 04:00:00	SPY	ETF	178.28	178.34	177.72	177.82	90683.0
2014-01-31 05:00:00	SPY	ETF	177.84	177.84	177.32	177.58	223139.0
2014-01-31 06:00:00	SPY	ETF	177.61	177.79	176.87	177.0	609854.0
2014-01-31 07:00:00	SPY	ETF	176.98	177.66	176.93	177.22	1166358.0
2014-01-31 08:00:00	SPY	ETF	177.54	177.62	176.57	176.88	5330930.0
2014-01-31 09:00:00	SPY	ETF	176.88	177.71	176.79	177.42	24463654.0
2014-01-31 10:00:00	SPY	ETF	177.4	178.13	177.25	177.89	27826272.0
2014-01-31 11:00:00	SPY	ETF	177.88	178.68	177.79	178.5805	18690844.0
2014-01-31 12:00:00	SPY	ETF	178.59	178.86	178.22	178.539	14925707.0
2014-01-31 13:00:00	SPY	ETF	178.54	179.045	178.22	179.04	11939303.0
2014-01-31 14:00:00	SPY	ETF	179.04	179.29	178.85	178.92	16364465.0
2014-01-31 15:00:00	SPY	ETF	178.92	178.92	177.93	178.1	47520788.0
2014-01-31 16:00:00	SPY	ETF	178.1	179.3143	177.52	178.11	19670880.0
2014-01-31 17:00:00	SPY	ETF	178.13	178.18	178.08	178.09	168722.0
2014-01-31 18:00:00	SPY	ETF	178.13	178.16	178.07	178.12	50188.0
2014-01-31 19:00:00	SPY	ETF	178.12	178.18	178.1	178.1	52415.0
2014-01-31 04:00:00	QQQ	ETF	86.1	86.14	86.09	86.09	29900.0
2014-01-31 05:00:00	QQQ	ETF	85.87	85.87	85.62	85.67	400.0
2014-01-31 06:00:00	QQQ	ETF	85.75	85.86	85.44	85.51	56300.0
2014-01-31 07:00:00	QQQ	ETF	85.46	85.74	85.45	85.68	327952.0
2014-01-31 08:00:00	QQQ	ETF	85.64	85.7	85.4	85.56	1108872.0
2014-01-31 09:00:00	QQQ	ETF	85.55	85.84	85.45	85.72	6929232.0
2014-01-31 10:00:00	QQQ	ETF	85.73	86.02	85.59	85.87	6764922.0
2014-01-31 11:00:00	QQQ	ETF	85.88	86.23	85.83	86.23	3682315.0
2014-01-31 12:00:00	QQQ	ETF	86.225	86.431	86.16	86.35	3249784.0
2014-01-31 13:00:00	QQQ	ETF	86.35	86.57	86.17	86.57	3915952.0
2014-01-31 14:00:00	QQQ	ETF	86.575	86.68	86.43	86.47	3642956.0
2014-01-31 15:00:00	QQQ	ETF	86.47	86.47	86.1204	86.23	6752520.0
2014-01-31 16:00:00	QQQ	ETF	86.22	86.5036	85.734	86.26	5626711.0
2014-01-31 17:00:00	QQQ	ETF	86.49	86.49	86.25	86.26	50908.0
2014-01-31 18:00:00	QQQ	ETF	86.27	86.27	86.24	86.24	6062.0
2014-01-31 19:00:00	QQQ	ETF	86.27	86.27	86.24	86.24	1114.0
2014-01-31 04:00:00	IWM	ETF	112.45	112.45	112.06	112.07	1149.0
2014-01-31 05:00:00	IWM	ETF	111.67	111.67	111.67	111.67	100.0
2014-01-31 06:00:00	IWM	ETF	111.53	111.53	111.29	111.29	400.0
2014-01-31 07:00:00	IWM	ETF	111.18	111.78	111.18	111.36	142100.0
2014-01-31 08:00:00	IWM	ETF	111.39	111.48	111.03	111.11	433527.0
2014-01-31 09:00:00	IWM	ETF	111.1	112.249	111.08	111.92	6581677.0
2014-01-31 10:00:00	IWM	ETF	111.935	112.42	111.75	112.26	6302397.0
2014-01-31 11:00:00	IWM	ETF	112.26	112.68	112.13	112.61	4756422.0
2014-01-31 12:00:00	IWM	ETF	112.61	112.86	112.44	112.528	2910196.0
2014-01-31 13:00:00	IWM	ETF	112.52	112.79	112.27	112.7699	3031304.0
2014-01-31 14:00:00	IWM	ETF	112.76	113.0	112.49	112.81	5530162.0
2014-01-31 15:00:00	IWM	ETF	112.81	112.81	112.04	112.15	11477196.0
2014-01-31 16:00:00	IWM	ETF	112.15	113.0821	112.03	112.04	4377905.0
2014-01-31 17:00:00	IWM	ETF	112.04	112.1	112.02	112.1	16981.0
2014-01-31 18:00:00	IWM	ETF	112.14	112.14	112.09	112.09	400.0
2014-01-31 19:00:00	IWM	ETF	112.36	112.36	112.09	112.09	900.0
2014-01-31 04:00:00	DIA	ETF	157.34	157.34	157.34	157.34	100.0
2014-01-31 06:00:00	DIA	ETF	156.65	156.65	156.28	156.4	933.0

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

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