PREVIEW / etf_1hour / 2013-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-13.parquet
  size:    207 KB
  rows:    6,551

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
2013-12-13 04:00:00	SPY	ETF	178.66	178.77	178.4	178.77	70754.0
2013-12-13 05:00:00	SPY	ETF	178.75	178.75	178.51	178.66	14501.0
2013-12-13 06:00:00	SPY	ETF	178.68	178.85	178.68	178.77	126610.0
2013-12-13 07:00:00	SPY	ETF	178.77	178.83	178.7	178.7	231049.0
2013-12-13 08:00:00	SPY	ETF	178.7	178.76	178.28	178.43	1730205.0
2013-12-13 09:00:00	SPY	ETF	178.43	178.66	178.0	178.04	11884546.0
2013-12-13 10:00:00	SPY	ETF	178.05	178.26	177.77	178.085	13437775.0
2013-12-13 11:00:00	SPY	ETF	178.08	178.21	177.88	178.15	9087201.0
2013-12-13 12:00:00	SPY	ETF	178.14	178.42	178.02	178.28	8352973.0
2013-12-13 13:00:00	SPY	ETF	178.29	178.53	178.27	178.29	6936475.0
2013-12-13 14:00:00	SPY	ETF	178.29	178.3	177.79	178.22	12848705.0
2013-12-13 15:00:00	SPY	ETF	178.22	178.52	178.02	178.11	22225945.0
2013-12-13 16:00:00	SPY	ETF	178.11	178.2756	177.92	178.09	17622179.0
2013-12-13 17:00:00	SPY	ETF	178.09	178.1	177.92	177.95	395585.0
2013-12-13 18:00:00	SPY	ETF	177.93	178.0	177.92	177.98	51590.0
2013-12-13 19:00:00	SPY	ETF	177.95	178.05	177.95	177.97	14973.0
2013-12-13 04:00:00	QQQ	ETF	85.23	85.28	85.23	85.28	65800.0
2013-12-13 05:00:00	QQQ	ETF	85.26	85.26	85.16	85.24	6000.0
2013-12-13 06:00:00	QQQ	ETF	85.26	85.3	85.25	85.28	16005.0
2013-12-13 07:00:00	QQQ	ETF	85.26	85.32	85.26	85.28	70400.0
2013-12-13 08:00:00	QQQ	ETF	85.28	85.33	85.13	85.19	386892.0
2013-12-13 09:00:00	QQQ	ETF	85.18	85.4	84.94	84.96	5808671.0
2013-12-13 10:00:00	QQQ	ETF	84.96	85.14	84.91	85.03	3746184.0
2013-12-13 11:00:00	QQQ	ETF	85.03	85.08	84.87	84.965	2875581.0
2013-12-13 12:00:00	QQQ	ETF	84.97	85.05	84.91	84.9772	3101292.0
2013-12-13 13:00:00	QQQ	ETF	84.97	85.09	84.941	84.96	2394353.0
2013-12-13 14:00:00	QQQ	ETF	84.95	84.9501	84.709	84.89	5389262.0
2013-12-13 15:00:00	QQQ	ETF	84.89	85.07	84.83	84.85	5704297.0
2013-12-13 16:00:00	QQQ	ETF	84.85	85.084	84.84	84.93	2247570.0
2013-12-13 17:00:00	QQQ	ETF	84.92	84.92	84.8	84.8	208600.0
2013-12-13 18:00:00	QQQ	ETF	84.88	84.88	84.88	84.88	2000.0
2013-12-13 19:00:00	QQQ	ETF	84.85	84.85	84.84	84.84	1403.0
2013-12-13 06:00:00	IWM	ETF	110.23	110.87	109.91	110.15	14102.0
2013-12-13 07:00:00	IWM	ETF	110.18	110.21	110.14	110.17	58645.0
2013-12-13 08:00:00	IWM	ETF	110.17	110.19	109.91	109.97	201928.0
2013-12-13 09:00:00	IWM	ETF	109.98	110.49	109.83	109.98	4151099.0
2013-12-13 10:00:00	IWM	ETF	109.99	110.165	109.63	109.73	3096888.0
2013-12-13 11:00:00	IWM	ETF	109.72	109.935	109.42	109.81	4002828.0
2013-12-13 12:00:00	IWM	ETF	109.8	110.42	109.73	110.4	3800791.0
2013-12-13 13:00:00	IWM	ETF	110.4	110.5301	110.22	110.2625	3331770.0
2013-12-13 14:00:00	IWM	ETF	110.265	110.27	109.76	110.22	2805495.0
2013-12-13 15:00:00	IWM	ETF	110.23	110.5	110.11	110.19	4866961.0
2013-12-13 16:00:00	IWM	ETF	110.18	110.348	109.94	110.03	1285989.0
2013-12-13 17:00:00	IWM	ETF	110.04	110.04	109.96	110.0	4191.0
2013-12-13 19:00:00	IWM	ETF	110.0	110.0	110.0	110.0	240.0
2013-12-13 07:00:00	DIA	ETF	157.99	157.99	157.99	157.99	100.0
2013-12-13 08:00:00	DIA	ETF	157.67	157.67	157.54	157.54	900.0
2013-12-13 09:00:00	DIA	ETF	157.47	157.73	157.34	157.39	571621.0
2013-12-13 10:00:00	DIA	ETF	157.42	157.67	157.22	157.575	1385273.0
2013-12-13 11:00:00	DIA	ETF	157.56	157.67	157.1	157.63	1714199.0

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

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