PREVIEW / etf_1hour / 2014-02-20

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-20.parquet
  size:    215 KB
  rows:    6,775

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-20 04:00:00	SPY	ETF	182.7	182.86	182.7	182.73	6923.0
2014-02-20 05:00:00	SPY	ETF	182.73	183.07	182.73	182.91	20541.0
2014-02-20 06:00:00	SPY	ETF	182.93	182.93	182.75	182.9	57656.0
2014-02-20 07:00:00	SPY	ETF	182.9	183.0	182.45	182.59	361262.0
2014-02-20 08:00:00	SPY	ETF	182.57	183.46	182.46	183.26	2130176.0
2014-02-20 09:00:00	SPY	ETF	183.25	183.64	182.85	182.96	14438618.0
2014-02-20 10:00:00	SPY	ETF	182.94	183.87	182.6	183.7	21835803.0
2014-02-20 11:00:00	SPY	ETF	183.71	183.94	183.54	183.75	12356066.0
2014-02-20 12:00:00	SPY	ETF	183.75	184.28	183.695	184.14	10230433.0
2014-02-20 13:00:00	SPY	ETF	184.15	184.27	184.11	184.21	5348517.0
2014-02-20 14:00:00	SPY	ETF	184.21	184.37	183.98	184.34	9484692.0
2014-02-20 15:00:00	SPY	ETF	184.34	184.52	184.16	184.16	18191945.0
2014-02-20 16:00:00	SPY	ETF	184.16	184.3	183.1124	184.06	8481399.0
2014-02-20 17:00:00	SPY	ETF	184.07	184.1	184.04	184.09	51326.0
2014-02-20 18:00:00	SPY	ETF	184.1	184.15	184.06	184.15	21935.0
2014-02-20 19:00:00	SPY	ETF	184.15	184.42	184.15	184.39	134627.0
2014-02-20 04:00:00	QQQ	ETF	89.54	89.61	89.54	89.61	7200.0
2014-02-20 05:00:00	QQQ	ETF	89.58	89.58	89.56	89.58	3218.0
2014-02-20 06:00:00	QQQ	ETF	89.55	89.55	89.45	89.51	45200.0
2014-02-20 07:00:00	QQQ	ETF	89.5	89.5	89.28	89.3	68950.0
2014-02-20 08:00:00	QQQ	ETF	89.31	89.72	89.31	89.62	292715.0
2014-02-20 09:00:00	QQQ	ETF	89.63	89.94	89.38	89.44	5145877.0
2014-02-20 10:00:00	QQQ	ETF	89.44	89.88	89.31	89.757	6083717.0
2014-02-20 11:00:00	QQQ	ETF	89.76	89.8201	89.62	89.75	3573412.0
2014-02-20 12:00:00	QQQ	ETF	89.745	90.0	89.72	89.9099	2224246.0
2014-02-20 13:00:00	QQQ	ETF	89.905	89.99	89.8923	89.9799	1271762.0
2014-02-20 14:00:00	QQQ	ETF	89.975	90.11	89.88	90.06	3218328.0
2014-02-20 15:00:00	QQQ	ETF	90.055	90.22	90.045	90.06	6255650.0
2014-02-20 16:00:00	QQQ	ETF	90.05	90.1476	89.6206	90.05	4682819.0
2014-02-20 17:00:00	QQQ	ETF	90.05	90.11	90.04	90.07	4225.0
2014-02-20 18:00:00	QQQ	ETF	90.07	90.08	90.05	90.08	10543.0
2014-02-20 19:00:00	QQQ	ETF	90.11	90.2	90.11	90.16	7465.0
2014-02-20 04:00:00	IWM	ETF	114.02	114.02	113.83	113.83	2900.0
2014-02-20 05:00:00	IWM	ETF	114.07	114.07	114.07	114.07	100.0
2014-02-20 06:00:00	IWM	ETF	113.81	113.97	113.81	113.97	1500.0
2014-02-20 07:00:00	IWM	ETF	114.0	114.0	113.65	113.67	85800.0
2014-02-20 08:00:00	IWM	ETF	113.68	114.35	113.65	114.22	347083.0
2014-02-20 09:00:00	IWM	ETF	114.25	114.68	114.05	114.12	4464521.0
2014-02-20 10:00:00	IWM	ETF	114.1	115.08	113.91	114.95	7033211.0
2014-02-20 11:00:00	IWM	ETF	114.95	115.11	114.73	114.81	2580053.0
2014-02-20 12:00:00	IWM	ETF	114.81	115.14	114.7501	115.04	2833914.0
2014-02-20 13:00:00	IWM	ETF	115.04	115.165	114.94	115.06	1728852.0
2014-02-20 14:00:00	IWM	ETF	115.06	115.37	114.915	115.338	2555854.0
2014-02-20 15:00:00	IWM	ETF	115.34	115.54	115.3	115.32	5771280.0
2014-02-20 16:00:00	IWM	ETF	115.31	115.4	114.573	115.26	2258377.0
2014-02-20 17:00:00	IWM	ETF	115.25	115.27	115.25	115.26	30275.0
2014-02-20 18:00:00	IWM	ETF	115.26	115.31	115.24	115.31	10500.0
2014-02-20 19:00:00	IWM	ETF	115.33	115.41	115.33	115.41	10000.0
2014-02-20 07:00:00	DIA	ETF	160.41	160.41	160.1	160.1	10571.0
2014-02-20 08:00:00	DIA	ETF	160.16	160.38	160.05	160.38	30028.0

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

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