PREVIEW / etf_1hour / 2014-09-05

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-05.parquet
  size:    221 KB
  rows:    6,942

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-09-05 04:00:00	SPY	ETF	200.03	200.07	199.92	199.95	28911.0
2014-09-05 05:00:00	SPY	ETF	199.88	199.97	199.69	199.69	22460.0
2014-09-05 06:00:00	SPY	ETF	199.67	199.71	199.48	199.7	268102.0
2014-09-05 07:00:00	SPY	ETF	199.7	199.8	199.56	199.75	354213.0
2014-09-05 08:00:00	SPY	ETF	199.62	200.5	199.34	199.99	5131489.0
2014-09-05 09:00:00	SPY	ETF	200.0	200.3	199.56	200.17	13508468.0
2014-09-05 10:00:00	SPY	ETF	200.18	200.25	199.41	199.78	13124465.0
2014-09-05 11:00:00	SPY	ETF	199.79	200.36	199.735	200.265	8012237.0
2014-09-05 12:00:00	SPY	ETF	200.265	200.77	200.22	200.665	8467230.0
2014-09-05 13:00:00	SPY	ETF	200.67	200.89	200.57	200.72	6918854.0
2014-09-05 14:00:00	SPY	ETF	200.72	201.0	200.71	200.86	10112992.0
2014-09-05 15:00:00	SPY	ETF	200.87	201.19	200.8	201.13	20021861.0
2014-09-05 16:00:00	SPY	ETF	201.13	201.28	199.77	201.25	11706424.0
2014-09-05 17:00:00	SPY	ETF	201.26	201.32	201.15	201.27	124222.0
2014-09-05 18:00:00	SPY	ETF	201.27	201.27	201.21	201.23	10175.0
2014-09-05 19:00:00	SPY	ETF	201.24	201.29	201.21	201.29	18908.0
2014-09-05 04:00:00	QQQ	ETF	99.39	99.39	99.26	99.26	2762.0
2014-09-05 05:00:00	QQQ	ETF	99.3	99.34	99.23	99.23	64200.0
2014-09-05 06:00:00	QQQ	ETF	99.18	99.25	99.12	99.21	80700.0
2014-09-05 07:00:00	QQQ	ETF	99.26	99.35	99.25	99.34	38800.0
2014-09-05 08:00:00	QQQ	ETF	99.33	99.7	99.2	99.52	586221.0
2014-09-05 09:00:00	QQQ	ETF	99.52	99.63	99.035	99.49	6344977.0
2014-09-05 10:00:00	QQQ	ETF	99.49	99.55	99.03	99.18	5444348.0
2014-09-05 11:00:00	QQQ	ETF	99.19	99.42	99.13	99.38	2757658.0
2014-09-05 12:00:00	QQQ	ETF	99.375	99.64	99.335	99.57	2027064.0
2014-09-05 13:00:00	QQQ	ETF	99.57	99.71	99.54	99.64	1630441.0
2014-09-05 14:00:00	QQQ	ETF	99.64	99.8	99.635	99.725	2612738.0
2014-09-05 15:00:00	QQQ	ETF	99.73	99.95	99.69	99.91	4566729.0
2014-09-05 16:00:00	QQQ	ETF	99.92	99.98	99.4337	99.95	1594215.0
2014-09-05 17:00:00	QQQ	ETF	99.94	100.03	99.86	100.03	46649.0
2014-09-05 18:00:00	QQQ	ETF	100.0	100.05	99.96	99.97	29571.0
2014-09-05 19:00:00	QQQ	ETF	100.02	100.05	99.99	99.99	6350.0
2014-09-05 04:00:00	IWM	ETF	115.92	115.92	115.71	115.71	300.0
2014-09-05 05:00:00	IWM	ETF	115.58	115.58	115.52	115.52	225.0
2014-09-05 06:00:00	IWM	ETF	115.43	115.43	115.2	115.2	500.0
2014-09-05 07:00:00	IWM	ETF	115.32	115.43	115.22	115.33	24550.0
2014-09-05 08:00:00	IWM	ETF	115.31	115.96	115.24	115.61	862283.0
2014-09-05 09:00:00	IWM	ETF	115.62	116.27	115.36	116.17	5814705.0
2014-09-05 10:00:00	IWM	ETF	116.17	116.27	115.17	115.44	5410121.0
2014-09-05 11:00:00	IWM	ETF	115.435	115.93	115.4	115.85	2201817.0
2014-09-05 12:00:00	IWM	ETF	115.85	116.27	115.85	116.13	2232746.0
2014-09-05 13:00:00	IWM	ETF	116.14	116.24	115.9	115.95	1851293.0
2014-09-05 14:00:00	IWM	ETF	115.94	116.18	115.93	116.18	1376170.0
2014-09-05 15:00:00	IWM	ETF	116.18	116.42	116.11	116.37	3609466.0
2014-09-05 16:00:00	IWM	ETF	116.37	116.55	115.641	116.51	2475111.0
2014-09-05 17:00:00	IWM	ETF	116.49	116.6	116.49	116.56	16382.0
2014-09-05 18:00:00	IWM	ETF	116.6	116.6	116.54	116.54	1781.0
2014-09-05 19:00:00	IWM	ETF	116.58	116.58	116.51	116.51	2875.0
2014-09-05 06:00:00	DIA	ETF	170.32	170.32	170.32	170.32	300.0
2014-09-05 07:00:00	DIA	ETF	170.26	170.26	170.26	170.26	200.0

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

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