PREVIEW / etf_1hour / 2014-02-21

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-21.parquet
  size:    210 KB
  rows:    6,623

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-21 04:00:00	SPY	ETF	184.46	184.56	184.35	184.56	24259.0
2014-02-21 05:00:00	SPY	ETF	184.51	184.52	184.4	184.41	7858.0
2014-02-21 06:00:00	SPY	ETF	184.42	184.51	184.36	184.51	13039.0
2014-02-21 07:00:00	SPY	ETF	184.51	184.59	184.42	184.54	372542.0
2014-02-21 08:00:00	SPY	ETF	184.53	184.56	184.29	184.34	500806.0
2014-02-21 09:00:00	SPY	ETF	184.34	184.72	184.16	184.59	16872619.0
2014-02-21 10:00:00	SPY	ETF	184.59	184.82	184.24	184.73	16536337.0
2014-02-21 11:00:00	SPY	ETF	184.73	184.89	184.53	184.67	17980783.0
2014-02-21 12:00:00	SPY	ETF	184.68	184.77	184.36	184.54	7270826.0
2014-02-21 13:00:00	SPY	ETF	184.53	184.715	184.37	184.455	5305735.0
2014-02-21 14:00:00	SPY	ETF	184.455	184.5	183.952	184.15	15322147.0
2014-02-21 15:00:00	SPY	ETF	184.15	184.44	183.8	183.91	23288912.0
2014-02-21 16:00:00	SPY	ETF	183.91	184.4035	183.85	183.92	9734092.0
2014-02-21 17:00:00	SPY	ETF	183.92	184.73	183.7	183.85	315479.0
2014-02-21 18:00:00	SPY	ETF	183.82	183.88	183.8	183.83	12470.0
2014-02-21 19:00:00	SPY	ETF	183.85	183.88	183.8	183.87	11114.0
2014-02-21 04:00:00	QQQ	ETF	90.17	90.27	90.16	90.27	4662.0
2014-02-21 05:00:00	QQQ	ETF	90.26	90.26	90.26	90.26	900.0
2014-02-21 06:00:00	QQQ	ETF	90.18	90.26	90.18	90.25	3000.0
2014-02-21 07:00:00	QQQ	ETF	90.26	90.32	90.23	90.3	94300.0
2014-02-21 08:00:00	QQQ	ETF	90.32	90.32	90.16	90.17	150863.0
2014-02-21 09:00:00	QQQ	ETF	90.21	90.465	90.17	90.4	4051809.0
2014-02-21 10:00:00	QQQ	ETF	90.4	90.44	90.18	90.375	4070011.0
2014-02-21 11:00:00	QQQ	ETF	90.38	90.42	90.265	90.28	2521156.0
2014-02-21 12:00:00	QQQ	ETF	90.29	90.33	90.07	90.15	1551407.0
2014-02-21 13:00:00	QQQ	ETF	90.1499	90.26	90.1	90.11	1074556.0
2014-02-21 14:00:00	QQQ	ETF	90.105	90.145	89.89	90.0	2413517.0
2014-02-21 15:00:00	QQQ	ETF	90.0	90.12	89.82	89.88	4139482.0
2014-02-21 16:00:00	QQQ	ETF	89.87	90.316	89.87	89.93	3388903.0
2014-02-21 17:00:00	QQQ	ETF	89.92	89.92	89.85	89.91	12080.0
2014-02-21 18:00:00	QQQ	ETF	89.93	89.96	89.93	89.96	10400.0
2014-02-21 19:00:00	QQQ	ETF	89.95	89.96	89.94	89.96	17591.0
2014-02-21 04:00:00	IWM	ETF	115.68	115.68	115.68	115.68	100.0
2014-02-21 07:00:00	IWM	ETF	115.6	115.65	115.6	115.64	16300.0
2014-02-21 08:00:00	IWM	ETF	115.67	115.67	115.39	115.4	90957.0
2014-02-21 09:00:00	IWM	ETF	115.39	115.88	115.37	115.72	4520608.0
2014-02-21 10:00:00	IWM	ETF	115.72	116.015	115.49	115.98	4541242.0
2014-02-21 11:00:00	IWM	ETF	115.99	116.11	115.9	115.9275	3077979.0
2014-02-21 12:00:00	IWM	ETF	115.93	116.025	115.78	115.936	1705768.0
2014-02-21 13:00:00	IWM	ETF	115.93	116.07	115.85	115.95	1711269.0
2014-02-21 14:00:00	IWM	ETF	115.955	116.005	115.58	115.74	3183023.0
2014-02-21 15:00:00	IWM	ETF	115.74	115.94	115.48	115.62	7981424.0
2014-02-21 16:00:00	IWM	ETF	115.61	115.75	115.4066	115.71	3994265.0
2014-02-21 17:00:00	IWM	ETF	115.69	115.69	115.61	115.65	63520.0
2014-02-21 18:00:00	IWM	ETF	115.67	115.67	115.67	115.67	672.0
2014-02-21 19:00:00	IWM	ETF	115.65	115.65	115.65	115.65	100.0
2014-02-21 07:00:00	DIA	ETF	161.5	161.5	161.3	161.48	600.0
2014-02-21 08:00:00	DIA	ETF	161.25	161.31	161.0	161.09	5369.0
2014-02-21 09:00:00	DIA	ETF	161.1	161.48	160.84	161.43	588095.0
2014-02-21 10:00:00	DIA	ETF	161.39	161.62	161.01	161.4	1027828.0

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

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