PREVIEW / etf_1hour / 2011-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-15.parquet
  size:    180 KB
  rows:    5,526

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
2011-09-15 04:00:00	SPY	ETF	119.54	119.92	119.54	119.92	3709.0
2011-09-15 05:00:00	SPY	ETF	119.9	120.01	119.64	119.95	19050.0
2011-09-15 06:00:00	SPY	ETF	120.0	120.23	119.9	120.22	56191.0
2011-09-15 07:00:00	SPY	ETF	120.2	120.27	120.0	120.14	1008077.0
2011-09-15 08:00:00	SPY	ETF	120.08	120.2	119.4	119.53	6833253.0
2011-09-15 09:00:00	SPY	ETF	119.54	121.14	119.54	120.34	43913753.0
2011-09-15 10:00:00	SPY	ETF	120.34	120.99	119.64	119.7837	51330748.0
2011-09-15 11:00:00	SPY	ETF	119.79	120.62	119.57	120.51	30650611.0
2011-09-15 12:00:00	SPY	ETF	120.5	120.85	120.34	120.76	16674866.0
2011-09-15 13:00:00	SPY	ETF	120.77	120.99	120.6	120.93	26229765.0
2011-09-15 14:00:00	SPY	ETF	120.94	121.37	120.87	121.29	34394239.0
2011-09-15 15:00:00	SPY	ETF	121.27	121.46	120.87	121.44	66731481.0
2011-09-15 16:00:00	SPY	ETF	121.43	121.7	119.4049	121.42	37822603.0
2011-09-15 17:00:00	SPY	ETF	121.43	122.02	119.4034	121.74	4232513.0
2011-09-15 18:00:00	SPY	ETF	121.78	121.93	121.47	121.62	555623.0
2011-09-15 19:00:00	SPY	ETF	121.6	121.78	121.52	121.52	216933.0
2011-09-15 04:00:00	QQQ	ETF	55.55	55.76	55.55	55.76	5500.0
2011-09-15 05:00:00	QQQ	ETF	55.76	55.76	55.76	55.76	100.0
2011-09-15 06:00:00	QQQ	ETF	55.76	55.84	55.69	55.83	18240.0
2011-09-15 07:00:00	QQQ	ETF	55.84	55.87	55.75	55.78	94316.0
2011-09-15 08:00:00	QQQ	ETF	55.77	55.81	55.5	55.53	1105328.0
2011-09-15 09:00:00	QQQ	ETF	55.53	56.17	55.53	55.78	9340416.0
2011-09-15 10:00:00	QQQ	ETF	55.78	56.03	55.45	55.53	10239810.0
2011-09-15 11:00:00	QQQ	ETF	55.52	55.91	55.39	55.85	6137228.0
2011-09-15 12:00:00	QQQ	ETF	55.8571	56.02	55.77	55.99	4241200.0
2011-09-15 13:00:00	QQQ	ETF	56.0	56.13	55.94	56.09	6360344.0
2011-09-15 14:00:00	QQQ	ETF	56.091	56.24	55.89	56.2	7151941.0
2011-09-15 15:00:00	QQQ	ETF	56.2	56.28	56.03	56.19	11274457.0
2011-09-15 16:00:00	QQQ	ETF	56.19	56.31	56.16	56.19	3875630.0
2011-09-15 17:00:00	QQQ	ETF	56.2	56.45	56.2	56.3	130270.0
2011-09-15 18:00:00	QQQ	ETF	56.32	56.37	56.26	56.29	69222.0
2011-09-15 19:00:00	QQQ	ETF	56.29	56.37	56.22	56.37	24833.0
2011-09-15 04:00:00	IWM	ETF	70.5	70.55	70.43	70.55	688.0
2011-09-15 05:00:00	IWM	ETF	70.3	70.65	70.3	70.65	3614.0
2011-09-15 06:00:00	IWM	ETF	70.65	70.8	70.65	70.77	6600.0
2011-09-15 07:00:00	IWM	ETF	70.89	70.89	70.69	70.75	45252.0
2011-09-15 08:00:00	IWM	ETF	70.87	70.87	70.23	70.28	1506409.0
2011-09-15 09:00:00	IWM	ETF	70.28	71.53	70.28	70.9	11517417.0
2011-09-15 10:00:00	IWM	ETF	70.91	71.33	70.19	70.26	12767247.0
2011-09-15 11:00:00	IWM	ETF	70.26	70.94	69.99	70.83	7159165.0
2011-09-15 12:00:00	IWM	ETF	70.83	71.07	70.72	70.97	4044966.0
2011-09-15 13:00:00	IWM	ETF	70.97	71.1	70.747	70.97	4608876.0
2011-09-15 14:00:00	IWM	ETF	70.98	71.43	70.98	71.35	5140171.0
2011-09-15 15:00:00	IWM	ETF	71.34	71.44	70.93	71.43	12765548.0
2011-09-15 16:00:00	IWM	ETF	71.43	71.61	70.5012	71.45	5082946.0
2011-09-15 17:00:00	IWM	ETF	71.49	71.8	71.47	71.8	78965.0
2011-09-15 18:00:00	IWM	ETF	71.85	71.85	71.7	71.7	4490.0
2011-09-15 19:00:00	IWM	ETF	71.6	71.66	71.57	71.61	13100.0
2011-09-15 07:00:00	DIA	ETF	113.15	113.15	113.0	113.0	400.0
2011-09-15 08:00:00	DIA	ETF	113.0	113.02	112.54	112.6	88564.0

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

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