PREVIEW / etf_1hour / 2012-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-10.parquet
  size:    184 KB
  rows:    5,779

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-10 04:00:00	SPY	ETF	143.99	144.15	143.98	144.12	38693.0
2012-09-10 05:00:00	SPY	ETF	144.12	144.2	144.12	144.19	358.0
2012-09-10 06:00:00	SPY	ETF	144.2	144.2	144.16	144.18	19605.0
2012-09-10 07:00:00	SPY	ETF	144.2	144.2	144.09	144.16	129050.0
2012-09-10 08:00:00	SPY	ETF	144.2	144.22	144.04	144.07	623617.0
2012-09-10 09:00:00	SPY	ETF	144.08	144.28	144.0	144.21	14064993.0
2012-09-10 10:00:00	SPY	ETF	144.2	144.44	144.155	144.25	12870593.0
2012-09-10 11:00:00	SPY	ETF	144.25	144.38	144.18	144.29	5596122.0
2012-09-10 12:00:00	SPY	ETF	144.29	144.37	144.12	144.23	6068841.0
2012-09-10 13:00:00	SPY	ETF	144.23	144.34	144.03	144.04	5707740.0
2012-09-10 14:00:00	SPY	ETF	144.05	144.16	143.92	143.935	8405209.0
2012-09-10 15:00:00	SPY	ETF	143.935	144.3622	143.46	143.53	19835752.0
2012-09-10 16:00:00	SPY	ETF	143.54	144.18	143.06	143.1	7605005.0
2012-09-10 17:00:00	SPY	ETF	143.13	143.19	143.1	143.15	1224659.0
2012-09-10 18:00:00	SPY	ETF	143.15	143.27	143.15	143.23	187053.0
2012-09-10 19:00:00	SPY	ETF	143.25	143.3	143.2	143.24	47840.0
2012-09-10 07:00:00	QQQ	ETF	69.23	69.27	69.23	69.27	11000.0
2012-09-10 08:00:00	QQQ	ETF	69.28	69.29	69.22	69.23	227133.0
2012-09-10 09:00:00	QQQ	ETF	69.23	69.4	69.13	69.16	3999255.0
2012-09-10 10:00:00	QQQ	ETF	69.16	69.2699	68.96	69.04	4723666.0
2012-09-10 11:00:00	QQQ	ETF	69.04	69.15	68.99	69.12	1370675.0
2012-09-10 12:00:00	QQQ	ETF	69.13	69.14	68.94	69.0283	1627259.0
2012-09-10 13:00:00	QQQ	ETF	69.02	69.08	68.83	68.835	1440234.0
2012-09-10 14:00:00	QQQ	ETF	68.83	68.9	68.65	68.6517	3611619.0
2012-09-10 15:00:00	QQQ	ETF	68.651	68.74	68.49	68.55	6874286.0
2012-09-10 16:00:00	QQQ	ETF	68.545	69.0091	68.39	68.42	983991.0
2012-09-10 17:00:00	QQQ	ETF	68.43	68.48	68.43	68.45	22073.0
2012-09-10 18:00:00	QQQ	ETF	68.45	68.49	68.45	68.47	24276.0
2012-09-10 19:00:00	QQQ	ETF	68.47	68.49	68.47	68.48	11200.0
2012-09-10 07:00:00	IWM	ETF	84.16	84.16	84.1	84.13	10900.0
2012-09-10 08:00:00	IWM	ETF	84.15	84.18	84.1	84.16	306943.0
2012-09-10 09:00:00	IWM	ETF	84.13	84.24	83.95	84.1301	5280454.0
2012-09-10 10:00:00	IWM	ETF	84.13	84.21	83.92	84.03	5940465.0
2012-09-10 11:00:00	IWM	ETF	84.03	84.22	83.98	84.19	2255704.0
2012-09-10 12:00:00	IWM	ETF	84.2	84.27	84.08	84.26	2557136.0
2012-09-10 13:00:00	IWM	ETF	84.26	84.45	84.16	84.188	2935510.0
2012-09-10 14:00:00	IWM	ETF	84.19	84.32	84.08	84.13	2460486.0
2012-09-10 15:00:00	IWM	ETF	84.14	84.19	83.79	83.87	5333764.0
2012-09-10 16:00:00	IWM	ETF	83.87	84.4	83.58	83.63	2235165.0
2012-09-10 17:00:00	IWM	ETF	83.65	83.68	83.62	83.62	1931.0
2012-09-10 18:00:00	IWM	ETF	83.7	83.77	83.69	83.77	3254.0
2012-09-10 19:00:00	IWM	ETF	83.8	83.8	83.79	83.79	600.0
2012-09-10 07:00:00	DIA	ETF	132.73	132.73	132.73	132.73	100.0
2012-09-10 08:00:00	DIA	ETF	132.75	132.75	132.7	132.7	1125.0
2012-09-10 09:00:00	DIA	ETF	132.68	132.84	132.61	132.75	385947.0
2012-09-10 10:00:00	DIA	ETF	132.77	133.03	132.75	132.97	306200.0
2012-09-10 11:00:00	DIA	ETF	132.98	133.16	132.92	133.02	274062.0
2012-09-10 12:00:00	DIA	ETF	133.03	133.0635	132.93	132.983	124999.0
2012-09-10 13:00:00	DIA	ETF	133.0	133.09	132.8301	132.8301	86540.0
2012-09-10 14:00:00	DIA	ETF	132.87	132.96	132.77	132.8	326631.0

> showing 50 of 5,779 rows — these rows as CSV

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