PREVIEW / etf_1hour / 2012-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-16.parquet
  size:    181 KB
  rows:    5,629

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-03-16 04:00:00	SPY	ETF	140.3	140.38	139.96	140.09	3003.0
2012-03-16 05:00:00	SPY	ETF	140.01	140.05	140.0	140.03	8150.0
2012-03-16 06:00:00	SPY	ETF	140.08	140.15	140.05	140.1	20985.0
2012-03-16 07:00:00	SPY	ETF	140.06	140.33	140.03	140.31	266545.0
2012-03-16 08:00:00	SPY	ETF	140.31	140.46	140.19	140.42	920027.0
2012-03-16 09:00:00	SPY	ETF	140.4	140.45	140.06	140.13	27064451.0
2012-03-16 10:00:00	SPY	ETF	140.13	140.3883	140.0	140.36	23646831.0
2012-03-16 11:00:00	SPY	ETF	140.36	140.43	140.17	140.36	25143620.0
2012-03-16 12:00:00	SPY	ETF	140.36	140.48	140.28	140.31	10143676.0
2012-03-16 13:00:00	SPY	ETF	140.31	140.37	140.27	140.3593	7546583.0
2012-03-16 14:00:00	SPY	ETF	140.3569	140.43	140.33	140.365	7222654.0
2012-03-16 15:00:00	SPY	ETF	140.37	140.4	140.12	140.3	25567171.0
2012-03-16 16:00:00	SPY	ETF	140.31	140.52	140.1348	140.46	21282950.0
2012-03-16 17:00:00	SPY	ETF	140.48	140.54	140.36	140.43	257744.0
2012-03-16 18:00:00	SPY	ETF	140.45	140.46	140.1348	140.41	1098240.0
2012-03-16 19:00:00	SPY	ETF	140.42	140.47	140.4	140.4	15199.0
2012-03-16 07:00:00	QQQ	ETF	66.68	66.78	66.62	66.74	18350.0
2012-03-16 08:00:00	QQQ	ETF	66.78	66.78	66.68	66.76	1165026.0
2012-03-16 09:00:00	QQQ	ETF	66.75	66.75	66.39	66.492	8612075.0
2012-03-16 10:00:00	QQQ	ETF	66.49	66.67	66.36	66.61	6821378.0
2012-03-16 11:00:00	QQQ	ETF	66.62	66.66	66.485	66.61	4104976.0
2012-03-16 12:00:00	QQQ	ETF	66.62	66.63	66.48	66.51	2825500.0
2012-03-16 13:00:00	QQQ	ETF	66.5	66.5712	66.49	66.54	1714179.0
2012-03-16 14:00:00	QQQ	ETF	66.5486	66.6	66.52	66.5201	3639178.0
2012-03-16 15:00:00	QQQ	ETF	66.5299	66.53	66.41	66.49	8393682.0
2012-03-16 16:00:00	QQQ	ETF	66.5	66.6183	65.45	66.56	2058993.0
2012-03-16 17:00:00	QQQ	ETF	66.56	66.57	66.52	66.55	31600.0
2012-03-16 18:00:00	QQQ	ETF	66.51	66.54	66.49	66.54	10100.0
2012-03-16 19:00:00	QQQ	ETF	66.54	66.54	66.54	66.54	800.0
2012-03-16 06:00:00	IWM	ETF	83.09	83.1	83.09	83.1	920.0
2012-03-16 07:00:00	IWM	ETF	83.27	83.29	82.81	83.29	2700.0
2012-03-16 08:00:00	IWM	ETF	83.17	83.3	83.03	83.25	172290.0
2012-03-16 09:00:00	IWM	ETF	83.23	83.2707	82.81	82.91	6587152.0
2012-03-16 10:00:00	IWM	ETF	82.91	83.16	82.65	83.14	6083226.0
2012-03-16 11:00:00	IWM	ETF	83.14	83.19	82.9	83.09	3600170.0
2012-03-16 12:00:00	IWM	ETF	83.1	83.17	83.01	83.075	1822838.0
2012-03-16 13:00:00	IWM	ETF	83.07	83.12	82.955	83.06	1468381.0
2012-03-16 14:00:00	IWM	ETF	83.06	83.11	83.03	83.055	2288279.0
2012-03-16 15:00:00	IWM	ETF	83.04	83.07	82.82	82.99	9932563.0
2012-03-16 16:00:00	IWM	ETF	82.99	83.09	82.96	83.02	6904881.0
2012-03-16 17:00:00	IWM	ETF	83.04	83.05	82.99	83.05	80599.0
2012-03-16 18:00:00	IWM	ETF	83.0	83.0	83.0	83.0	1000.0
2012-03-16 19:00:00	IWM	ETF	83.0	83.0	83.0	83.0	300.0
2012-03-16 08:00:00	DIA	ETF	132.36	132.5	132.31	132.48	6299.0
2012-03-16 09:00:00	DIA	ETF	132.43	132.61	132.18	132.22	781658.0
2012-03-16 10:00:00	DIA	ETF	132.23	132.35	132.09	132.34	886850.0
2012-03-16 11:00:00	DIA	ETF	132.35	132.41	132.16	132.25	473346.0
2012-03-16 12:00:00	DIA	ETF	132.25	132.322	132.2	132.24	380330.0
2012-03-16 13:00:00	DIA	ETF	132.23	132.27	132.19	132.22	631932.0
2012-03-16 14:00:00	DIA	ETF	132.22	132.31	132.21	132.2961	449364.0

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

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