PREVIEW / etf_1hour / 2012-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-02.parquet
  size:    182 KB
  rows:    5,732

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-08-02 04:00:00	SPY	ETF	137.6	137.7	137.6	137.7	5200.0
2012-08-02 05:00:00	SPY	ETF	137.96	138.27	137.96	138.27	23346.0
2012-08-02 06:00:00	SPY	ETF	138.24	138.27	138.07	138.18	69820.0
2012-08-02 07:00:00	SPY	ETF	138.15	138.32	137.51	138.14	1162558.0
2012-08-02 08:00:00	SPY	ETF	138.16	138.93	136.4	136.57	13891017.0
2012-08-02 09:00:00	SPY	ETF	136.55	137.11	136.21	137.04	25055772.0
2012-08-02 10:00:00	SPY	ETF	137.05	137.57	136.75	136.86	32194724.0
2012-08-02 11:00:00	SPY	ETF	136.86	137.02	135.91	136.16	31275368.0
2012-08-02 12:00:00	SPY	ETF	136.15	136.28	135.58	136.0699	16256785.0
2012-08-02 13:00:00	SPY	ETF	136.07	136.4	135.84	135.859	9976209.0
2012-08-02 14:00:00	SPY	ETF	135.85	136.43	135.77	136.18	14584159.0
2012-08-02 15:00:00	SPY	ETF	136.19	136.78	136.18	136.66	37471727.0
2012-08-02 16:00:00	SPY	ETF	136.66	136.85	135.94	136.81	11304407.0
2012-08-02 17:00:00	SPY	ETF	136.81	136.81	136.7	136.73	1616418.0
2012-08-02 18:00:00	SPY	ETF	136.73	136.76	136.68	136.76	60648.0
2012-08-02 19:00:00	SPY	ETF	136.76	136.77	136.71	136.75	76488.0
2012-08-02 06:00:00	QQQ	ETF	64.72	64.77	64.72	64.77	400.0
2012-08-02 07:00:00	QQQ	ETF	64.71	64.76	64.58	64.68	16250.0
2012-08-02 08:00:00	QQQ	ETF	64.77	65.09	63.96	64.04	1169441.0
2012-08-02 09:00:00	QQQ	ETF	64.03	64.68	63.91	64.658	6016799.0
2012-08-02 10:00:00	QQQ	ETF	64.64	65.02	64.5098	64.63	8792808.0
2012-08-02 11:00:00	QQQ	ETF	64.62	64.71	64.05	64.2	7527514.0
2012-08-02 12:00:00	QQQ	ETF	64.19	64.28	63.965	64.18	3588827.0
2012-08-02 13:00:00	QQQ	ETF	64.18	64.23	64.04	64.05	1859238.0
2012-08-02 14:00:00	QQQ	ETF	64.0415	64.32	64.02	64.21	3478294.0
2012-08-02 15:00:00	QQQ	ETF	64.21	64.49	64.2	64.37	4717236.0
2012-08-02 16:00:00	QQQ	ETF	64.38	64.48	64.29	64.36	951139.0
2012-08-02 17:00:00	QQQ	ETF	64.34	64.34	64.34	64.34	1500.0
2012-08-02 18:00:00	QQQ	ETF	64.35	64.36	64.32	64.36	24039.0
2012-08-02 19:00:00	QQQ	ETF	64.37	64.38	64.34	64.37	6750.0
2012-08-02 06:00:00	IWM	ETF	77.05	77.06	77.05	77.06	2000.0
2012-08-02 07:00:00	IWM	ETF	77.39	77.4	77.34	77.34	4300.0
2012-08-02 08:00:00	IWM	ETF	77.42	77.9	76.3	76.37	1872165.0
2012-08-02 09:00:00	IWM	ETF	76.35	76.94	76.23	76.91	6868757.0
2012-08-02 10:00:00	IWM	ETF	76.91	77.305	76.75	76.84	8557543.0
2012-08-02 11:00:00	IWM	ETF	76.84	76.95	76.36	76.53	5669450.0
2012-08-02 12:00:00	IWM	ETF	76.54	76.61	76.25	76.49	2439661.0
2012-08-02 13:00:00	IWM	ETF	76.5	76.6	76.3901	76.3919	2039684.0
2012-08-02 14:00:00	IWM	ETF	76.39	76.79	76.32	76.6	3867506.0
2012-08-02 15:00:00	IWM	ETF	76.6	76.79	76.54	76.77	5564564.0
2012-08-02 16:00:00	IWM	ETF	76.78	76.95	76.6987	76.84	911072.0
2012-08-02 17:00:00	IWM	ETF	76.81	76.81	76.77	76.77	875.0
2012-08-02 18:00:00	IWM	ETF	76.81	76.81	76.81	76.81	202.0
2012-08-02 19:00:00	IWM	ETF	76.82	76.86	76.82	76.83	3257.0
2012-08-02 06:00:00	DIA	ETF	129.48	129.48	129.48	129.48	150.0
2012-08-02 07:00:00	DIA	ETF	129.91	129.95	129.9	129.95	2350.0
2012-08-02 08:00:00	DIA	ETF	130.13	130.5	128.75	128.75	11462.0
2012-08-02 09:00:00	DIA	ETF	128.55	128.84	128.22	128.77	1569394.0
2012-08-02 10:00:00	DIA	ETF	128.73	129.29	128.54	128.67	1687330.0
2012-08-02 11:00:00	DIA	ETF	128.66	128.78	127.79	128.02	1565561.0

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

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