PREVIEW / etf_1hour / 2011-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-23.parquet
  size:    185 KB
  rows:    5,750

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
2011-05-23 04:00:00	SPY	ETF	132.6	132.6	132.08	132.24	10637.0
2011-05-23 05:00:00	SPY	ETF	132.26	132.26	131.76	132.04	45425.0
2011-05-23 06:00:00	SPY	ETF	132.09	132.23	131.96	132.0	192001.0
2011-05-23 07:00:00	SPY	ETF	132.0	132.33	131.96	132.16	384227.0
2011-05-23 08:00:00	SPY	ETF	132.16	133.07	131.97	132.18	3218873.0
2011-05-23 09:00:00	SPY	ETF	132.18	132.25	131.74	132.065	23926258.0
2011-05-23 10:00:00	SPY	ETF	132.06	132.28	131.87	132.0	25628052.0
2011-05-23 11:00:00	SPY	ETF	132.0	132.19	131.65	131.82	21958592.0
2011-05-23 12:00:00	SPY	ETF	131.81	132.03	131.59	131.97	16009287.0
2011-05-23 13:00:00	SPY	ETF	131.96	133.6475	131.76	132.04	11986520.0
2011-05-23 14:00:00	SPY	ETF	132.04	132.46	132.0	132.28	17834701.0
2011-05-23 15:00:00	SPY	ETF	132.25	132.435	131.96	132.04	35032607.0
2011-05-23 16:00:00	SPY	ETF	132.05	132.0795	131.75	131.93	10309595.0
2011-05-23 17:00:00	SPY	ETF	131.95	132.0	131.89	131.95	74541.0
2011-05-23 18:00:00	SPY	ETF	131.94	132.04	131.85	131.88	294343.0
2011-05-23 19:00:00	SPY	ETF	131.87	131.92	131.76	131.88	156585.0
2011-05-23 04:00:00	QQQ	ETF	57.4	57.4	57.12	57.12	623.0
2011-05-23 05:00:00	QQQ	ETF	57.06	57.08	56.98	57.04	1300.0
2011-05-23 06:00:00	QQQ	ETF	57.09	57.12	57.04	57.05	8800.0
2011-05-23 07:00:00	QQQ	ETF	57.07	57.14	57.02	57.07	39056.0
2011-05-23 08:00:00	QQQ	ETF	57.07	57.26	57.0	57.1	449343.0
2011-05-23 09:00:00	QQQ	ETF	57.09	57.09	56.67	56.755	5792560.0
2011-05-23 10:00:00	QQQ	ETF	56.75	56.88	56.65	56.79	6642149.0
2011-05-23 11:00:00	QQQ	ETF	56.78	56.87	56.66	56.78	4751878.0
2011-05-23 12:00:00	QQQ	ETF	56.7785	56.869	56.67	56.86	3621714.0
2011-05-23 13:00:00	QQQ	ETF	56.85	56.9	56.76	56.861	2403100.0
2011-05-23 14:00:00	QQQ	ETF	56.87	57.09	56.86	57.01	4857901.0
2011-05-23 15:00:00	QQQ	ETF	57.02	57.15	56.86	56.93	9960684.0
2011-05-23 16:00:00	QQQ	ETF	56.93	57.03	56.8577	56.9	1680546.0
2011-05-23 17:00:00	QQQ	ETF	56.9	56.9	56.87	56.9	19827.0
2011-05-23 18:00:00	QQQ	ETF	56.89	56.93	56.89	56.9	108805.0
2011-05-23 19:00:00	QQQ	ETF	56.86	56.9	56.85	56.9	17141.0
2011-05-23 04:00:00	IWM	ETF	82.28	82.28	81.69	81.69	256.0
2011-05-23 05:00:00	IWM	ETF	81.55	81.55	81.39	81.47	800.0
2011-05-23 06:00:00	IWM	ETF	81.48	81.48	81.46	81.46	600.0
2011-05-23 07:00:00	IWM	ETF	81.45	81.7	81.34	81.52	138700.0
2011-05-23 08:00:00	IWM	ETF	81.56	81.59	81.4	81.51	612384.0
2011-05-23 09:00:00	IWM	ETF	81.49	81.64	81.23	81.5	6654437.0
2011-05-23 10:00:00	IWM	ETF	81.49	81.73	81.35	81.51	5383297.0
2011-05-23 11:00:00	IWM	ETF	81.51	81.7167	81.32	81.44	4901290.0
2011-05-23 12:00:00	IWM	ETF	81.43	81.54	81.29	81.53	3047854.0
2011-05-23 13:00:00	IWM	ETF	81.52	81.57	81.35	81.52	2885529.0
2011-05-23 14:00:00	IWM	ETF	81.52	81.95	81.5	81.74	6718277.0
2011-05-23 15:00:00	IWM	ETF	81.73	81.885	81.36	81.38	12959535.0
2011-05-23 16:00:00	IWM	ETF	81.38	82.8752	81.24	81.25	3389564.0
2011-05-23 17:00:00	IWM	ETF	81.26	81.29	81.25	81.26	16184.0
2011-05-23 18:00:00	IWM	ETF	81.27	81.34	81.24	81.24	3300.0
2011-05-23 19:00:00	IWM	ETF	81.24	81.26	81.2	81.26	17400.0
2011-05-23 04:00:00	DIA	ETF	123.6	123.6	123.41	123.41	400.0
2011-05-23 05:00:00	DIA	ETF	123.4	123.4	123.14	123.24	800.0

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

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