PREVIEW / etf_1hour / 2014-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-02.parquet
  size:    232 KB
  rows:    7,391

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-12-02 04:00:00	SPY	ETF	206.29	206.37	206.06	206.07	60680.0
2014-12-02 05:00:00	SPY	ETF	206.09	206.16	205.69	205.78	36505.0
2014-12-02 06:00:00	SPY	ETF	205.83	206.04	205.79	206.01	24322.0
2014-12-02 07:00:00	SPY	ETF	205.99	206.26	205.92	206.13	298305.0
2014-12-02 08:00:00	SPY	ETF	206.12	206.16	205.86	206.02	584767.0
2014-12-02 09:00:00	SPY	ETF	206.01	206.39	205.79	206.31	10694409.0
2014-12-02 10:00:00	SPY	ETF	206.31	206.77	206.28	206.76	12864197.0
2014-12-02 11:00:00	SPY	ETF	206.755	206.87	206.61	206.83	9084105.0
2014-12-02 12:00:00	SPY	ETF	206.82	206.84	206.53	206.71	5988284.0
2014-12-02 13:00:00	SPY	ETF	206.71	207.07	206.68	206.93	8733146.0
2014-12-02 14:00:00	SPY	ETF	206.93	207.34	206.87	207.27	7157976.0
2014-12-02 15:00:00	SPY	ETF	207.27	207.3	206.93	207.09	13415235.0
2014-12-02 16:00:00	SPY	ETF	207.07	207.22	206.99	207.18	4594816.0
2014-12-02 17:00:00	SPY	ETF	207.18	207.22	207.16	207.16	62321.0
2014-12-02 18:00:00	SPY	ETF	207.16	207.22	207.14	207.22	26140.0
2014-12-02 19:00:00	SPY	ETF	207.21	207.32	207.19	207.3	24691.0
2014-12-02 04:00:00	QQQ	ETF	105.18	105.18	105.17	105.17	24500.0
2014-12-02 05:00:00	QQQ	ETF	105.06	105.06	104.87	104.91	15413.0
2014-12-02 06:00:00	QQQ	ETF	104.99	105.0	104.92	104.99	20200.0
2014-12-02 07:00:00	QQQ	ETF	105.02	105.13	104.99	105.03	70784.0
2014-12-02 08:00:00	QQQ	ETF	105.02	105.02	104.88	104.96	213697.0
2014-12-02 09:00:00	QQQ	ETF	104.99	105.1	104.7	104.98	5678914.0
2014-12-02 10:00:00	QQQ	ETF	104.98	105.2	104.88	104.99	4086366.0
2014-12-02 11:00:00	QQQ	ETF	104.99	105.24	104.87	105.2	3036724.0
2014-12-02 12:00:00	QQQ	ETF	105.2	105.2099	104.88	105.03	1830008.0
2014-12-02 13:00:00	QQQ	ETF	105.03	105.2	104.98	105.12	1636367.0
2014-12-02 14:00:00	QQQ	ETF	105.13	105.4168	105.05	105.3636	2172112.0
2014-12-02 15:00:00	QQQ	ETF	105.37	105.4	105.13	105.24	3557841.0
2014-12-02 16:00:00	QQQ	ETF	105.24	105.28	104.7998	105.26	1235271.0
2014-12-02 17:00:00	QQQ	ETF	105.28	105.33	105.24	105.28	12189.0
2014-12-02 18:00:00	QQQ	ETF	105.26	105.31	105.26	105.3	16038.0
2014-12-02 19:00:00	QQQ	ETF	105.31	105.35	105.29	105.35	6250.0
2014-12-02 05:00:00	IWM	ETF	115.18	115.18	115.18	115.18	100.0
2014-12-02 06:00:00	IWM	ETF	115.08	115.08	115.08	115.08	100.0
2014-12-02 07:00:00	IWM	ETF	115.08	115.29	115.08	115.2	99020.0
2014-12-02 08:00:00	IWM	ETF	115.18	115.21	115.03	115.04	55938.0
2014-12-02 09:00:00	IWM	ETF	115.12	115.84	114.97	115.74	3362796.0
2014-12-02 10:00:00	IWM	ETF	115.75	116.41	115.62	116.38	4983840.0
2014-12-02 11:00:00	IWM	ETF	116.39	116.64	116.1	116.21	4209095.0
2014-12-02 12:00:00	IWM	ETF	116.2	116.22	115.8001	115.93	3059501.0
2014-12-02 13:00:00	IWM	ETF	115.93	116.21	115.8	116.0	2143203.0
2014-12-02 14:00:00	IWM	ETF	116.0	116.38	115.92	116.31	2163923.0
2014-12-02 15:00:00	IWM	ETF	116.31	116.36	116.0	116.22	3716799.0
2014-12-02 16:00:00	IWM	ETF	116.22	116.31	115.9	116.26	4138102.0
2014-12-02 17:00:00	IWM	ETF	116.29	116.29	116.28	116.28	2420.0
2014-12-02 18:00:00	IWM	ETF	116.22	116.33	116.22	116.33	300.0
2014-12-02 07:00:00	DIA	ETF	178.0	178.0	178.0	178.0	500.0
2014-12-02 08:00:00	DIA	ETF	177.94	177.94	177.9	177.9	5300.0
2014-12-02 09:00:00	DIA	ETF	177.721	178.1	177.67	177.93	539401.0
2014-12-02 10:00:00	DIA	ETF	177.94	178.26	177.94	178.21	526698.0

> showing 50 of 7,391 rows — these rows as CSV

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