PREVIEW / etf_1hour / 2014-11-24

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-24.parquet
  size:    231 KB
  rows:    7,387

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-11-24 04:00:00	SPY	ETF	206.68	207.2	206.68	207.05	54870.0
2014-11-24 05:00:00	SPY	ETF	207.06	207.18	207.05	207.18	26330.0
2014-11-24 06:00:00	SPY	ETF	207.2	207.23	206.95	207.04	64947.0
2014-11-24 07:00:00	SPY	ETF	207.15	207.26	207.08	207.12	107487.0
2014-11-24 08:00:00	SPY	ETF	207.12	207.33	207.05	207.28	402269.0
2014-11-24 09:00:00	SPY	ETF	207.27	207.39	206.93	207.03	10504426.0
2014-11-24 10:00:00	SPY	ETF	207.01	207.34	206.97	207.2	9595691.0
2014-11-24 11:00:00	SPY	ETF	207.205	207.25	206.96	207.06	6667433.0
2014-11-24 12:00:00	SPY	ETF	207.051	207.2	206.91	206.99	5061947.0
2014-11-24 13:00:00	SPY	ETF	206.99	207.11	206.96	207.07	3266979.0
2014-11-24 14:00:00	SPY	ETF	207.07	207.27	207.04	207.085	6311458.0
2014-11-24 15:00:00	SPY	ETF	207.0855	207.32	206.985	207.28	14840596.0
2014-11-24 16:00:00	SPY	ETF	207.29	207.31	206.6801	207.26	5017766.0
2014-11-24 17:00:00	SPY	ETF	207.26	207.28	207.25	207.26	70877.0
2014-11-24 18:00:00	SPY	ETF	207.25	207.38	207.22	207.36	94224.0
2014-11-24 19:00:00	SPY	ETF	207.33	207.33	207.18	207.22	121144.0
2014-11-24 04:00:00	QQQ	ETF	104.53	104.53	104.14	104.14	200.0
2014-11-24 05:00:00	QQQ	ETF	104.07	104.07	104.07	104.07	300.0
2014-11-24 06:00:00	QQQ	ETF	104.1	104.1	104.02	104.07	22550.0
2014-11-24 07:00:00	QQQ	ETF	104.11	104.17	104.08	104.09	22479.0
2014-11-24 08:00:00	QQQ	ETF	104.1	104.24	104.07	104.2	110744.0
2014-11-24 09:00:00	QQQ	ETF	104.2	104.385	103.87	104.315	2623697.0
2014-11-24 10:00:00	QQQ	ETF	104.31	104.52	104.3	104.415	2446821.0
2014-11-24 11:00:00	QQQ	ETF	104.41	104.5	104.36	104.49	1218006.0
2014-11-24 12:00:00	QQQ	ETF	104.49	104.6	104.41	104.49	1820827.0
2014-11-24 13:00:00	QQQ	ETF	104.48	104.61	104.46	104.6	1072908.0
2014-11-24 14:00:00	QQQ	ETF	104.61	104.68	104.55	104.62	1665917.0
2014-11-24 15:00:00	QQQ	ETF	104.614	104.73	104.5301	104.69	3524902.0
2014-11-24 16:00:00	QQQ	ETF	104.68	104.7563	104.4861	104.65	2035363.0
2014-11-24 17:00:00	QQQ	ETF	104.651	104.68	104.65	104.65	6708.0
2014-11-24 18:00:00	QQQ	ETF	104.65	104.71	104.629	104.71	32033.0
2014-11-24 19:00:00	QQQ	ETF	104.67	104.67	104.61	104.63	21950.0
2014-11-24 06:00:00	IWM	ETF	116.75	116.75	116.75	116.75	10000.0
2014-11-24 07:00:00	IWM	ETF	116.76	116.84	116.71	116.72	10800.0
2014-11-24 08:00:00	IWM	ETF	116.75	116.97	116.74	116.97	81589.0
2014-11-24 09:00:00	IWM	ETF	116.94	117.48	116.67	117.29	3444847.0
2014-11-24 10:00:00	IWM	ETF	117.29	117.66	117.29	117.43	3826283.0
2014-11-24 11:00:00	IWM	ETF	117.4399	117.53	117.26	117.41	1910019.0
2014-11-24 12:00:00	IWM	ETF	117.42	117.54	117.28	117.32	1134833.0
2014-11-24 13:00:00	IWM	ETF	117.32	117.485	117.26	117.42	975518.0
2014-11-24 14:00:00	IWM	ETF	117.42	117.8	117.42	117.7	2044332.0
2014-11-24 15:00:00	IWM	ETF	117.7	118.04	117.63	117.99	4882350.0
2014-11-24 16:00:00	IWM	ETF	118.0	118.05	117.4983	118.01	2114292.0
2014-11-24 17:00:00	IWM	ETF	117.98	117.98	117.93	117.98	5400.0
2014-11-24 18:00:00	IWM	ETF	117.92	117.95	117.92	117.95	200.0
2014-11-24 19:00:00	IWM	ETF	117.92	117.92	117.92	117.92	300.0
2014-11-24 07:00:00	DIA	ETF	177.7	177.7	177.7	177.7	371.0
2014-11-24 08:00:00	DIA	ETF	178.09	178.1	178.09	178.1	225.0
2014-11-24 09:00:00	DIA	ETF	178.1	178.22	177.75	177.87	445969.0
2014-11-24 10:00:00	DIA	ETF	177.86	178.1	177.83	177.93	403750.0

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

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