PREVIEW / etf_1hour / 2011-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-04.parquet
  size:    183 KB
  rows:    5,557

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-04 04:00:00	SPY	ETF	135.57	135.87	135.4	135.87	2100.0
2011-05-04 05:00:00	SPY	ETF	135.89	135.92	135.8	135.8	10500.0
2011-05-04 06:00:00	SPY	ETF	135.86	135.86	135.41	135.41	191670.0
2011-05-04 07:00:00	SPY	ETF	135.46	135.55	135.38	135.43	969355.0
2011-05-04 08:00:00	SPY	ETF	135.44	135.8	135.33	135.7	2864566.0
2011-05-04 09:00:00	SPY	ETF	135.7	135.84	135.04	135.19	16476138.0
2011-05-04 10:00:00	SPY	ETF	135.19	135.19	134.51	134.83	43817121.0
2011-05-04 11:00:00	SPY	ETF	134.83	134.87	134.31	134.62	18989621.0
2011-05-04 12:00:00	SPY	ETF	134.61	134.72	134.23	134.44	18071262.0
2011-05-04 13:00:00	SPY	ETF	134.44	134.9	134.39	134.85	22123607.0
2011-05-04 14:00:00	SPY	ETF	134.85	135.22	134.64	134.96	17926783.0
2011-05-04 15:00:00	SPY	ETF	134.95	135.07	134.72	134.84	29422702.0
2011-05-04 16:00:00	SPY	ETF	134.84	135.7867	134.68	134.84	9601145.0
2011-05-04 17:00:00	SPY	ETF	134.84	135.7868	134.84	134.85	1889821.0
2011-05-04 18:00:00	SPY	ETF	134.85	134.97	134.85	134.92	204999.0
2011-05-04 19:00:00	SPY	ETF	134.95	135.04	134.9	134.94	55072.0
2011-05-04 04:00:00	QQQ	ETF	58.57	58.57	58.57	58.57	600.0
2011-05-04 06:00:00	QQQ	ETF	58.71	58.71	58.52	58.55	144600.0
2011-05-04 07:00:00	QQQ	ETF	58.55	58.59	58.55	58.57	122800.0
2011-05-04 08:00:00	QQQ	ETF	58.57	58.73	58.57	58.7	1401948.0
2011-05-04 09:00:00	QQQ	ETF	58.71	58.87	58.64	58.69	6718156.0
2011-05-04 10:00:00	QQQ	ETF	58.68	58.68	58.37	58.4791	10926123.0
2011-05-04 11:00:00	QQQ	ETF	58.48	58.51	58.18	58.31	5905961.0
2011-05-04 12:00:00	QQQ	ETF	58.301	58.36	58.11	58.2364	5441230.0
2011-05-04 13:00:00	QQQ	ETF	58.23	58.55	58.22	58.52	5377003.0
2011-05-04 14:00:00	QQQ	ETF	58.52	58.82	58.45	58.71	6542195.0
2011-05-04 15:00:00	QQQ	ETF	58.71	58.78	58.555	58.6	7467941.0
2011-05-04 16:00:00	QQQ	ETF	58.61	58.67	58.52	58.64	1348179.0
2011-05-04 17:00:00	QQQ	ETF	58.62	58.63	58.61	58.61	20509.0
2011-05-04 18:00:00	QQQ	ETF	58.61	58.68	58.61	58.68	43609.0
2011-05-04 19:00:00	QQQ	ETF	58.66	58.67	58.62	58.62	8466.0
2011-05-04 04:00:00	IWM	ETF	84.31	84.34	84.31	84.34	250.0
2011-05-04 06:00:00	IWM	ETF	84.51	84.51	84.22	84.22	11300.0
2011-05-04 07:00:00	IWM	ETF	84.27	84.31	84.23	84.23	29642.0
2011-05-04 08:00:00	IWM	ETF	84.27	84.54	84.21	84.42	349996.0
2011-05-04 09:00:00	IWM	ETF	84.44	84.57	83.93	84.06	5204690.0
2011-05-04 10:00:00	IWM	ETF	84.06	84.07	82.97	83.2601	14921625.0
2011-05-04 11:00:00	IWM	ETF	83.269	83.4	82.92	83.18	7973453.0
2011-05-04 12:00:00	IWM	ETF	83.175	83.25	82.73	82.95	6935382.0
2011-05-04 13:00:00	IWM	ETF	82.95	83.55	82.92	83.48	5348514.0
2011-05-04 14:00:00	IWM	ETF	83.49	83.82	83.2	83.59	6697273.0
2011-05-04 15:00:00	IWM	ETF	83.59	83.615	83.18	83.26	8357580.0
2011-05-04 16:00:00	IWM	ETF	83.26	84.2941	83.06	83.18	3230943.0
2011-05-04 17:00:00	IWM	ETF	83.16	83.24	83.16	83.21	33600.0
2011-05-04 18:00:00	IWM	ETF	83.25	83.3	83.25	83.28	20505.0
2011-05-04 19:00:00	IWM	ETF	83.27	83.31	83.26	83.31	1300.0
2011-05-04 04:00:00	DIA	ETF	127.89	128.0	127.89	128.0	600.0
2011-05-04 07:00:00	DIA	ETF	127.68	127.68	127.59	127.59	3100.0
2011-05-04 08:00:00	DIA	ETF	127.59	127.86	127.57	127.86	23200.0
2011-05-04 09:00:00	DIA	ETF	127.84	127.84	127.23	127.35	668850.0

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

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