PREVIEW / etf_1hour / 2014-03-13

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-13.parquet
  size:    222 KB
  rows:    6,954

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-03-13 04:00:00	SPY	ETF	187.56	187.6	187.34	187.6	18400.0
2014-03-13 05:00:00	SPY	ETF	187.59	187.82	187.59	187.74	33903.0
2014-03-13 06:00:00	SPY	ETF	187.75	187.84	187.56	187.58	75054.0
2014-03-13 07:00:00	SPY	ETF	187.61	187.7	187.54	187.63	359208.0
2014-03-13 08:00:00	SPY	ETF	187.58	187.82	187.55	187.68	1169896.0
2014-03-13 09:00:00	SPY	ETF	187.67	187.99	187.5	187.6	10239206.0
2014-03-13 10:00:00	SPY	ETF	187.5999	187.72	186.9	186.922	14191194.0
2014-03-13 11:00:00	SPY	ETF	186.925	187.15	186.49	186.54	14210372.0
2014-03-13 12:00:00	SPY	ETF	186.55	186.63	185.6401	185.715	21733482.0
2014-03-13 13:00:00	SPY	ETF	185.715	185.84	185.06	185.59	24840598.0
2014-03-13 14:00:00	SPY	ETF	185.59	185.66	184.99	185.15	18101727.0
2014-03-13 15:00:00	SPY	ETF	185.15	186.189	184.66	185.19	35621024.0
2014-03-13 16:00:00	SPY	ETF	185.19	187.3209	185.13	185.28	10363741.0
2014-03-13 17:00:00	SPY	ETF	185.28	185.3	185.2	185.21	176047.0
2014-03-13 18:00:00	SPY	ETF	185.23	185.33	185.14	185.31	770723.0
2014-03-13 19:00:00	SPY	ETF	185.31	185.36	185.17	185.3	119862.0
2014-03-13 04:00:00	QQQ	ETF	90.75	90.75	90.63	90.74	14800.0
2014-03-13 05:00:00	QQQ	ETF	90.81	90.94	90.81	90.87	48630.0
2014-03-13 06:00:00	QQQ	ETF	90.86	90.92	90.78	90.79	12500.0
2014-03-13 07:00:00	QQQ	ETF	90.77	90.82	90.77	90.79	8700.0
2014-03-13 08:00:00	QQQ	ETF	90.8	90.91	90.76	90.84	207312.0
2014-03-13 09:00:00	QQQ	ETF	90.85	90.96	90.6501	90.83	3273915.0
2014-03-13 10:00:00	QQQ	ETF	90.839	90.91	90.29	90.33	3656860.0
2014-03-13 11:00:00	QQQ	ETF	90.34	90.42	90.04	90.11	3789242.0
2014-03-13 12:00:00	QQQ	ETF	90.11	90.16	89.49	89.55	4787989.0
2014-03-13 13:00:00	QQQ	ETF	89.54	89.56	89.0434	89.31	8214173.0
2014-03-13 14:00:00	QQQ	ETF	89.31	89.42	89.09	89.16	5530286.0
2014-03-13 15:00:00	QQQ	ETF	89.165	89.3	88.87	89.27	9331968.0
2014-03-13 16:00:00	QQQ	ETF	89.28	90.0263	89.1825	89.3	1641720.0
2014-03-13 17:00:00	QQQ	ETF	89.31	89.31	89.29	89.29	10000.0
2014-03-13 18:00:00	QQQ	ETF	89.31	89.34	89.24	89.34	15972.0
2014-03-13 19:00:00	QQQ	ETF	89.34	89.35	89.3	89.3	30663.0
2014-03-13 06:00:00	IWM	ETF	118.75	118.75	118.75	118.75	100.0
2014-03-13 07:00:00	IWM	ETF	118.71	118.79	118.68	118.75	61900.0
2014-03-13 08:00:00	IWM	ETF	118.73	118.9	118.69	118.81	213391.0
2014-03-13 09:00:00	IWM	ETF	118.79	118.96	118.38	118.56	4076290.0
2014-03-13 10:00:00	IWM	ETF	118.56	118.66	117.75	117.86	5005579.0
2014-03-13 11:00:00	IWM	ETF	117.86	118.21	117.77	117.9699	3826439.0
2014-03-13 12:00:00	IWM	ETF	117.97	118.01	116.9	116.97	6756115.0
2014-03-13 13:00:00	IWM	ETF	116.96	117.35	116.51	117.1	9088052.0
2014-03-13 14:00:00	IWM	ETF	117.11	117.19	116.6498	116.72	5478151.0
2014-03-13 15:00:00	IWM	ETF	116.72	117.24	116.38	117.05	12874160.0
2014-03-13 16:00:00	IWM	ETF	117.06	118.4354	116.7485	116.95	2453606.0
2014-03-13 17:00:00	IWM	ETF	116.94	117.05	116.85	116.85	991760.0
2014-03-13 18:00:00	IWM	ETF	116.86	116.91	116.84	116.91	6200.0
2014-03-13 19:00:00	IWM	ETF	116.93	117.0	116.92	116.95	4100.0
2014-03-13 08:00:00	DIA	ETF	163.4	163.69	163.4	163.58	900.0
2014-03-13 09:00:00	DIA	ETF	163.66	164.03	163.62	163.68	601062.0
2014-03-13 10:00:00	DIA	ETF	163.67	163.74	162.88	162.91	908407.0
2014-03-13 11:00:00	DIA	ETF	162.92	163.1	162.44	162.48	986802.0

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

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