PREVIEW / etf_1hour / 2014-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-02.parquet
  size:    214 KB
  rows:    6,852

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-06-02 04:00:00	SPY	ETF	192.85	192.85	192.78	192.83	650.0
2014-06-02 05:00:00	SPY	ETF	192.83	192.86	192.83	192.86	4351.0
2014-06-02 06:00:00	SPY	ETF	192.97	192.98	192.88	192.96	41755.0
2014-06-02 07:00:00	SPY	ETF	192.9	192.92	192.8	192.82	237911.0
2014-06-02 08:00:00	SPY	ETF	192.83	192.9	192.81	192.84	310024.0
2014-06-02 09:00:00	SPY	ETF	192.86	192.98	192.48	192.52	9838762.0
2014-06-02 10:00:00	SPY	ETF	192.5	192.55	191.97	192.38	12662468.0
2014-06-02 11:00:00	SPY	ETF	192.38	192.94	192.3	192.85	11941867.0
2014-06-02 12:00:00	SPY	ETF	192.85	192.86	192.71	192.78	3388781.0
2014-06-02 13:00:00	SPY	ETF	192.78	192.85	192.66	192.805	4132806.0
2014-06-02 14:00:00	SPY	ETF	192.81	192.94	192.71	192.85	3746645.0
2014-06-02 15:00:00	SPY	ETF	192.86	192.99	192.66	192.9	10740130.0
2014-06-02 16:00:00	SPY	ETF	192.88	192.91	192.669	192.81	6279897.0
2014-06-02 17:00:00	SPY	ETF	192.81	192.8951	192.76	192.8	241277.0
2014-06-02 18:00:00	SPY	ETF	192.78	192.8	192.68	192.72	186492.0
2014-06-02 19:00:00	SPY	ETF	192.71	192.74	192.69	192.73	46110.0
2014-06-02 05:00:00	QQQ	ETF	91.36	91.36	91.36	91.36	2000.0
2014-06-02 06:00:00	QQQ	ETF	91.4	91.45	91.4	91.42	4100.0
2014-06-02 07:00:00	QQQ	ETF	91.4	91.4	91.4	91.4	960.0
2014-06-02 08:00:00	QQQ	ETF	91.57	91.57	91.33	91.39	632529.0
2014-06-02 09:00:00	QQQ	ETF	91.4	91.48	90.95	90.975	5293093.0
2014-06-02 10:00:00	QQQ	ETF	90.97	91.05	90.64	90.97	5693520.0
2014-06-02 11:00:00	QQQ	ETF	90.9799	91.33	90.93	91.25	2729920.0
2014-06-02 12:00:00	QQQ	ETF	91.26	91.275	91.1	91.13	1439457.0
2014-06-02 13:00:00	QQQ	ETF	91.1299	91.155	90.98	91.065	1645573.0
2014-06-02 14:00:00	QQQ	ETF	91.069	91.16	90.87	91.07	2132585.0
2014-06-02 15:00:00	QQQ	ETF	91.07	91.27	91.0001	91.22	3575581.0
2014-06-02 16:00:00	QQQ	ETF	91.22	91.348	90.9825	91.348	4522138.0
2014-06-02 17:00:00	QQQ	ETF	91.17	91.17	91.17	91.17	2950.0
2014-06-02 18:00:00	QQQ	ETF	91.16	91.16	91.09	91.11	3804.0
2014-06-02 19:00:00	QQQ	ETF	91.11	91.11	91.09	91.09	1600.0
2014-06-02 08:00:00	IWM	ETF	112.99	113.04	112.86	113.02	74047.0
2014-06-02 09:00:00	IWM	ETF	113.05	113.13	111.88	111.92	5795099.0
2014-06-02 10:00:00	IWM	ETF	111.895	111.91	111.36	111.66	9536314.0
2014-06-02 11:00:00	IWM	ETF	111.65	112.59	111.61	112.43	6624618.0
2014-06-02 12:00:00	IWM	ETF	112.43	112.47	112.24	112.31	1539528.0
2014-06-02 13:00:00	IWM	ETF	112.315	112.4	112.12	112.3	1791661.0
2014-06-02 14:00:00	IWM	ETF	112.3	112.42	112.13	112.3	2234775.0
2014-06-02 15:00:00	IWM	ETF	112.3	112.35	112.12	112.25	5344001.0
2014-06-02 16:00:00	IWM	ETF	112.25	112.6575	111.6857	112.14	1576479.0
2014-06-02 18:00:00	IWM	ETF	112.1	112.1	112.07	112.07	4100.0
2014-06-02 19:00:00	IWM	ETF	112.05	112.05	112.02	112.02	500.0
2014-06-02 06:00:00	DIA	ETF	167.2	167.2	167.2	167.2	300.0
2014-06-02 08:00:00	DIA	ETF	167.2	167.2	167.2	167.2	417.0
2014-06-02 09:00:00	DIA	ETF	167.19	167.29	167.01	167.09	399621.0
2014-06-02 10:00:00	DIA	ETF	167.1	167.1	166.63	166.91	938988.0
2014-06-02 11:00:00	DIA	ETF	166.92	167.31	166.88	167.17	481751.0
2014-06-02 12:00:00	DIA	ETF	167.2	167.22	167.1	167.17	167657.0
2014-06-02 13:00:00	DIA	ETF	167.18	167.23	167.08	167.16	130088.0
2014-06-02 14:00:00	DIA	ETF	167.18	167.28	167.12	167.23	196685.0

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

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