PREVIEW / etf_1hour / 2012-05-22

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-22.parquet
  size:    192 KB
  rows:    5,955

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-05-22 04:00:00	SPY	ETF	132.35	132.38	132.27	132.27	3832.0
2012-05-22 05:00:00	SPY	ETF	131.95	132.14	131.91	132.01	20120.0
2012-05-22 06:00:00	SPY	ETF	131.9	131.96	131.8	131.88	29390.0
2012-05-22 07:00:00	SPY	ETF	131.99	132.56	131.99	132.54	1367030.0
2012-05-22 08:00:00	SPY	ETF	132.5	132.6	132.1	132.17	2905268.0
2012-05-22 09:00:00	SPY	ETF	132.18	132.52	131.88	132.26	21109983.0
2012-05-22 10:00:00	SPY	ETF	132.25	133.17	132.25	133.13	30692803.0
2012-05-22 11:00:00	SPY	ETF	133.14	133.23	132.72	132.76	21213263.0
2012-05-22 12:00:00	SPY	ETF	132.77	132.83	132.32	132.7199	19058412.0
2012-05-22 13:00:00	SPY	ETF	132.715	132.88	132.33	132.5325	14583534.0
2012-05-22 14:00:00	SPY	ETF	132.53	132.87	132.44	132.57	14050398.0
2012-05-22 15:00:00	SPY	ETF	132.56	132.66	131.34	132.07	49943726.0
2012-05-22 16:00:00	SPY	ETF	132.09	132.34	131.8	131.98	20018858.0
2012-05-22 17:00:00	SPY	ETF	132.01	132.06	131.91	131.91	276881.0
2012-05-22 18:00:00	SPY	ETF	131.91	131.96	131.82	131.86	158942.0
2012-05-22 19:00:00	SPY	ETF	131.86	131.86	131.65	131.71	122511.0
2012-05-22 05:00:00	QQQ	ETF	62.46	62.46	62.44	62.46	20000.0
2012-05-22 06:00:00	QQQ	ETF	62.39	62.41	62.38	62.41	7000.0
2012-05-22 07:00:00	QQQ	ETF	62.44	62.74	62.44	62.74	455488.0
2012-05-22 08:00:00	QQQ	ETF	62.72	62.77	62.52	62.57	2214966.0
2012-05-22 09:00:00	QQQ	ETF	62.57	62.77	62.4199	62.6372	7337250.0
2012-05-22 10:00:00	QQQ	ETF	62.63	62.95	62.6	62.82	8987522.0
2012-05-22 11:00:00	QQQ	ETF	62.8201	62.9301	62.7	62.7201	5290050.0
2012-05-22 12:00:00	QQQ	ETF	62.72	62.78	62.48	62.75	5408081.0
2012-05-22 13:00:00	QQQ	ETF	62.75	62.87	62.51	62.6	4050378.0
2012-05-22 14:00:00	QQQ	ETF	62.61	62.81	62.525	62.57	4435516.0
2012-05-22 15:00:00	QQQ	ETF	62.57	62.65	61.989	62.41	11877527.0
2012-05-22 16:00:00	QQQ	ETF	62.41	62.6174	62.211	62.32	7991130.0
2012-05-22 17:00:00	QQQ	ETF	62.35	62.35	62.29	62.31	20947.0
2012-05-22 18:00:00	QQQ	ETF	62.3	62.32	62.26	62.29	11080.0
2012-05-22 19:00:00	QQQ	ETF	62.29	62.29	62.21	62.25	10900.0
2012-05-22 05:00:00	IWM	ETF	76.25	76.27	76.25	76.27	2425.0
2012-05-22 07:00:00	IWM	ETF	76.29	76.68	76.29	76.68	149809.0
2012-05-22 08:00:00	IWM	ETF	76.6	76.66	76.29	76.37	635335.0
2012-05-22 09:00:00	IWM	ETF	76.31	76.73	76.21	76.45	5880457.0
2012-05-22 10:00:00	IWM	ETF	76.46	77.03	76.37	76.88	8943653.0
2012-05-22 11:00:00	IWM	ETF	76.87	76.925	76.53	76.55	5698451.0
2012-05-22 12:00:00	IWM	ETF	76.55	76.59	76.03	76.5399	5835395.0
2012-05-22 13:00:00	IWM	ETF	76.54	76.67	76.12	76.22	3852522.0
2012-05-22 14:00:00	IWM	ETF	76.23	76.49	76.17	76.34	3957876.0
2012-05-22 15:00:00	IWM	ETF	76.34	76.41	75.47	75.99	14352365.0
2012-05-22 16:00:00	IWM	ETF	75.99	76.7828	75.6526	75.79	5531233.0
2012-05-22 17:00:00	IWM	ETF	75.8	75.86	75.79	75.79	9800.0
2012-05-22 18:00:00	IWM	ETF	75.79	75.93	75.79	75.93	1992.0
2012-05-22 19:00:00	IWM	ETF	75.67	75.92	75.67	75.68	7358.0
2012-05-22 07:00:00	DIA	ETF	124.87	125.11	124.87	125.11	38400.0
2012-05-22 08:00:00	DIA	ETF	125.05	125.13	124.75	124.83	30432.0
2012-05-22 09:00:00	DIA	ETF	124.8	124.92	124.55	124.69	833202.0
2012-05-22 10:00:00	DIA	ETF	124.7	125.44	124.66	125.41	1259420.0
2012-05-22 11:00:00	DIA	ETF	125.4	125.48	125.1929	125.22	982647.0

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

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