PREVIEW / etf_1hour / 2014-02-28

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-28.parquet
  size:    219 KB
  rows:    6,864

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-02-28 04:00:00	SPY	ETF	185.75	185.75	185.45	185.67	130402.0
2014-02-28 05:00:00	SPY	ETF	185.68	185.77	185.57	185.77	12032.0
2014-02-28 06:00:00	SPY	ETF	185.72	185.72	185.56	185.64	35540.0
2014-02-28 07:00:00	SPY	ETF	185.61	185.79	185.5	185.64	230216.0
2014-02-28 08:00:00	SPY	ETF	185.765	185.87	185.56	185.71	1003615.0
2014-02-28 09:00:00	SPY	ETF	185.7	186.46	185.66	186.39	12679167.0
2014-02-28 10:00:00	SPY	ETF	186.39	186.96	186.38	186.8099	16858060.0
2014-02-28 11:00:00	SPY	ETF	186.8	187.15	186.56	187.04	14261136.0
2014-02-28 12:00:00	SPY	ETF	187.04	187.12	186.93	187.01	6727276.0
2014-02-28 13:00:00	SPY	ETF	187.0	187.13	186.82	186.86	8436277.0
2014-02-28 14:00:00	SPY	ETF	186.855	186.87	185.95	186.02	18319582.0
2014-02-28 15:00:00	SPY	ETF	186.03	186.41	185.05	186.33	53065313.0
2014-02-28 16:00:00	SPY	ETF	186.33	187.0	185.6	186.52	12981363.0
2014-02-28 17:00:00	SPY	ETF	186.5	186.54	186.25	186.32	1047665.0
2014-02-28 18:00:00	SPY	ETF	186.31	186.37	186.29	186.3	116333.0
2014-02-28 19:00:00	SPY	ETF	186.3	186.33	186.26	186.29	66182.0
2014-02-28 04:00:00	QQQ	ETF	90.28	90.28	90.28	90.28	2600.0
2014-02-28 05:00:00	QQQ	ETF	90.3	90.3	90.3	90.3	2500.0
2014-02-28 06:00:00	QQQ	ETF	90.31	90.34	90.29	90.34	2600.0
2014-02-28 07:00:00	QQQ	ETF	90.33	90.35	90.26	90.35	1900.0
2014-02-28 08:00:00	QQQ	ETF	90.35	90.42	90.34	90.4	66808.0
2014-02-28 09:00:00	QQQ	ETF	90.4	90.84	90.35	90.71	4838615.0
2014-02-28 10:00:00	QQQ	ETF	90.71	90.96	90.71	90.751	5293068.0
2014-02-28 11:00:00	QQQ	ETF	90.76	90.95	90.65	90.89	3541972.0
2014-02-28 12:00:00	QQQ	ETF	90.9	90.9	90.79	90.82	2409892.0
2014-02-28 13:00:00	QQQ	ETF	90.825	90.87	90.57	90.61	2720309.0
2014-02-28 14:00:00	QQQ	ETF	90.6	90.63	89.98	90.04	6743517.0
2014-02-28 15:00:00	QQQ	ETF	90.03	90.38	89.54	90.34	11458950.0
2014-02-28 16:00:00	QQQ	ETF	90.33	90.6852	90.3	90.34	4537750.0
2014-02-28 17:00:00	QQQ	ETF	90.36	90.39	90.19	90.23	1483662.0
2014-02-28 18:00:00	QQQ	ETF	90.23	90.3	90.2	90.26	5729.0
2014-02-28 19:00:00	QQQ	ETF	90.25	90.25	90.2	90.2	2125.0
2014-02-28 06:00:00	IWM	ETF	117.94	117.94	117.9	117.9	1100.0
2014-02-28 07:00:00	IWM	ETF	117.85	117.96	117.79	117.84	23550.0
2014-02-28 08:00:00	IWM	ETF	117.87	117.94	117.81	117.89	73795.0
2014-02-28 09:00:00	IWM	ETF	117.93	118.41	117.88	118.32	4305105.0
2014-02-28 10:00:00	IWM	ETF	118.31	118.71	118.29	118.36	6652529.0
2014-02-28 11:00:00	IWM	ETF	118.36	118.48	118.13	118.36	3864491.0
2014-02-28 12:00:00	IWM	ETF	118.36	118.5	118.25	118.35	1818118.0
2014-02-28 13:00:00	IWM	ETF	118.35	118.62	118.29	118.32	3351143.0
2014-02-28 14:00:00	IWM	ETF	118.31	118.33	117.5	117.56	5711139.0
2014-02-28 15:00:00	IWM	ETF	117.57	117.75	116.8	117.53	13830693.0
2014-02-28 16:00:00	IWM	ETF	117.5	118.4311	117.46	117.6	2824646.0
2014-02-28 17:00:00	IWM	ETF	117.6	117.69	117.45	117.45	71137.0
2014-02-28 18:00:00	IWM	ETF	117.47	117.47	117.39	117.39	3863.0
2014-02-28 19:00:00	IWM	ETF	117.4	117.4	117.35	117.35	1770.0
2014-02-28 07:00:00	DIA	ETF	162.4	162.4	162.4	162.4	400.0
2014-02-28 08:00:00	DIA	ETF	162.44	162.56	162.4	162.56	7800.0
2014-02-28 09:00:00	DIA	ETF	162.53	163.08	162.35	163.08	887004.0
2014-02-28 10:00:00	DIA	ETF	163.07	163.55	163.06	163.41	1802026.0

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

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