PREVIEW / etf_1hour / 2012-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-14.parquet
  size:    200 KB
  rows:    6,281

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-09-14 04:00:00	SPY	ETF	146.8	146.8	146.65	146.78	1700.0
2012-09-14 05:00:00	SPY	ETF	146.78	147.0	146.77	146.99	94850.0
2012-09-14 06:00:00	SPY	ETF	146.95	147.13	146.95	147.12	79565.0
2012-09-14 07:00:00	SPY	ETF	147.11	147.17	146.91	146.93	331961.0
2012-09-14 08:00:00	SPY	ETF	146.95	147.17	146.68	146.78	2231038.0
2012-09-14 09:00:00	SPY	ETF	146.77	147.66	146.65	147.38	25453380.0
2012-09-14 10:00:00	SPY	ETF	147.38	148.11	147.37	147.49	31244263.0
2012-09-14 11:00:00	SPY	ETF	147.48	147.58	147.16	147.26	23994856.0
2012-09-14 12:00:00	SPY	ETF	147.26	147.65	147.24	147.41	11762746.0
2012-09-14 13:00:00	SPY	ETF	147.4	147.44	146.95	147.246	10808259.0
2012-09-14 14:00:00	SPY	ETF	147.25	147.37	147.09	147.3	14630059.0
2012-09-14 15:00:00	SPY	ETF	147.3	147.32	146.76	147.2	34313066.0
2012-09-14 16:00:00	SPY	ETF	147.22	148.0	146.6244	147.05	11865139.0
2012-09-14 17:00:00	SPY	ETF	147.05	147.07	146.86	146.93	1593797.0
2012-09-14 18:00:00	SPY	ETF	146.94	146.99	146.9	146.95	78818.0
2012-09-14 19:00:00	SPY	ETF	146.92	147.03	146.92	146.97	25175.0
2012-09-14 05:00:00	QQQ	ETF	69.78	69.78	69.78	69.78	100.0
2012-09-14 06:00:00	QQQ	ETF	69.88	69.89	69.88	69.89	400.0
2012-09-14 07:00:00	QQQ	ETF	69.9	69.91	69.83	69.83	43915.0
2012-09-14 08:00:00	QQQ	ETF	69.84	69.89	69.7	69.72	326071.0
2012-09-14 09:00:00	QQQ	ETF	69.71	70.23	69.58	70.12	9143588.0
2012-09-14 10:00:00	QQQ	ETF	70.12	70.43	70.1	70.27	8134458.0
2012-09-14 11:00:00	QQQ	ETF	70.26	70.35	70.17	70.24	3761809.0
2012-09-14 12:00:00	QQQ	ETF	70.24	70.43	70.21	70.36	1721244.0
2012-09-14 13:00:00	QQQ	ETF	70.36	70.38	70.12	70.1966	3463072.0
2012-09-14 14:00:00	QQQ	ETF	70.2	70.33	70.14	70.31	2752102.0
2012-09-14 15:00:00	QQQ	ETF	70.3	70.31	70.01	70.18	6597516.0
2012-09-14 16:00:00	QQQ	ETF	70.19	70.24	70.0375	70.09	1164273.0
2012-09-14 17:00:00	QQQ	ETF	70.07	70.14	70.07	70.1	7859.0
2012-09-14 18:00:00	QQQ	ETF	70.12	70.17	70.12	70.14	5548.0
2012-09-14 19:00:00	QQQ	ETF	70.12	70.19	70.12	70.13	3150.0
2012-09-14 07:00:00	IWM	ETF	86.1	86.14	85.89	85.93	43468.0
2012-09-14 08:00:00	IWM	ETF	85.96	86.33	85.8	85.82	208059.0
2012-09-14 09:00:00	IWM	ETF	85.8	86.4	85.75	86.36	6498565.0
2012-09-14 10:00:00	IWM	ETF	86.36	86.96	86.36	86.47	11784990.0
2012-09-14 11:00:00	IWM	ETF	86.47	86.8	86.45	86.54	4866105.0
2012-09-14 12:00:00	IWM	ETF	86.5483	86.82	86.53	86.66	2465965.0
2012-09-14 13:00:00	IWM	ETF	86.66	86.71	86.45	86.65	3260086.0
2012-09-14 14:00:00	IWM	ETF	86.66	86.715	86.51	86.66	3003302.0
2012-09-14 15:00:00	IWM	ETF	86.66	86.67	86.285	86.4	6313377.0
2012-09-14 16:00:00	IWM	ETF	86.39	86.76	86.3427	86.49	840510.0
2012-09-14 17:00:00	IWM	ETF	86.49	86.49	86.37	86.37	33500.0
2012-09-14 19:00:00	IWM	ETF	86.44	86.47	86.42	86.42	5350.0
2012-09-14 07:00:00	DIA	ETF	135.75	135.82	135.75	135.82	3100.0
2012-09-14 08:00:00	DIA	ETF	135.75	135.76	135.49	135.54	13300.0
2012-09-14 09:00:00	DIA	ETF	135.5	136.12	135.39	135.94	923623.0
2012-09-14 10:00:00	DIA	ETF	135.93	136.48	135.9	135.992	741388.0
2012-09-14 11:00:00	DIA	ETF	136.0	136.07	135.65	135.7417	986025.0
2012-09-14 12:00:00	DIA	ETF	135.76	136.08	135.75	135.84	319275.0
2012-09-14 13:00:00	DIA	ETF	135.84	135.87	135.5	135.79	435993.0

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

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