PREVIEW / etf_1hour / 2011-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-09.parquet
  size:    179 KB
  rows:    5,495

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-09 04:00:00	SPY	ETF	134.54	134.96	134.43	134.58	27515.0
2011-05-09 05:00:00	SPY	ETF	134.53	134.58	134.41	134.54	500.0
2011-05-09 06:00:00	SPY	ETF	134.51	134.6	134.38	134.51	79339.0
2011-05-09 07:00:00	SPY	ETF	134.5	134.64	134.34	134.35	371325.0
2011-05-09 08:00:00	SPY	ETF	134.28	134.47	133.94	134.06	2359578.0
2011-05-09 09:00:00	SPY	ETF	134.06	134.45	134.02	134.13	14463206.0
2011-05-09 10:00:00	SPY	ETF	134.14	134.49	133.98	134.28	22359619.0
2011-05-09 11:00:00	SPY	ETF	134.28	134.61	134.17	134.555	11370231.0
2011-05-09 12:00:00	SPY	ETF	134.56	135.09	134.53	134.78	19108851.0
2011-05-09 13:00:00	SPY	ETF	134.77	134.98	134.73	134.93	7676584.0
2011-05-09 14:00:00	SPY	ETF	134.94	135.11	134.78	134.82	11144727.0
2011-05-09 15:00:00	SPY	ETF	134.81	134.975	134.73	134.73	18220532.0
2011-05-09 16:00:00	SPY	ETF	134.73	134.89	134.5855	134.85	5939146.0
2011-05-09 17:00:00	SPY	ETF	134.86	134.86	134.73	134.73	49733.0
2011-05-09 18:00:00	SPY	ETF	134.75	134.84	134.72	134.8	141637.0
2011-05-09 19:00:00	SPY	ETF	134.77	134.87	134.77	134.86	92327.0
2011-05-09 04:00:00	QQQ	ETF	58.82	58.85	58.68	58.71	1729.0
2011-05-09 05:00:00	QQQ	ETF	58.6	58.6	58.6	58.6	100.0
2011-05-09 06:00:00	QQQ	ETF	58.69	58.69	58.69	58.69	1000.0
2011-05-09 07:00:00	QQQ	ETF	58.68	58.71	58.62	58.62	20600.0
2011-05-09 08:00:00	QQQ	ETF	58.62	58.65	58.47	58.49	276058.0
2011-05-09 09:00:00	QQQ	ETF	58.5	58.83	58.38	58.46	5244206.0
2011-05-09 10:00:00	QQQ	ETF	58.46	58.64	58.34	58.523	7535789.0
2011-05-09 11:00:00	QQQ	ETF	58.53	58.74	58.47	58.725	5673509.0
2011-05-09 12:00:00	QQQ	ETF	58.73	58.91	58.72	58.74	7464229.0
2011-05-09 13:00:00	QQQ	ETF	58.74	58.88	58.73	58.847	2139644.0
2011-05-09 14:00:00	QQQ	ETF	58.84	58.92	58.73	58.75	3614422.0
2011-05-09 15:00:00	QQQ	ETF	58.75	58.82	58.64	58.68	6223950.0
2011-05-09 16:00:00	QQQ	ETF	58.68	58.74	58.64	58.69	948787.0
2011-05-09 17:00:00	QQQ	ETF	58.7	58.73	58.63	58.73	14165.0
2011-05-09 18:00:00	QQQ	ETF	58.66	58.69	58.65	58.68	27714.0
2011-05-09 19:00:00	QQQ	ETF	58.67	58.72	58.67	58.69	5500.0
2011-05-09 04:00:00	IWM	ETF	83.73	83.73	83.6	83.65	2487.0
2011-05-09 05:00:00	IWM	ETF	83.45	83.45	83.24	83.24	200.0
2011-05-09 06:00:00	IWM	ETF	83.4	83.4	83.28	83.28	714.0
2011-05-09 07:00:00	IWM	ETF	83.38	83.45	83.26	83.26	55422.0
2011-05-09 08:00:00	IWM	ETF	83.26	83.33	82.96	82.99	424337.0
2011-05-09 09:00:00	IWM	ETF	82.98	83.42	82.96	83.23	6790379.0
2011-05-09 10:00:00	IWM	ETF	83.23	83.68	83.15	83.54	7318425.0
2011-05-09 11:00:00	IWM	ETF	83.55	83.85	83.465	83.82	3660793.0
2011-05-09 12:00:00	IWM	ETF	83.82	84.22	83.8	83.9674	5779325.0
2011-05-09 13:00:00	IWM	ETF	83.97	84.18	83.94	84.15	1606843.0
2011-05-09 14:00:00	IWM	ETF	84.15	84.33	84.02	84.09	3668959.0
2011-05-09 15:00:00	IWM	ETF	84.09	84.27	84.01	84.2	8178235.0
2011-05-09 16:00:00	IWM	ETF	84.2	84.37	83.69	84.33	1863030.0
2011-05-09 17:00:00	IWM	ETF	84.35	84.35	84.31	84.31	9037.0
2011-05-09 18:00:00	IWM	ETF	84.3	84.31	84.24	84.3	71414.0
2011-05-09 19:00:00	IWM	ETF	84.32	84.36	84.28	84.35	9000.0
2011-05-09 04:00:00	DIA	ETF	126.82	126.82	126.78	126.78	831.0
2011-05-09 06:00:00	DIA	ETF	126.53	126.54	126.53	126.54	2000.0

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

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