PREVIEW / etf_1hour / 2012-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-11.parquet
  size:    191 KB
  rows:    5,996

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-12-11 04:00:00	SPY	ETF	142.54	142.9	142.53	142.9	44657.0
2012-12-11 05:00:00	SPY	ETF	142.88	143.07	142.88	142.94	99909.0
2012-12-11 06:00:00	SPY	ETF	142.95	143.05	142.92	143.05	198125.0
2012-12-11 07:00:00	SPY	ETF	143.05	143.17	142.95	143.09	249418.0
2012-12-11 08:00:00	SPY	ETF	143.08	143.14	142.86	143.06	613258.0
2012-12-11 09:00:00	SPY	ETF	143.07	143.461	142.99	143.46	14513763.0
2012-12-11 10:00:00	SPY	ETF	143.45	143.81	143.45	143.65	23978547.0
2012-12-11 11:00:00	SPY	ETF	143.66	144.11	143.61	143.79	16238592.0
2012-12-11 12:00:00	SPY	ETF	143.8	143.96	143.515	143.805	15660485.0
2012-12-11 13:00:00	SPY	ETF	143.79	143.85	143.68	143.749	5895673.0
2012-12-11 14:00:00	SPY	ETF	143.75	143.82	143.35	143.42	13032073.0
2012-12-11 15:00:00	SPY	ETF	143.41	143.5	143.03	143.43	32718392.0
2012-12-11 16:00:00	SPY	ETF	143.42	143.93	142.4789	143.89	22114239.0
2012-12-11 17:00:00	SPY	ETF	143.88	143.9	143.7306	143.81	5657083.0
2012-12-11 18:00:00	SPY	ETF	143.82	143.82	143.72	143.77	87019.0
2012-12-11 19:00:00	SPY	ETF	143.77	143.82	143.66	143.72	139452.0
2012-12-11 05:00:00	QQQ	ETF	65.37	65.37	65.37	65.37	2400.0
2012-12-11 06:00:00	QQQ	ETF	65.34	65.37	65.34	65.37	2300.0
2012-12-11 07:00:00	QQQ	ETF	65.33	65.42	65.33	65.42	28326.0
2012-12-11 08:00:00	QQQ	ETF	65.4	65.52	65.4	65.45	72710.0
2012-12-11 09:00:00	QQQ	ETF	65.48	65.94	65.46	65.92	5399040.0
2012-12-11 10:00:00	QQQ	ETF	65.93	66.19	65.86	66.11	6612533.0
2012-12-11 11:00:00	QQQ	ETF	66.11	66.34	66.1	66.14	5400459.0
2012-12-11 12:00:00	QQQ	ETF	66.14	66.25	66.01	66.181	2991161.0
2012-12-11 13:00:00	QQQ	ETF	66.185	66.21	66.1	66.191	1411087.0
2012-12-11 14:00:00	QQQ	ETF	66.192	66.255	65.97	66.02	2833104.0
2012-12-11 15:00:00	QQQ	ETF	66.0153	66.06	65.78	65.98	7554519.0
2012-12-11 16:00:00	QQQ	ETF	66.01	66.15	65.114	66.15	3525695.0
2012-12-11 17:00:00	QQQ	ETF	66.12	66.12	65.114	66.12	1018232.0
2012-12-11 18:00:00	QQQ	ETF	66.1	66.1	66.06	66.06	6100.0
2012-12-11 19:00:00	QQQ	ETF	66.1	66.1	66.05	66.1	10866.0
2012-12-11 06:00:00	IWM	ETF	83.3	83.31	83.3	83.31	1960.0
2012-12-11 07:00:00	IWM	ETF	83.35	83.38	83.22	83.23	80772.0
2012-12-11 08:00:00	IWM	ETF	83.25	83.29	83.14	83.15	171004.0
2012-12-11 09:00:00	IWM	ETF	83.17	83.29	82.92	83.25	4732947.0
2012-12-11 10:00:00	IWM	ETF	83.24	83.41	83.21	83.32	6345066.0
2012-12-11 11:00:00	IWM	ETF	83.315	83.56	83.29	83.42	4661895.0
2012-12-11 12:00:00	IWM	ETF	83.42	83.56	83.275	83.51	3455357.0
2012-12-11 13:00:00	IWM	ETF	83.52	83.55	83.44	83.46	1344806.0
2012-12-11 14:00:00	IWM	ETF	83.46	83.51	83.279	83.32	2579284.0
2012-12-11 15:00:00	IWM	ETF	83.32	83.46	83.0975	83.38	7188088.0
2012-12-11 16:00:00	IWM	ETF	83.38	83.68	82.5569	83.67	3807949.0
2012-12-11 17:00:00	IWM	ETF	83.62	83.62	83.62	83.62	21475.0
2012-12-11 18:00:00	IWM	ETF	83.62	83.62	83.47	83.47	300.0
2012-12-11 19:00:00	IWM	ETF	83.63	83.64	83.58	83.64	4900.0
2012-12-11 04:00:00	DIA	ETF	131.9	131.9	131.9	131.9	100.0
2012-12-11 05:00:00	DIA	ETF	132.26	132.26	132.26	132.26	100.0
2012-12-11 07:00:00	DIA	ETF	132.17	132.33	132.17	132.3	2000.0
2012-12-11 08:00:00	DIA	ETF	132.25	132.29	132.18	132.19	6137.0
2012-12-11 09:00:00	DIA	ETF	132.2	132.57	132.18	132.57	600077.0

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

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