PREVIEW / etf_1hour / 2011-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-07.parquet
  size:    182 KB
  rows:    5,665

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-07-07 04:00:00	SPY	ETF	134.38	134.48	134.38	134.41	1500.0
2011-07-07 05:00:00	SPY	ETF	134.45	134.57	134.45	134.45	600.0
2011-07-07 06:00:00	SPY	ETF	134.4	134.42	134.3	134.35	5600.0
2011-07-07 07:00:00	SPY	ETF	134.42	134.6	134.39	134.49	435746.0
2011-07-07 08:00:00	SPY	ETF	134.47	135.4	133.95	135.25	6189108.0
2011-07-07 09:00:00	SPY	ETF	135.25	135.31	134.88	135.05	20624759.0
2011-07-07 10:00:00	SPY	ETF	135.06	135.29	134.94	135.24	20348289.0
2011-07-07 11:00:00	SPY	ETF	135.23	135.23	135.0	135.1	20571727.0
2011-07-07 12:00:00	SPY	ETF	135.11	135.32	135.06	135.24	13643093.0
2011-07-07 13:00:00	SPY	ETF	135.24	135.48	135.19	135.38	12406187.0
2011-07-07 14:00:00	SPY	ETF	135.37	135.7	135.37	135.61	15150362.0
2011-07-07 15:00:00	SPY	ETF	135.6	135.69	135.33	135.4	34531325.0
2011-07-07 16:00:00	SPY	ETF	135.42	135.65	133.9589	135.57	21120259.0
2011-07-07 17:00:00	SPY	ETF	135.57	135.64	133.9589	135.59	1080785.0
2011-07-07 18:00:00	SPY	ETF	135.58	135.59	135.36	135.56	450076.0
2011-07-07 19:00:00	SPY	ETF	135.53	135.58	135.49	135.54	60369.0
2011-07-07 04:00:00	QQQ	ETF	58.48	58.48	58.48	58.48	100.0
2011-07-07 05:00:00	QQQ	ETF	58.58	58.58	58.58	58.58	100.0
2011-07-07 07:00:00	QQQ	ETF	58.55	58.58	58.5	58.54	113682.0
2011-07-07 08:00:00	QQQ	ETF	58.52	58.94	58.5	58.85	1415216.0
2011-07-07 09:00:00	QQQ	ETF	58.85	58.91	58.75	58.86	6198837.0
2011-07-07 10:00:00	QQQ	ETF	58.86	59.05	58.74	59.03	7074135.0
2011-07-07 11:00:00	QQQ	ETF	59.03	59.08	58.98	59.06	5691203.0
2011-07-07 12:00:00	QQQ	ETF	59.07	59.15	59.03	59.14	4024586.0
2011-07-07 13:00:00	QQQ	ETF	59.14	59.23	59.11	59.17	3605348.0
2011-07-07 14:00:00	QQQ	ETF	59.165	59.36	59.165	59.31	6416904.0
2011-07-07 15:00:00	QQQ	ETF	59.31	59.36	59.18	59.2	9306802.0
2011-07-07 16:00:00	QQQ	ETF	59.19	59.36	59.19	59.32	5139518.0
2011-07-07 17:00:00	QQQ	ETF	59.33	59.37	59.33	59.36	96620.0
2011-07-07 18:00:00	QQQ	ETF	59.36	59.37	59.19	59.36	95334.0
2011-07-07 19:00:00	QQQ	ETF	59.34	59.39	59.32	59.39	42689.0
2011-07-07 04:00:00	IWM	ETF	84.86	84.86	84.86	84.86	225.0
2011-07-07 06:00:00	IWM	ETF	84.79	84.81	84.79	84.8	400.0
2011-07-07 07:00:00	IWM	ETF	84.79	84.86	84.7	84.81	6866.0
2011-07-07 08:00:00	IWM	ETF	84.76	85.4	84.0	85.24	1372494.0
2011-07-07 09:00:00	IWM	ETF	85.27	85.29	84.94	85.22	8451524.0
2011-07-07 10:00:00	IWM	ETF	85.22	85.89	85.15	85.88	11170551.0
2011-07-07 11:00:00	IWM	ETF	85.88	85.88	85.68	85.78	5062143.0
2011-07-07 12:00:00	IWM	ETF	85.79	85.945	85.7552	85.875	3230086.0
2011-07-07 13:00:00	IWM	ETF	85.88	85.97	85.77	85.79	5063301.0
2011-07-07 14:00:00	IWM	ETF	85.79	85.87	85.72	85.76	6870766.0
2011-07-07 15:00:00	IWM	ETF	85.76	85.86	85.53	85.63	8374066.0
2011-07-07 16:00:00	IWM	ETF	85.64	85.83	85.61	85.8	3411987.0
2011-07-07 17:00:00	IWM	ETF	85.76	85.82	85.75	85.82	8170.0
2011-07-07 18:00:00	IWM	ETF	85.78	85.82	85.76	85.78	1886.0
2011-07-07 19:00:00	IWM	ETF	85.76	85.77	85.76	85.77	300.0
2011-07-07 08:00:00	DIA	ETF	126.35	127.04	126.3	126.89	207362.0
2011-07-07 09:00:00	DIA	ETF	126.94	126.94	126.6	126.82	854355.0
2011-07-07 10:00:00	DIA	ETF	126.83	127.08	126.77	127.03	593781.0
2011-07-07 11:00:00	DIA	ETF	127.02	127.02	126.84	126.91	528401.0

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

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