PREVIEW / etf_1hour / 2014-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-02.parquet
  size:    224 KB
  rows:    7,398

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-07-02 04:00:00	SPY	ETF	197.15	197.2	197.14	197.14	4015.0
2014-07-02 05:00:00	SPY	ETF	197.19	197.22	197.1	197.17	3406.0
2014-07-02 06:00:00	SPY	ETF	197.17	197.17	197.09	197.1	8161.0
2014-07-02 07:00:00	SPY	ETF	197.15	197.28	197.15	197.27	124122.0
2014-07-02 08:00:00	SPY	ETF	197.27	197.5	197.17	197.22	896930.0
2014-07-02 09:00:00	SPY	ETF	197.21	197.33	196.94	197.16	9271316.0
2014-07-02 10:00:00	SPY	ETF	197.15	197.35	197.03	197.28	7895292.0
2014-07-02 11:00:00	SPY	ETF	197.275	197.48	197.1	197.2	6519402.0
2014-07-02 12:00:00	SPY	ETF	197.2	197.33	197.05	197.2101	3906786.0
2014-07-02 13:00:00	SPY	ETF	197.22	197.24	197.045	197.16	3888389.0
2014-07-02 14:00:00	SPY	ETF	197.16	197.24	197.02	197.11	4092303.0
2014-07-02 15:00:00	SPY	ETF	197.12	197.25	197.06	197.24	10023530.0
2014-07-02 16:00:00	SPY	ETF	197.24	197.32	197.0978	197.3	4401560.0
2014-07-02 17:00:00	SPY	ETF	197.28	197.39	197.28	197.31	144172.0
2014-07-02 18:00:00	SPY	ETF	197.31	197.31	197.24	197.24	66876.0
2014-07-02 19:00:00	SPY	ETF	197.24	197.24	197.21	197.22	70034.0
2014-07-02 05:00:00	QQQ	ETF	95.03	95.03	95.03	95.03	200.0
2014-07-02 07:00:00	QQQ	ETF	95.04	95.05	95.03	95.03	30650.0
2014-07-02 08:00:00	QQQ	ETF	95.03	95.11	95.0	95.02	247175.0
2014-07-02 09:00:00	QQQ	ETF	95.01	95.16	94.94	95.13	3128613.0
2014-07-02 10:00:00	QQQ	ETF	95.13	95.2	95.0	95.1373	3451719.0
2014-07-02 11:00:00	QQQ	ETF	95.13	95.18	94.95	95.11	2339601.0
2014-07-02 12:00:00	QQQ	ETF	95.11	95.24	95.099	95.16	1689719.0
2014-07-02 13:00:00	QQQ	ETF	95.1601	95.18	95.04	95.11	1321665.0
2014-07-02 14:00:00	QQQ	ETF	95.11	95.1195	94.91	94.98	1644757.0
2014-07-02 15:00:00	QQQ	ETF	94.99	95.11	94.99	95.1	2879159.0
2014-07-02 16:00:00	QQQ	ETF	95.11	95.14	94.9958	95.12	1837809.0
2014-07-02 17:00:00	QQQ	ETF	95.12	95.18	95.12	95.17	11800.0
2014-07-02 18:00:00	QQQ	ETF	95.14	95.14	94.99	95.1	2238.0
2014-07-02 19:00:00	QQQ	ETF	95.11	95.11	95.08	95.09	6488.0
2014-07-02 06:00:00	IWM	ETF	119.64	119.64	119.64	119.64	100.0
2014-07-02 07:00:00	IWM	ETF	119.62	119.95	119.6	119.84	138745.0
2014-07-02 08:00:00	IWM	ETF	119.65	119.9	119.57	119.6	140771.0
2014-07-02 09:00:00	IWM	ETF	119.62	119.96	119.39	119.71	3409644.0
2014-07-02 10:00:00	IWM	ETF	119.71	119.87	119.46	119.61	4949024.0
2014-07-02 11:00:00	IWM	ETF	119.61	119.68	119.2	119.34	3814650.0
2014-07-02 12:00:00	IWM	ETF	119.35	119.61	119.29	119.46	1648873.0
2014-07-02 13:00:00	IWM	ETF	119.47	119.471	119.23	119.35	2211062.0
2014-07-02 14:00:00	IWM	ETF	119.36	119.38	119.06	119.13	3019108.0
2014-07-02 15:00:00	IWM	ETF	119.14	119.19	118.89	119.13	5200348.0
2014-07-02 16:00:00	IWM	ETF	119.14	119.73	119.0	119.2	1257551.0
2014-07-02 17:00:00	IWM	ETF	119.21	119.21	119.19	119.19	700.0
2014-07-02 08:00:00	DIA	ETF	169.37	169.48	169.3	169.36	50877.0
2014-07-02 09:00:00	DIA	ETF	169.31	169.51	169.18	169.2894	369789.0
2014-07-02 10:00:00	DIA	ETF	169.29	169.4299	169.24	169.31	291101.0
2014-07-02 11:00:00	DIA	ETF	169.31	169.49	169.19	169.31	284656.0
2014-07-02 12:00:00	DIA	ETF	169.31	169.42	169.258	169.42	153915.0
2014-07-02 13:00:00	DIA	ETF	169.4199	169.44	169.27	169.36	134618.0
2014-07-02 14:00:00	DIA	ETF	169.36	169.43	169.31	169.38	114755.0
2014-07-02 15:00:00	DIA	ETF	169.38	169.44	169.29	169.41	413729.0

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

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