PREVIEW / etf_1hour / 2012-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-27.parquet
  size:    183 KB
  rows:    5,674

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-01-27 04:00:00	SPY	ETF	132.04	132.11	131.97	132.11	1500.0
2012-01-27 05:00:00	SPY	ETF	132.19	132.33	132.12	132.32	62150.0
2012-01-27 06:00:00	SPY	ETF	132.22	132.22	132.06	132.06	29037.0
2012-01-27 07:00:00	SPY	ETF	132.1	132.19	131.95	132.17	276230.0
2012-01-27 08:00:00	SPY	ETF	132.14	132.19	131.14	131.23	3753590.0
2012-01-27 09:00:00	SPY	ETF	131.23	131.86	131.15	131.75	18091700.0
2012-01-27 10:00:00	SPY	ETF	131.75	131.8	131.28	131.53	22595162.0
2012-01-27 11:00:00	SPY	ETF	131.52	131.72	131.23	131.45	16375187.0
2012-01-27 12:00:00	SPY	ETF	131.46	131.6	131.16	131.24	17330235.0
2012-01-27 13:00:00	SPY	ETF	131.24	131.6738	131.18	131.63	12339805.0
2012-01-27 14:00:00	SPY	ETF	131.62	131.79	131.45	131.72	11398993.0
2012-01-27 15:00:00	SPY	ETF	131.72	132.05	131.68	131.71	23891524.0
2012-01-27 16:00:00	SPY	ETF	131.71	132.14	131.5847	131.8	7284770.0
2012-01-27 17:00:00	SPY	ETF	131.8	131.82	131.77	131.81	762609.0
2012-01-27 18:00:00	SPY	ETF	131.81	131.83	131.78	131.8	34278.0
2012-01-27 19:00:00	SPY	ETF	131.8	131.85	131.75	131.84	39596.0
2012-01-27 05:00:00	QQQ	ETF	60.35	60.45	60.35	60.45	1700.0
2012-01-27 06:00:00	QQQ	ETF	60.45	60.45	60.36	60.36	14600.0
2012-01-27 07:00:00	QQQ	ETF	60.36	60.46	60.34	60.43	81471.0
2012-01-27 08:00:00	QQQ	ETF	60.41	60.42	60.02	60.04	798861.0
2012-01-27 09:00:00	QQQ	ETF	60.06	60.38	60.04	60.33	6755635.0
2012-01-27 10:00:00	QQQ	ETF	60.34	60.38	60.12	60.25	7584588.0
2012-01-27 11:00:00	QQQ	ETF	60.26	60.3605	60.16	60.23	4284795.0
2012-01-27 12:00:00	QQQ	ETF	60.24	60.31	60.14	60.1701	3370544.0
2012-01-27 13:00:00	QQQ	ETF	60.18	60.35	60.149	60.319	3006846.0
2012-01-27 14:00:00	QQQ	ETF	60.32	60.365	60.23	60.34	3743913.0
2012-01-27 15:00:00	QQQ	ETF	60.335	60.51	60.32	60.37	5273885.0
2012-01-27 16:00:00	QQQ	ETF	60.37	60.45	60.28	60.36	1517336.0
2012-01-27 17:00:00	QQQ	ETF	60.36	60.37	60.34	60.37	394577.0
2012-01-27 18:00:00	QQQ	ETF	60.37	60.37	60.34	60.36	6828.0
2012-01-27 19:00:00	QQQ	ETF	60.35	60.37	60.34	60.37	7747.0
2012-01-27 06:00:00	IWM	ETF	79.5	79.5	79.5	79.5	300.0
2012-01-27 07:00:00	IWM	ETF	79.36	79.43	79.33	79.4	1880.0
2012-01-27 08:00:00	IWM	ETF	79.44	79.88	77.89	78.76	800774.0
2012-01-27 09:00:00	IWM	ETF	78.75	79.37	78.75	79.27	6139819.0
2012-01-27 10:00:00	IWM	ETF	79.28	79.46	78.96	79.39	9756669.0
2012-01-27 11:00:00	IWM	ETF	79.39	79.66	79.35	79.49	6321927.0
2012-01-27 12:00:00	IWM	ETF	79.5	79.6	79.26	79.2958	3681575.0
2012-01-27 13:00:00	IWM	ETF	79.3	79.67	79.23	79.6	3719096.0
2012-01-27 14:00:00	IWM	ETF	79.61	79.71	79.49	79.64	4073299.0
2012-01-27 15:00:00	IWM	ETF	79.64	79.78	79.62	79.72	7975616.0
2012-01-27 16:00:00	IWM	ETF	79.71	79.85	79.1315	79.67	2754422.0
2012-01-27 17:00:00	IWM	ETF	79.67	79.68	79.65	79.68	17961.0
2012-01-27 18:00:00	IWM	ETF	79.68	79.68	79.63	79.63	4984.0
2012-01-27 07:00:00	DIA	ETF	127.2	127.29	127.2	127.29	800.0
2012-01-27 08:00:00	DIA	ETF	127.3	127.4	126.48	126.52	19300.0
2012-01-27 09:00:00	DIA	ETF	126.57	126.76	126.36	126.68	646568.0
2012-01-27 10:00:00	DIA	ETF	126.69	126.72	126.22	126.43	1159522.0
2012-01-27 11:00:00	DIA	ETF	126.45	126.56	126.08	126.27	879622.0
2012-01-27 12:00:00	DIA	ETF	126.27	126.39	126.01	126.08	810812.0

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

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