PREVIEW / etf_1hour / 2012-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-01.parquet
  size:    179 KB
  rows:    5,558

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-01 04:00:00	SPY	ETF	138.17	138.48	138.1	138.13	16340.0
2012-08-01 05:00:00	SPY	ETF	138.42	138.53	138.39	138.53	37115.0
2012-08-01 06:00:00	SPY	ETF	138.52	138.6	138.42	138.42	62590.0
2012-08-01 07:00:00	SPY	ETF	138.43	138.5	138.32	138.44	125688.0
2012-08-01 08:00:00	SPY	ETF	138.45	138.58	137.71	138.53	1699332.0
2012-08-01 09:00:00	SPY	ETF	138.55	138.74	137.71	138.36	11497106.0
2012-08-01 10:00:00	SPY	ETF	138.36	138.57	137.98	138.46	20994419.0
2012-08-01 11:00:00	SPY	ETF	138.46	138.52	138.2	138.4	7774155.0
2012-08-01 12:00:00	SPY	ETF	138.39	138.52	138.33	138.47	7116288.0
2012-08-01 13:00:00	SPY	ETF	138.46	138.59	138.14	138.175	7528753.0
2012-08-01 14:00:00	SPY	ETF	138.18	138.26	137.4	137.99	37937241.0
2012-08-01 15:00:00	SPY	ETF	137.98	138.33	137.61	137.62	28651656.0
2012-08-01 16:00:00	SPY	ETF	137.62	138.3	137.531	137.59	12937065.0
2012-08-01 17:00:00	SPY	ETF	137.61	137.67	137.47	137.65	171035.0
2012-08-01 18:00:00	SPY	ETF	137.64	137.8	137.59	137.77	96406.0
2012-08-01 19:00:00	SPY	ETF	137.79	137.88	137.73	137.87	29503.0
2012-08-01 04:00:00	QQQ	ETF	64.77	65.11	64.77	65.11	521.0
2012-08-01 06:00:00	QQQ	ETF	65.13	65.15	65.08	65.08	4400.0
2012-08-01 07:00:00	QQQ	ETF	65.08	65.08	64.98	65.05	198082.0
2012-08-01 08:00:00	QQQ	ETF	65.05	65.21	64.8	65.16	939710.0
2012-08-01 09:00:00	QQQ	ETF	65.17	65.2799	64.91	64.95	2853063.0
2012-08-01 10:00:00	QQQ	ETF	64.94	65.07	64.75	64.91	4133963.0
2012-08-01 11:00:00	QQQ	ETF	64.9	64.95	64.74	64.78	2527139.0
2012-08-01 12:00:00	QQQ	ETF	64.7895	64.94	64.74	64.88	1549288.0
2012-08-01 13:00:00	QQQ	ETF	64.8809	64.95	64.71	64.73	2037701.0
2012-08-01 14:00:00	QQQ	ETF	64.73	64.84	64.35	64.71	7532946.0
2012-08-01 15:00:00	QQQ	ETF	64.71	64.92	64.5701	64.62	4988334.0
2012-08-01 16:00:00	QQQ	ETF	64.62	64.8934	64.49	64.53	422119.0
2012-08-01 17:00:00	QQQ	ETF	64.53	64.8071	64.46	64.57	1006754.0
2012-08-01 18:00:00	QQQ	ETF	64.51	64.58	64.5	64.58	14600.0
2012-08-01 19:00:00	QQQ	ETF	64.6	64.63	64.56	64.61	14000.0
2012-08-01 06:00:00	IWM	ETF	78.92	78.98	78.92	78.98	5000.0
2012-08-01 07:00:00	IWM	ETF	78.93	79.05	78.74	78.75	7700.0
2012-08-01 08:00:00	IWM	ETF	78.77	78.84	78.35	78.75	174358.0
2012-08-01 09:00:00	IWM	ETF	78.78	79.0	78.35	78.44	5487548.0
2012-08-01 10:00:00	IWM	ETF	78.44	78.61	78.19	78.4	4468144.0
2012-08-01 11:00:00	IWM	ETF	78.41	78.44	78.019	78.07	2956405.0
2012-08-01 12:00:00	IWM	ETF	78.06	78.17	78.0	78.13	2091899.0
2012-08-01 13:00:00	IWM	ETF	78.1301	78.29	77.81	77.85	5362737.0
2012-08-01 14:00:00	IWM	ETF	77.85	77.99	77.48	77.78	13719409.0
2012-08-01 15:00:00	IWM	ETF	77.78	77.96	77.04	77.05	12729579.0
2012-08-01 16:00:00	IWM	ETF	77.05	78.4472	76.96	77.05	3411724.0
2012-08-01 17:00:00	IWM	ETF	77.06	77.12	76.98	77.03	82693.0
2012-08-01 18:00:00	IWM	ETF	77.03	77.2	77.02	77.2	37645.0
2012-08-01 19:00:00	IWM	ETF	77.15	77.3	77.15	77.22	700.0
2012-08-01 07:00:00	DIA	ETF	130.16	130.16	130.16	130.16	100.0
2012-08-01 08:00:00	DIA	ETF	130.15	130.28	130.1	130.21	4000.0
2012-08-01 09:00:00	DIA	ETF	130.3	130.5	130.13	130.19	421676.0
2012-08-01 10:00:00	DIA	ETF	130.17	130.32	129.87	130.23	1004248.0
2012-08-01 11:00:00	DIA	ETF	130.22	130.27	130.0	130.16	269844.0

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

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