PREVIEW / etf_1hour / 2012-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-03.parquet
  size:    182 KB
  rows:    5,761

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
2012-08-03 04:00:00	SPY	ETF	137.35	137.73	137.35	137.65	17820.0
2012-08-03 05:00:00	SPY	ETF	137.68	137.96	137.6	137.77	25858.0
2012-08-03 06:00:00	SPY	ETF	137.71	138.11	137.67	138.11	105023.0
2012-08-03 07:00:00	SPY	ETF	138.02	138.24	137.94	137.95	466150.0
2012-08-03 08:00:00	SPY	ETF	137.94	138.61	137.6	138.38	6115948.0
2012-08-03 09:00:00	SPY	ETF	138.39	139.05	136.64	138.992	24818696.0
2012-08-03 10:00:00	SPY	ETF	139.0	139.42	138.995	139.24	27065819.0
2012-08-03 11:00:00	SPY	ETF	139.24	139.57	139.17	139.56	14247610.0
2012-08-03 12:00:00	SPY	ETF	139.55	139.64	139.42	139.43	9498012.0
2012-08-03 13:00:00	SPY	ETF	139.42	139.54	139.36	139.46	6168652.0
2012-08-03 14:00:00	SPY	ETF	139.46	139.56	139.36	139.43	10090080.0
2012-08-03 15:00:00	SPY	ETF	139.43	139.54	139.07	139.35	36364746.0
2012-08-03 16:00:00	SPY	ETF	139.33	139.63	136.6884	139.59	19191462.0
2012-08-03 17:00:00	SPY	ETF	139.57	139.6	139.47	139.49	294747.0
2012-08-03 18:00:00	SPY	ETF	139.48	139.6	139.47	139.51	83463.0
2012-08-03 19:00:00	SPY	ETF	139.5	139.59	139.46	139.57	31199.0
2012-08-03 04:00:00	QQQ	ETF	64.59	64.83	64.59	64.83	650.0
2012-08-03 05:00:00	QQQ	ETF	64.82	64.88	64.82	64.88	2300.0
2012-08-03 06:00:00	QQQ	ETF	64.86	64.96	64.86	64.96	400.0
2012-08-03 07:00:00	QQQ	ETF	64.99	65.04	64.96	64.96	252500.0
2012-08-03 08:00:00	QQQ	ETF	64.94	65.24	64.9	65.24	2532456.0
2012-08-03 09:00:00	QQQ	ETF	65.24	65.59	65.19	65.58	8523788.0
2012-08-03 10:00:00	QQQ	ETF	65.59	65.7501	65.58	65.68	5362283.0
2012-08-03 11:00:00	QQQ	ETF	65.68	65.83	65.65	65.81	5963955.0
2012-08-03 12:00:00	QQQ	ETF	65.81	65.84	65.7	65.748	2197447.0
2012-08-03 13:00:00	QQQ	ETF	65.7455	65.8	65.73	65.771	1463613.0
2012-08-03 14:00:00	QQQ	ETF	65.78	65.88	65.74	65.75	2352312.0
2012-08-03 15:00:00	QQQ	ETF	65.76	65.83	65.55	65.63	7017661.0
2012-08-03 16:00:00	QQQ	ETF	65.62	65.78	64.413	65.75	2219432.0
2012-08-03 17:00:00	QQQ	ETF	65.7	65.74	65.6	65.72	11556.0
2012-08-03 18:00:00	QQQ	ETF	65.67	65.67	65.67	65.67	500.0
2012-08-03 19:00:00	QQQ	ETF	65.73	65.73	65.64	65.71	5835.0
2012-08-03 05:00:00	IWM	ETF	77.42	77.42	77.32	77.32	200.0
2012-08-03 06:00:00	IWM	ETF	77.69	77.77	77.69	77.77	2700.0
2012-08-03 07:00:00	IWM	ETF	77.77	77.86	77.64	77.64	125892.0
2012-08-03 08:00:00	IWM	ETF	77.64	77.97	77.58	77.87	1450414.0
2012-08-03 09:00:00	IWM	ETF	77.87	78.46	77.65	78.36	8313044.0
2012-08-03 10:00:00	IWM	ETF	78.37	78.75	78.37	78.55	6818305.0
2012-08-03 11:00:00	IWM	ETF	78.55	78.96	78.53	78.95	5782075.0
2012-08-03 12:00:00	IWM	ETF	78.95	78.99	78.75	78.79	3302083.0
2012-08-03 13:00:00	IWM	ETF	78.79	78.92	78.78	78.89	2771420.0
2012-08-03 14:00:00	IWM	ETF	78.895	79.02	78.78	78.85	3743560.0
2012-08-03 15:00:00	IWM	ETF	78.845	78.96	78.56	78.61	8963874.0
2012-08-03 16:00:00	IWM	ETF	78.61	79.0	76.6869	78.72	3429185.0
2012-08-03 17:00:00	IWM	ETF	78.71	78.72	78.69	78.69	813.0
2012-08-03 18:00:00	IWM	ETF	78.61	78.7	78.61	78.7	1192.0
2012-08-03 19:00:00	IWM	ETF	78.63	78.63	78.63	78.63	100.0
2012-08-03 07:00:00	DIA	ETF	129.57	129.68	129.18	129.18	1450.0
2012-08-03 08:00:00	DIA	ETF	129.31	129.86	125.81	129.83	265019.0
2012-08-03 09:00:00	DIA	ETF	129.83	130.54	129.83	130.53	1660427.0

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

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