PREVIEW / etf_1hour / 2013-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-04.parquet
  size:    202 KB
  rows:    6,356

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-02-04 04:00:00	SPY	ETF	151.18	151.18	151.14	151.14	500.0
2013-02-04 05:00:00	SPY	ETF	151.05	151.05	150.76	150.79	31234.0
2013-02-04 06:00:00	SPY	ETF	150.81	150.85	150.74	150.74	31350.0
2013-02-04 07:00:00	SPY	ETF	150.76	150.79	150.53	150.73	299394.0
2013-02-04 08:00:00	SPY	ETF	150.71	150.79	150.18	150.38	4246971.0
2013-02-04 09:00:00	SPY	ETF	150.37	150.57	150.18	150.49	16134552.0
2013-02-04 10:00:00	SPY	ETF	150.49	150.58	150.08	150.11	15767021.0
2013-02-04 11:00:00	SPY	ETF	150.12	150.21	149.73	149.79	15460147.0
2013-02-04 12:00:00	SPY	ETF	149.8	149.97	149.61	149.84	9979379.0
2013-02-04 13:00:00	SPY	ETF	149.84	149.96	149.6599	149.745	9875022.0
2013-02-04 14:00:00	SPY	ETF	149.745	150.07	149.68	150.039	11368429.0
2013-02-04 15:00:00	SPY	ETF	150.03	151.2679	149.43	149.54	45602057.0
2013-02-04 16:00:00	SPY	ETF	149.55	151.2679	149.5117	149.72	23728186.0
2013-02-04 17:00:00	SPY	ETF	149.7	149.72	149.62	149.63	108631.0
2013-02-04 18:00:00	SPY	ETF	149.64	149.75	149.61	149.74	45771.0
2013-02-04 19:00:00	SPY	ETF	149.74	149.9	149.74	149.85	126084.0
2013-02-04 04:00:00	QQQ	ETF	67.62	67.62	67.62	67.62	600.0
2013-02-04 05:00:00	QQQ	ETF	67.53	67.53	67.53	67.53	10000.0
2013-02-04 06:00:00	QQQ	ETF	67.56	67.57	67.56	67.57	8700.0
2013-02-04 07:00:00	QQQ	ETF	67.53	67.53	67.41	67.47	26431.0
2013-02-04 08:00:00	QQQ	ETF	67.42	67.47	67.15	67.26	320841.0
2013-02-04 09:00:00	QQQ	ETF	67.25	67.4599	67.2	67.39	3360302.0
2013-02-04 10:00:00	QQQ	ETF	67.39	67.42	67.18	67.19	3711499.0
2013-02-04 11:00:00	QQQ	ETF	67.19	67.23	66.65	66.74	8208368.0
2013-02-04 12:00:00	QQQ	ETF	66.73	66.8	66.59	66.6998	3031388.0
2013-02-04 13:00:00	QQQ	ETF	66.7	66.77	66.54	66.62	2931503.0
2013-02-04 14:00:00	QQQ	ETF	66.611	66.77	66.57	66.74	2577109.0
2013-02-04 15:00:00	QQQ	ETF	66.74	66.749	66.46	66.47	6292854.0
2013-02-04 16:00:00	QQQ	ETF	66.46	66.555	66.46	66.49	1822884.0
2013-02-04 17:00:00	QQQ	ETF	66.71	67.6514	66.48	66.51	519478.0
2013-02-04 18:00:00	QQQ	ETF	66.49	66.52	66.47	66.52	7442.0
2013-02-04 19:00:00	QQQ	ETF	66.52	66.58	66.52	66.58	35481.0
2013-02-04 07:00:00	IWM	ETF	90.01	90.08	89.97	90.07	16600.0
2013-02-04 08:00:00	IWM	ETF	90.07	90.07	89.74	89.9	203830.0
2013-02-04 09:00:00	IWM	ETF	89.88	90.18	89.72	90.0798	3517116.0
2013-02-04 10:00:00	IWM	ETF	90.07	90.12	89.64	89.67	4109161.0
2013-02-04 11:00:00	IWM	ETF	89.67	89.74	89.3975	89.43	3135510.0
2013-02-04 12:00:00	IWM	ETF	89.435	89.55	89.21	89.49	2149334.0
2013-02-04 13:00:00	IWM	ETF	89.48	89.61	89.36	89.4599	1525071.0
2013-02-04 14:00:00	IWM	ETF	89.45	89.63	89.385	89.61	2024015.0
2013-02-04 15:00:00	IWM	ETF	89.61	89.62	89.15	89.27	7226280.0
2013-02-04 16:00:00	IWM	ETF	89.26	89.49	89.25	89.36	1291554.0
2013-02-04 17:00:00	IWM	ETF	89.33	89.4	89.33	89.34	24349.0
2013-02-04 19:00:00	IWM	ETF	89.38	89.44	89.38	89.4	8900.0
2013-02-04 06:00:00	DIA	ETF	139.45	139.45	139.45	139.45	400.0
2013-02-04 07:00:00	DIA	ETF	139.35	139.35	139.29	139.3	550.0
2013-02-04 08:00:00	DIA	ETF	139.25	139.26	138.74	138.88	26045.0
2013-02-04 09:00:00	DIA	ETF	138.89	138.99	138.63	138.95	663021.0
2013-02-04 10:00:00	DIA	ETF	138.948	138.98	138.56	138.65	610443.0
2013-02-04 11:00:00	DIA	ETF	138.67	138.72	138.46	138.52	505703.0

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

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