PREVIEW / etf_1hour / 2012-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-07.parquet
  size:    185 KB
  rows:    5,805

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-07 04:00:00	SPY	ETF	141.9	141.94	141.79	141.86	36600.0
2012-12-07 05:00:00	SPY	ETF	141.9	141.9	141.85	141.87	15094.0
2012-12-07 06:00:00	SPY	ETF	141.82	141.93	141.73	141.93	43573.0
2012-12-07 07:00:00	SPY	ETF	141.93	141.94	141.59	141.68	257681.0
2012-12-07 08:00:00	SPY	ETF	141.68	142.91	141.57	142.57	5312999.0
2012-12-07 09:00:00	SPY	ETF	142.58	142.69	142.04	142.14	15462819.0
2012-12-07 10:00:00	SPY	ETF	142.14	142.48	141.84	141.96	16470952.0
2012-12-07 11:00:00	SPY	ETF	141.96	142.18	141.67	141.87	14978344.0
2012-12-07 12:00:00	SPY	ETF	141.87	142.14	141.85	142.09	8152766.0
2012-12-07 13:00:00	SPY	ETF	142.085	142.26	142.05	142.12	7992474.0
2012-12-07 14:00:00	SPY	ETF	142.1199	142.37	142.05	142.25	10405402.0
2012-12-07 15:00:00	SPY	ETF	142.2401	142.45	142.08	142.4	18364394.0
2012-12-07 16:00:00	SPY	ETF	142.38	142.4794	142.0135	142.38	9579843.0
2012-12-07 17:00:00	SPY	ETF	142.39	142.42	142.35	142.39	172500.0
2012-12-07 18:00:00	SPY	ETF	142.37	142.37	142.24	142.33	51375.0
2012-12-07 19:00:00	SPY	ETF	142.36	142.4	142.33	142.4	13399.0
2012-12-07 05:00:00	QQQ	ETF	65.21	65.22	65.21	65.22	2000.0
2012-12-07 07:00:00	QQQ	ETF	65.24	65.25	65.18	65.19	8400.0
2012-12-07 08:00:00	QQQ	ETF	65.2	65.75	65.15	65.63	1736650.0
2012-12-07 09:00:00	QQQ	ETF	65.63	65.71	65.13	65.14	3798737.0
2012-12-07 10:00:00	QQQ	ETF	65.14	65.41	64.91	64.98	5435193.0
2012-12-07 11:00:00	QQQ	ETF	64.9801	65.05	64.74	64.76	5301350.0
2012-12-07 12:00:00	QQQ	ETF	64.76	64.94	64.71	64.86	2316444.0
2012-12-07 13:00:00	QQQ	ETF	64.86	64.94	64.77	64.85	1581996.0
2012-12-07 14:00:00	QQQ	ETF	64.85	65.06	64.79	64.9401	3498454.0
2012-12-07 15:00:00	QQQ	ETF	64.9477	65.02	64.79	64.93	4280719.0
2012-12-07 16:00:00	QQQ	ETF	64.92	64.96	64.87	64.88	923602.0
2012-12-07 17:00:00	QQQ	ETF	64.87	64.88	64.82	64.82	3864.0
2012-12-07 18:00:00	QQQ	ETF	64.82	64.88	64.82	64.88	1515.0
2012-12-07 19:00:00	QQQ	ETF	64.9	64.9	64.84	64.84	3320.0
2012-12-07 07:00:00	IWM	ETF	82.0	82.05	81.92	81.98	16700.0
2012-12-07 08:00:00	IWM	ETF	81.96	82.7	81.91	82.59	886085.0
2012-12-07 09:00:00	IWM	ETF	82.61	82.64	81.97	82.02	4846527.0
2012-12-07 10:00:00	IWM	ETF	82.02	82.32	81.92	82.02	3897262.0
2012-12-07 11:00:00	IWM	ETF	82.025	82.19	81.83	81.88	4041514.0
2012-12-07 12:00:00	IWM	ETF	81.88	82.07	81.85	82.025	1395005.0
2012-12-07 13:00:00	IWM	ETF	82.029	82.1	81.965	82.0	1442882.0
2012-12-07 14:00:00	IWM	ETF	82.0	82.24	81.97	82.1	1637726.0
2012-12-07 15:00:00	IWM	ETF	82.1	82.2	81.97	82.16	4148466.0
2012-12-07 16:00:00	IWM	ETF	82.16	82.23	82.0833	82.2	622071.0
2012-12-07 17:00:00	IWM	ETF	82.2	82.21	82.16	82.17	8900.0
2012-12-07 18:00:00	IWM	ETF	82.15	82.15	82.12	82.12	550.0
2012-12-07 19:00:00	IWM	ETF	82.07	82.14	82.07	82.14	610.0
2012-12-07 08:00:00	DIA	ETF	130.48	131.52	130.48	131.28	69625.0
2012-12-07 09:00:00	DIA	ETF	131.33	131.48	131.04	131.109	588399.0
2012-12-07 10:00:00	DIA	ETF	131.15	131.4	130.92	131.04	803228.0
2012-12-07 11:00:00	DIA	ETF	131.04	131.259	130.82	131.06	643540.0
2012-12-07 12:00:00	DIA	ETF	131.06	131.3	131.02	131.25	330485.0
2012-12-07 13:00:00	DIA	ETF	131.25	131.42	131.23	131.26	306948.0
2012-12-07 14:00:00	DIA	ETF	131.27	131.47	131.201	131.37	290997.0

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

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