PREVIEW / etf_1hour / 2012-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-02.parquet
  size:    186 KB
  rows:    5,716

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-04-02 04:00:00	SPY	ETF	141.12	141.27	140.54	140.62	42237.0
2012-04-02 05:00:00	SPY	ETF	140.69	140.94	140.64	140.94	33180.0
2012-04-02 06:00:00	SPY	ETF	140.92	140.92	140.68	140.68	37100.0
2012-04-02 07:00:00	SPY	ETF	140.66	140.84	140.55	140.65	379287.0
2012-04-02 08:00:00	SPY	ETF	140.67	140.85	140.5	140.78	1640983.0
2012-04-02 09:00:00	SPY	ETF	140.78	141.39	140.36	140.63	15781208.0
2012-04-02 10:00:00	SPY	ETF	140.62	141.3	140.61	141.23	24572044.0
2012-04-02 11:00:00	SPY	ETF	141.23	141.9	141.12	141.85	21636605.0
2012-04-02 12:00:00	SPY	ETF	141.85	142.12	141.85	142.03	14571764.0
2012-04-02 13:00:00	SPY	ETF	142.035	142.09	141.97	142.08	9284679.0
2012-04-02 14:00:00	SPY	ETF	142.075	142.18	141.94	142.18	12481439.0
2012-04-02 15:00:00	SPY	ETF	142.18	142.21	141.68	141.8	27628707.0
2012-04-02 16:00:00	SPY	ETF	141.79	141.84	140.38	140.7931	18109437.0
2012-04-02 17:00:00	SPY	ETF	141.58	141.63	141.56	141.57	114188.0
2012-04-02 18:00:00	SPY	ETF	141.57	141.7	141.57	141.63	65217.0
2012-04-02 19:00:00	SPY	ETF	141.62	141.68	141.62	141.67	77313.0
2012-04-02 04:00:00	QQQ	ETF	67.56	67.56	67.56	67.56	3000.0
2012-04-02 05:00:00	QQQ	ETF	67.53	67.53	67.53	67.53	4000.0
2012-04-02 06:00:00	QQQ	ETF	67.54	67.54	67.53	67.53	600.0
2012-04-02 07:00:00	QQQ	ETF	67.53	67.56	67.4	67.45	131340.0
2012-04-02 08:00:00	QQQ	ETF	67.6	67.88	67.38	67.54	1144233.0
2012-04-02 09:00:00	QQQ	ETF	67.51	67.62	67.36	67.4595	4632280.0
2012-04-02 10:00:00	QQQ	ETF	67.45	67.86	67.42	67.8579	8270083.0
2012-04-02 11:00:00	QQQ	ETF	67.855	68.19	67.79	68.142	6623218.0
2012-04-02 12:00:00	QQQ	ETF	68.15	68.3	68.14	68.2399	3676953.0
2012-04-02 13:00:00	QQQ	ETF	68.23	68.3	68.19	68.3	2689252.0
2012-04-02 14:00:00	QQQ	ETF	68.3	68.34	68.22	68.3	3328559.0
2012-04-02 15:00:00	QQQ	ETF	68.31	68.34	68.17	68.25	6266687.0
2012-04-02 16:00:00	QQQ	ETF	68.24	68.2986	68.11	68.16	990422.0
2012-04-02 17:00:00	QQQ	ETF	68.16	68.18	68.15	68.15	23864.0
2012-04-02 18:00:00	QQQ	ETF	68.16	68.22	68.16	68.22	7400.0
2012-04-02 19:00:00	QQQ	ETF	68.21	68.22	68.19	68.21	8570.0
2012-04-02 04:00:00	IWM	ETF	82.84	82.84	82.6	82.6	3050.0
2012-04-02 05:00:00	IWM	ETF	82.74	82.74	82.74	82.74	100.0
2012-04-02 07:00:00	IWM	ETF	82.7	82.73	82.34	82.56	178700.0
2012-04-02 08:00:00	IWM	ETF	82.59	82.85	82.43	82.61	125405.0
2012-04-02 09:00:00	IWM	ETF	82.56	82.85	82.38	82.6	5052974.0
2012-04-02 10:00:00	IWM	ETF	82.61	83.3	82.6	83.14	8817102.0
2012-04-02 11:00:00	IWM	ETF	83.14	83.6	83.1	83.5225	7847775.0
2012-04-02 12:00:00	IWM	ETF	83.53	83.7	83.51	83.62	3687389.0
2012-04-02 13:00:00	IWM	ETF	83.6192	83.72	83.54	83.712	3540437.0
2012-04-02 14:00:00	IWM	ETF	83.72	83.81	83.6	83.803	4042945.0
2012-04-02 15:00:00	IWM	ETF	83.81	83.86	83.57	83.83	8374411.0
2012-04-02 16:00:00	IWM	ETF	83.81	83.87	83.7	83.76	991632.0
2012-04-02 17:00:00	IWM	ETF	83.79	83.81	83.73	83.75	27275.0
2012-04-02 18:00:00	IWM	ETF	83.78	83.78	83.78	83.78	500.0
2012-04-02 19:00:00	IWM	ETF	83.86	83.86	83.86	83.86	100.0
2012-04-02 04:00:00	DIA	ETF	131.75	131.75	131.57	131.57	11000.0
2012-04-02 06:00:00	DIA	ETF	131.71	131.71	131.65	131.65	3300.0
2012-04-02 07:00:00	DIA	ETF	131.65	131.65	131.55	131.55	6200.0

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

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