PREVIEW / etf_1hour / 2012-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-14.parquet
  size:    195 KB
  rows:    6,019

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
2012-11-14 04:00:00	SPY	ETF	138.36	138.82	138.36	138.8	2602.0
2012-11-14 05:00:00	SPY	ETF	138.69	138.71	138.4	138.44	31100.0
2012-11-14 06:00:00	SPY	ETF	138.33	138.48	138.22	138.45	122545.0
2012-11-14 07:00:00	SPY	ETF	138.4	138.47	138.02	138.1	306538.0
2012-11-14 08:00:00	SPY	ETF	138.42	138.48	138.0	138.18	3936614.0
2012-11-14 09:00:00	SPY	ETF	138.18	138.43	137.77	137.87	14754893.0
2012-11-14 10:00:00	SPY	ETF	137.865	138.09	136.91	137.081	32488681.0
2012-11-14 11:00:00	SPY	ETF	137.085	137.54	136.88	137.4801	19204598.0
2012-11-14 12:00:00	SPY	ETF	137.49	137.53	136.96	137.02	13348447.0
2012-11-14 13:00:00	SPY	ETF	137.03	137.43	136.96	137.31	17867723.0
2012-11-14 14:00:00	SPY	ETF	137.3	137.5	136.66	136.69	22861223.0
2012-11-14 15:00:00	SPY	ETF	136.7	136.74	135.62	135.92	49667352.0
2012-11-14 16:00:00	SPY	ETF	135.93	137.8328	135.7988	136.11	13651506.0
2012-11-14 17:00:00	SPY	ETF	136.11	136.11	135.9287	135.99	2315392.0
2012-11-14 18:00:00	SPY	ETF	136.0	136.23	135.99	136.1	100766.0
2012-11-14 19:00:00	SPY	ETF	136.1	136.14	136.0	136.01	54274.0
2012-11-14 20:00:00	SPY	ETF	136.03	136.03	136.03	136.03	400.0
2012-11-14 04:00:00	QQQ	ETF	63.53	63.57	63.53	63.57	5400.0
2012-11-14 05:00:00	QQQ	ETF	63.47	63.47	63.4	63.4	1200.0
2012-11-14 06:00:00	QQQ	ETF	63.4	63.4	63.34	63.34	60850.0
2012-11-14 07:00:00	QQQ	ETF	63.38	63.4	63.22	63.22	290961.0
2012-11-14 08:00:00	QQQ	ETF	63.22	63.38	63.19	63.26	2209005.0
2012-11-14 09:00:00	QQQ	ETF	63.26	63.36	63.08	63.15	6301649.0
2012-11-14 10:00:00	QQQ	ETF	63.15	63.25	62.69	62.77	11419017.0
2012-11-14 11:00:00	QQQ	ETF	62.76	63.05	62.68	63.01	5520304.0
2012-11-14 12:00:00	QQQ	ETF	63.01	63.03	62.74	62.77	2953572.0
2012-11-14 13:00:00	QQQ	ETF	62.77	62.94	62.72	62.87	3795913.0
2012-11-14 14:00:00	QQQ	ETF	62.8613	62.945	62.55	62.58	5125239.0
2012-11-14 15:00:00	QQQ	ETF	62.579	62.59	62.14	62.23	11482252.0
2012-11-14 16:00:00	QQQ	ETF	62.24	63.02	62.2	62.27	12830615.0
2012-11-14 17:00:00	QQQ	ETF	62.28	62.9684	62.2	62.2	11033049.0
2012-11-14 18:00:00	QQQ	ETF	62.25	62.34	62.25	62.32	32908.0
2012-11-14 19:00:00	QQQ	ETF	62.25	62.29	62.24	62.26	9708.0
2012-11-14 04:00:00	IWM	ETF	79.34	79.34	79.34	79.34	1500.0
2012-11-14 05:00:00	IWM	ETF	79.27	79.27	79.27	79.27	500.0
2012-11-14 06:00:00	IWM	ETF	79.03	79.03	79.03	79.03	800.0
2012-11-14 07:00:00	IWM	ETF	79.08	79.12	78.9	78.94	148390.0
2012-11-14 08:00:00	IWM	ETF	78.89	79.07	78.83	78.95	133167.0
2012-11-14 09:00:00	IWM	ETF	78.93	79.1	78.53	78.62	4013080.0
2012-11-14 10:00:00	IWM	ETF	78.62	78.78	77.8599	77.98	8644032.0
2012-11-14 11:00:00	IWM	ETF	77.97	78.32	77.88	78.25	5841953.0
2012-11-14 12:00:00	IWM	ETF	78.25	78.25	77.8999	77.93	2586054.0
2012-11-14 13:00:00	IWM	ETF	77.93	78.12	77.78	78.0	3762338.0
2012-11-14 14:00:00	IWM	ETF	78.0	78.16	77.6	77.6	5384600.0
2012-11-14 15:00:00	IWM	ETF	77.6	77.61	77.06	77.28	11272865.0
2012-11-14 16:00:00	IWM	ETF	77.29	77.65	77.1594	77.37	1658069.0
2012-11-14 17:00:00	IWM	ETF	77.32	77.35	77.31	77.35	21900.0
2012-11-14 18:00:00	IWM	ETF	77.38	77.41	77.38	77.38	1300.0
2012-11-14 19:00:00	IWM	ETF	77.38	77.38	77.28	77.28	1100.0
2012-11-14 07:00:00	DIA	ETF	128.05	128.09	127.8	127.8	2100.0

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

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