PREVIEW / etf_1hour / 2012-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-08.parquet
  size:    178 KB
  rows:    5,537

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-10-08 04:00:00	SPY	ETF	145.7	145.7	145.51	145.57	1475.0
2012-10-08 05:00:00	SPY	ETF	145.62	145.63	145.56	145.56	20000.0
2012-10-08 06:00:00	SPY	ETF	145.54	145.57	145.42	145.57	26893.0
2012-10-08 07:00:00	SPY	ETF	145.57	145.6	145.46	145.59	100113.0
2012-10-08 08:00:00	SPY	ETF	145.56	145.75	145.53	145.57	501731.0
2012-10-08 09:00:00	SPY	ETF	145.57	146.1231	145.37	145.55	13146441.0
2012-10-08 10:00:00	SPY	ETF	145.54	145.8	145.38	145.61	13116942.0
2012-10-08 11:00:00	SPY	ETF	145.62	145.72	145.31	145.5	10537369.0
2012-10-08 12:00:00	SPY	ETF	145.49	145.63	145.43	145.62	9357941.0
2012-10-08 13:00:00	SPY	ETF	145.62	145.68	145.49	145.56	7632913.0
2012-10-08 14:00:00	SPY	ETF	145.55	145.66	145.52	145.58	5628628.0
2012-10-08 15:00:00	SPY	ETF	145.59	145.885	145.58	145.64	13403797.0
2012-10-08 16:00:00	SPY	ETF	145.64	146.1232	145.45	145.48	3369766.0
2012-10-08 17:00:00	SPY	ETF	145.5	145.53	145.45	145.52	275978.0
2012-10-08 18:00:00	SPY	ETF	145.52	145.52	145.45	145.51	33150.0
2012-10-08 19:00:00	SPY	ETF	145.51	145.7	145.5	145.67	124643.0
2012-10-08 04:00:00	QQQ	ETF	68.8	68.8	68.59	68.62	4358.0
2012-10-08 06:00:00	QQQ	ETF	68.56	68.57	68.53	68.53	1300.0
2012-10-08 07:00:00	QQQ	ETF	68.59	68.61	68.53	68.6	22950.0
2012-10-08 08:00:00	QQQ	ETF	68.59	68.66	68.53	68.56	123340.0
2012-10-08 09:00:00	QQQ	ETF	68.57	68.6499	68.33	68.6	3957153.0
2012-10-08 10:00:00	QQQ	ETF	68.6	68.72	68.32	68.46	4870056.0
2012-10-08 11:00:00	QQQ	ETF	68.46	68.5	68.19	68.35	6355216.0
2012-10-08 12:00:00	QQQ	ETF	68.36	68.41	68.25	68.32	2669612.0
2012-10-08 13:00:00	QQQ	ETF	68.3299	68.4	68.23	68.28	3189389.0
2012-10-08 14:00:00	QQQ	ETF	68.27	68.34	68.23	68.275	1840916.0
2012-10-08 15:00:00	QQQ	ETF	68.2815	68.53	68.28	68.36	4729948.0
2012-10-08 16:00:00	QQQ	ETF	68.35	68.9531	68.22	68.24	1451828.0
2012-10-08 17:00:00	QQQ	ETF	68.25	68.3	68.23	68.29	13705.0
2012-10-08 18:00:00	QQQ	ETF	68.26	68.27	68.26	68.26	6199.0
2012-10-08 19:00:00	QQQ	ETF	68.29	68.35	68.28	68.35	11450.0
2012-10-08 05:00:00	IWM	ETF	83.6	83.6	83.5	83.5	10000.0
2012-10-08 06:00:00	IWM	ETF	83.59	83.59	83.59	83.59	5000.0
2012-10-08 07:00:00	IWM	ETF	83.56	83.58	83.51	83.55	71040.0
2012-10-08 08:00:00	IWM	ETF	83.58	84.11	83.5	83.6	327176.0
2012-10-08 09:00:00	IWM	ETF	83.61	83.74	83.39	83.6	3564250.0
2012-10-08 10:00:00	IWM	ETF	83.61	83.9	83.52	83.73	4137882.0
2012-10-08 11:00:00	IWM	ETF	83.73	83.81	83.48	83.63	3622083.0
2012-10-08 12:00:00	IWM	ETF	83.635	83.74	83.58	83.72	1225536.0
2012-10-08 13:00:00	IWM	ETF	83.73	83.8	83.63	83.655	1899347.0
2012-10-08 14:00:00	IWM	ETF	83.65	83.687	83.56	83.62	1096727.0
2012-10-08 15:00:00	IWM	ETF	83.62	83.81	83.57	83.6	3985964.0
2012-10-08 16:00:00	IWM	ETF	83.59	83.66	83.56	83.6	582726.0
2012-10-08 17:00:00	IWM	ETF	83.61	83.65	83.61	83.64	4094.0
2012-10-08 19:00:00	IWM	ETF	83.6	83.65	83.6	83.65	6864.0
2012-10-08 07:00:00	DIA	ETF	135.25	135.25	135.25	135.25	100.0
2012-10-08 08:00:00	DIA	ETF	135.4	135.45	135.38	135.45	1600.0
2012-10-08 09:00:00	DIA	ETF	135.41	135.625	135.32	135.49	461807.0
2012-10-08 10:00:00	DIA	ETF	135.5	135.77	135.42	135.61	579671.0
2012-10-08 11:00:00	DIA	ETF	135.62	135.71	135.42	135.56	304387.0

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

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