PREVIEW / etf_1hour / 2013-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-15.parquet
  size:    218 KB
  rows:    6,805

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
2013-08-15 04:00:00	SPY	ETF	168.28	168.55	168.28	168.48	18985.0
2013-08-15 05:00:00	SPY	ETF	168.46	168.48	168.36	168.36	4900.0
2013-08-15 06:00:00	SPY	ETF	168.38	168.4	167.84	167.98	185890.0
2013-08-15 07:00:00	SPY	ETF	168.0	168.07	167.67	167.76	803864.0
2013-08-15 08:00:00	SPY	ETF	168.01	168.01	167.14	167.44	2752920.0
2013-08-15 09:00:00	SPY	ETF	167.44	167.45	166.55	166.62	22714165.0
2013-08-15 10:00:00	SPY	ETF	166.62	166.77	166.17	166.4	29957214.0
2013-08-15 11:00:00	SPY	ETF	166.4	166.99	166.38	166.75	16156677.0
2013-08-15 12:00:00	SPY	ETF	166.75	167.04	166.65	166.67	8631562.0
2013-08-15 13:00:00	SPY	ETF	166.67	166.75	166.27	166.48	11312673.0
2013-08-15 14:00:00	SPY	ETF	166.47	166.74	166.09	166.52	14716436.0
2013-08-15 15:00:00	SPY	ETF	166.52	166.6	166.185	166.35	25896206.0
2013-08-15 16:00:00	SPY	ETF	166.34	166.83	166.07	166.07	7352400.0
2013-08-15 17:00:00	SPY	ETF	166.07	166.11	165.96	166.0	3270049.0
2013-08-15 18:00:00	SPY	ETF	166.0	166.34	166.0	166.32	216026.0
2013-08-15 19:00:00	SPY	ETF	166.34	166.34	166.25	166.25	106874.0
2013-08-15 04:00:00	QQQ	ETF	76.34	76.43	76.33	76.41	11200.0
2013-08-15 05:00:00	QQQ	ETF	76.39	76.41	76.39	76.39	5700.0
2013-08-15 06:00:00	QQQ	ETF	76.37	76.37	76.19	76.25	46900.0
2013-08-15 07:00:00	QQQ	ETF	76.27	76.29	76.13	76.16	192033.0
2013-08-15 08:00:00	QQQ	ETF	76.15	76.3	75.9	75.95	894874.0
2013-08-15 09:00:00	QQQ	ETF	75.94	76.0	75.53	75.6	7178911.0
2013-08-15 10:00:00	QQQ	ETF	75.6	75.66	75.29	75.512	9335815.0
2013-08-15 11:00:00	QQQ	ETF	75.52	75.86	75.49	75.805	3214923.0
2013-08-15 12:00:00	QQQ	ETF	75.8	75.9099	75.69	75.7	1690711.0
2013-08-15 13:00:00	QQQ	ETF	75.69	75.72	75.46	75.54	3142846.0
2013-08-15 14:00:00	QQQ	ETF	75.54	75.71	75.36	75.609	2353819.0
2013-08-15 15:00:00	QQQ	ETF	75.61	75.62	75.4	75.52	4387710.0
2013-08-15 16:00:00	QQQ	ETF	75.52	76.8178	75.41	75.44	2572900.0
2013-08-15 17:00:00	QQQ	ETF	75.43	75.43	75.41	75.43	4240.0
2013-08-15 18:00:00	QQQ	ETF	75.43	75.54	75.43	75.54	7618.0
2013-08-15 19:00:00	QQQ	ETF	75.5	75.51	75.49	75.49	29810.0
2013-08-15 06:00:00	IWM	ETF	103.69	103.69	103.42	103.48	300.0
2013-08-15 07:00:00	IWM	ETF	103.52	103.53	102.93	102.95	204592.0
2013-08-15 08:00:00	IWM	ETF	102.97	103.11	102.61	102.78	701735.0
2013-08-15 09:00:00	IWM	ETF	102.78	102.96	102.46	102.57	6643078.0
2013-08-15 10:00:00	IWM	ETF	102.56	102.72	102.17	102.4	6563190.0
2013-08-15 11:00:00	IWM	ETF	102.405	102.77	102.31	102.62	2840167.0
2013-08-15 12:00:00	IWM	ETF	102.615	102.71	102.5	102.5	2228148.0
2013-08-15 13:00:00	IWM	ETF	102.505	102.54	102.22	102.36	4012562.0
2013-08-15 14:00:00	IWM	ETF	102.365	102.41	101.91	102.22	9004926.0
2013-08-15 15:00:00	IWM	ETF	102.225	102.25	101.89	102.13	7712045.0
2013-08-15 16:00:00	IWM	ETF	102.13	104.0706	101.86	101.87	3436468.0
2013-08-15 17:00:00	IWM	ETF	101.92	101.92	101.81	101.89	22132.0
2013-08-15 18:00:00	IWM	ETF	101.9	102.1	101.9	101.96	2100.0
2013-08-15 19:00:00	IWM	ETF	101.96	101.96	101.96	101.96	500.0
2013-08-15 06:00:00	DIA	ETF	152.83	152.83	152.75	152.75	700.0
2013-08-15 07:00:00	DIA	ETF	152.49	152.49	152.43	152.47	8500.0
2013-08-15 08:00:00	DIA	ETF	152.51	152.77	152.09	152.17	65650.0
2013-08-15 09:00:00	DIA	ETF	152.25	152.25	151.35	151.49	1868465.0

> showing 50 of 6,805 rows — these rows as CSV

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