PREVIEW / etf_1hour / 2013-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-07.parquet
  size:    202 KB
  rows:    6,397

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-07 04:00:00	SPY	ETF	169.4	169.4	169.03	169.3	26751.0
2013-08-07 05:00:00	SPY	ETF	169.3	169.39	169.03	169.09	19700.0
2013-08-07 06:00:00	SPY	ETF	169.12	169.33	169.02	169.23	52064.0
2013-08-07 07:00:00	SPY	ETF	169.25	169.42	169.23	169.37	97280.0
2013-08-07 08:00:00	SPY	ETF	169.24	169.47	169.24	169.44	290123.0
2013-08-07 09:00:00	SPY	ETF	169.43	169.43	168.84	168.89	13341262.0
2013-08-07 10:00:00	SPY	ETF	168.89	168.9	168.55	168.86	17205723.0
2013-08-07 11:00:00	SPY	ETF	168.86	168.95	168.64	168.82	8304288.0
2013-08-07 12:00:00	SPY	ETF	168.82	169.19	168.77	169.17	5392452.0
2013-08-07 13:00:00	SPY	ETF	169.171	169.3	169.07	169.21	7662491.0
2013-08-07 14:00:00	SPY	ETF	169.215	169.27	169.0	169.199	5777150.0
2013-08-07 15:00:00	SPY	ETF	169.195	169.42	169.12	169.2	16850425.0
2013-08-07 16:00:00	SPY	ETF	169.195	169.38	168.9	169.37	7468824.0
2013-08-07 17:00:00	SPY	ETF	169.37	169.38	169.27	169.3	168591.0
2013-08-07 18:00:00	SPY	ETF	169.31	169.34	169.28	169.31	118296.0
2013-08-07 19:00:00	SPY	ETF	169.3	169.42	169.27	169.42	73008.0
2013-08-07 04:00:00	QQQ	ETF	76.26	76.45	76.25	76.35	28797.0
2013-08-07 05:00:00	QQQ	ETF	76.37	76.39	76.27	76.27	32500.0
2013-08-07 06:00:00	QQQ	ETF	76.25	76.35	76.25	76.31	12968.0
2013-08-07 07:00:00	QQQ	ETF	76.3	76.38	76.3	76.38	21610.0
2013-08-07 08:00:00	QQQ	ETF	76.36	76.46	76.36	76.45	53940.0
2013-08-07 09:00:00	QQQ	ETF	76.44	76.568	76.2	76.23	3543398.0
2013-08-07 10:00:00	QQQ	ETF	76.22	76.22	75.87	76.0606	4670524.0
2013-08-07 11:00:00	QQQ	ETF	76.07	76.128	75.94	76.01	1764465.0
2013-08-07 12:00:00	QQQ	ETF	76.0178	76.3	75.99	76.29	1830462.0
2013-08-07 13:00:00	QQQ	ETF	76.2892	76.39	76.275	76.36	1159991.0
2013-08-07 14:00:00	QQQ	ETF	76.351	76.445	76.28	76.421	1310519.0
2013-08-07 15:00:00	QQQ	ETF	76.42	76.51	76.4	76.43	3845835.0
2013-08-07 16:00:00	QQQ	ETF	76.43	76.54	76.3373	76.52	651808.0
2013-08-07 17:00:00	QQQ	ETF	76.52	76.54	76.45	76.45	1041951.0
2013-08-07 18:00:00	QQQ	ETF	76.51	76.53	76.49	76.52	14700.0
2013-08-07 19:00:00	QQQ	ETF	76.53	76.6	76.52	76.58	30275.0
2013-08-07 06:00:00	IWM	ETF	104.2	104.2	104.13	104.13	1600.0
2013-08-07 07:00:00	IWM	ETF	104.13	104.25	104.13	104.25	53400.0
2013-08-07 08:00:00	IWM	ETF	104.28	104.33	104.15	104.32	89150.0
2013-08-07 09:00:00	IWM	ETF	104.32	104.34	103.8098	103.84	3334623.0
2013-08-07 10:00:00	IWM	ETF	103.84	103.84	103.47	103.74	5422991.0
2013-08-07 11:00:00	IWM	ETF	103.75	103.84	103.58	103.68	1563558.0
2013-08-07 12:00:00	IWM	ETF	103.68	103.78	103.56	103.71	1261244.0
2013-08-07 13:00:00	IWM	ETF	103.71	103.96	103.7	103.79	2880661.0
2013-08-07 14:00:00	IWM	ETF	103.79	103.83	103.63	103.79	1469063.0
2013-08-07 15:00:00	IWM	ETF	103.78	103.91	103.62	103.72	4642293.0
2013-08-07 16:00:00	IWM	ETF	103.71	103.91	103.6763	103.91	508936.0
2013-08-07 17:00:00	IWM	ETF	103.91	103.91	103.9	103.9	10185.0
2013-08-07 18:00:00	IWM	ETF	103.92	103.92	103.83	103.83	2950.0
2013-08-07 08:00:00	DIA	ETF	154.57	154.59	154.52	154.52	1395.0
2013-08-07 09:00:00	DIA	ETF	154.55	154.59	154.14	154.209	954192.0
2013-08-07 10:00:00	DIA	ETF	154.2	154.33	154.01	154.29	809117.0
2013-08-07 11:00:00	DIA	ETF	154.3	154.38	154.13	154.23	522461.0
2013-08-07 12:00:00	DIA	ETF	154.2253	154.51	154.2	154.51	253439.0

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

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