PREVIEW / etf_1hour / 2014-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-25.parquet
  size:    229 KB
  rows:    7,254

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-09-25 04:00:00	SPY	ETF	199.43	199.56	199.37	199.37	5263.0
2014-09-25 05:00:00	SPY	ETF	199.42	199.44	199.37	199.4	43720.0
2014-09-25 06:00:00	SPY	ETF	199.38	199.52	199.31	199.49	25579.0
2014-09-25 07:00:00	SPY	ETF	199.48	199.6	199.44	199.49	110556.0
2014-09-25 08:00:00	SPY	ETF	199.49	199.49	198.94	199.02	1261510.0
2014-09-25 09:00:00	SPY	ETF	199.01	199.07	197.87	198.05	17368424.0
2014-09-25 10:00:00	SPY	ETF	198.05	198.12	196.66	197.19	33077669.0
2014-09-25 11:00:00	SPY	ETF	197.2	197.295	196.76	196.81	17286994.0
2014-09-25 12:00:00	SPY	ETF	196.81	197.08	196.42	196.68	12296596.0
2014-09-25 13:00:00	SPY	ETF	196.66	196.94	196.33	196.47	12253700.0
2014-09-25 14:00:00	SPY	ETF	196.46	196.939	196.32	196.67	13572875.0
2014-09-25 15:00:00	SPY	ETF	196.67	196.97	196.32	196.32	26598549.0
2014-09-25 16:00:00	SPY	ETF	196.31	196.959	196.25	196.59	11299310.0
2014-09-25 17:00:00	SPY	ETF	196.6	196.67	196.56	196.56	625189.0
2014-09-25 18:00:00	SPY	ETF	196.6	196.75	196.6	196.73	92313.0
2014-09-25 19:00:00	SPY	ETF	196.73	196.86	196.72	196.84	186322.0
2014-09-25 04:00:00	QQQ	ETF	99.85	99.85	99.85	99.85	5000.0
2014-09-25 05:00:00	QQQ	ETF	99.8	99.82	99.8	99.81	7600.0
2014-09-25 06:00:00	QQQ	ETF	99.77	99.83	99.75	99.83	2500.0
2014-09-25 07:00:00	QQQ	ETF	99.8	99.85	99.78	99.8	10159.0
2014-09-25 08:00:00	QQQ	ETF	99.84	99.84	99.5	99.55	359208.0
2014-09-25 09:00:00	QQQ	ETF	99.53	99.65	98.74	98.84	7135242.0
2014-09-25 10:00:00	QQQ	ETF	98.85	98.9	97.981	98.2699	12390468.0
2014-09-25 11:00:00	QQQ	ETF	98.27	98.27	97.93	97.95	10775672.0
2014-09-25 12:00:00	QQQ	ETF	97.96	98.16	97.79	97.94	7242094.0
2014-09-25 13:00:00	QQQ	ETF	97.93	98.15	97.72	97.83	5550912.0
2014-09-25 14:00:00	QQQ	ETF	97.82	98.059	97.7	97.89	5822924.0
2014-09-25 15:00:00	QQQ	ETF	97.885	98.09	97.75	97.75	7853800.0
2014-09-25 16:00:00	QQQ	ETF	97.75	98.0	97.725	97.9	1370039.0
2014-09-25 17:00:00	QQQ	ETF	97.9	99.8327	97.86	97.88	512172.0
2014-09-25 18:00:00	QQQ	ETF	97.9	97.99	97.9	97.99	45532.0
2014-09-25 19:00:00	QQQ	ETF	97.98	98.03	97.98	98.01	39431.0
2014-09-25 05:00:00	IWM	ETF	111.93	111.93	111.93	111.93	150.0
2014-09-25 06:00:00	IWM	ETF	111.93	111.93	111.93	111.93	100.0
2014-09-25 07:00:00	IWM	ETF	111.94	112.05	111.94	112.0	31900.0
2014-09-25 08:00:00	IWM	ETF	112.0	112.0	111.55	111.61	319436.0
2014-09-25 09:00:00	IWM	ETF	111.59	111.96	110.77	110.8999	5073482.0
2014-09-25 10:00:00	IWM	ETF	110.9	110.96	109.75	110.25	8639375.0
2014-09-25 11:00:00	IWM	ETF	110.241	110.48	109.92	110.27	4580390.0
2014-09-25 12:00:00	IWM	ETF	110.27	110.47	110.0599	110.41	2952788.0
2014-09-25 13:00:00	IWM	ETF	110.4	110.66	110.08	110.2	2872597.0
2014-09-25 14:00:00	IWM	ETF	110.195	110.56	110.1	110.395	2157086.0
2014-09-25 15:00:00	IWM	ETF	110.4	110.45	110.15	110.17	6603881.0
2014-09-25 16:00:00	IWM	ETF	110.17	111.958	110.13	110.37	8214592.0
2014-09-25 17:00:00	IWM	ETF	110.39	110.43	110.05	110.41	6550.0
2014-09-25 18:00:00	IWM	ETF	110.4	110.45	110.4	110.4	8884.0
2014-09-25 19:00:00	IWM	ETF	110.42	110.42	110.42	110.42	940.0
2014-09-25 08:00:00	DIA	ETF	171.65	171.65	171.54	171.54	9400.0
2014-09-25 09:00:00	DIA	ETF	171.46	171.53	170.48	170.58	1116621.0
2014-09-25 10:00:00	DIA	ETF	170.59	170.66	169.47	169.83	1704017.0

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

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