PREVIEW / etf_1hour / 2013-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-11.parquet
  size:    208 KB
  rows:    6,466

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-10-11 04:00:00	SPY	ETF	168.95	169.25	168.95	169.25	29715.0
2013-10-11 05:00:00	SPY	ETF	169.25	169.29	169.13	169.2	13775.0
2013-10-11 06:00:00	SPY	ETF	169.21	169.21	168.99	169.13	82900.0
2013-10-11 07:00:00	SPY	ETF	169.11	169.25	169.03	169.07	561084.0
2013-10-11 08:00:00	SPY	ETF	169.05	169.17	168.8	168.89	940452.0
2013-10-11 09:00:00	SPY	ETF	168.9	169.53	168.7	169.52	13259686.0
2013-10-11 10:00:00	SPY	ETF	169.52	169.65	169.06	169.32	15195999.0
2013-10-11 11:00:00	SPY	ETF	169.32	169.95	169.24	169.93	14841627.0
2013-10-11 12:00:00	SPY	ETF	169.92	170.27	169.895	170.17	10753516.0
2013-10-11 13:00:00	SPY	ETF	170.16	170.32	169.93	170.09	9100136.0
2013-10-11 14:00:00	SPY	ETF	170.0897	170.21	170.0	170.06	5909057.0
2013-10-11 15:00:00	SPY	ETF	170.055	170.27	169.78	170.24	21352296.0
2013-10-11 16:00:00	SPY	ETF	170.24	170.47	169.1961	170.45	6753846.0
2013-10-11 17:00:00	SPY	ETF	170.45	170.5	170.31	170.5	123310.0
2013-10-11 18:00:00	SPY	ETF	170.46	170.57	170.42	170.45	41580.0
2013-10-11 19:00:00	SPY	ETF	170.45	170.49	170.38	170.41	31123.0
2013-10-11 04:00:00	QQQ	ETF	78.47	78.61	78.46	78.6	13400.0
2013-10-11 05:00:00	QQQ	ETF	78.61	78.61	78.54	78.58	6500.0
2013-10-11 06:00:00	QQQ	ETF	78.56	78.56	78.46	78.5	13300.0
2013-10-11 07:00:00	QQQ	ETF	78.5	78.52	78.46	78.46	12250.0
2013-10-11 08:00:00	QQQ	ETF	78.45	78.47	78.37	78.44	47816.0
2013-10-11 09:00:00	QQQ	ETF	78.45	78.88	78.38	78.86	2892487.0
2013-10-11 10:00:00	QQQ	ETF	78.86	78.935	78.65	78.7901	4389391.0
2013-10-11 11:00:00	QQQ	ETF	78.79	79.14	78.71	79.13	3095809.0
2013-10-11 12:00:00	QQQ	ETF	79.12	79.26	79.11	79.21	2753818.0
2013-10-11 13:00:00	QQQ	ETF	79.211	79.29	79.1	79.19	2558406.0
2013-10-11 14:00:00	QQQ	ETF	79.19	79.28	79.13	79.17	1172391.0
2013-10-11 15:00:00	QQQ	ETF	79.16	79.23	79.04	79.22	5092053.0
2013-10-11 16:00:00	QQQ	ETF	79.23	79.28	78.6451	79.27	1862691.0
2013-10-11 17:00:00	QQQ	ETF	79.27	79.33	79.27	79.29	109803.0
2013-10-11 18:00:00	QQQ	ETF	79.32	79.34	79.31	79.31	8601.0
2013-10-11 19:00:00	QQQ	ETF	79.29	79.34	79.26	79.34	6071.0
2013-10-11 04:00:00	IWM	ETF	106.13	106.13	106.13	106.13	210.0
2013-10-11 05:00:00	IWM	ETF	106.25	106.25	106.25	106.25	1000.0
2013-10-11 06:00:00	IWM	ETF	106.25	106.25	106.15	106.15	7200.0
2013-10-11 07:00:00	IWM	ETF	106.15	106.2	106.05	106.05	94300.0
2013-10-11 08:00:00	IWM	ETF	106.07	106.08	105.87	105.91	122752.0
2013-10-11 09:00:00	IWM	ETF	105.94	106.4	105.81	106.3999	4007585.0
2013-10-11 10:00:00	IWM	ETF	106.39	106.525	106.18	106.51	5290886.0
2013-10-11 11:00:00	IWM	ETF	106.51	107.0	106.365	106.98	5192445.0
2013-10-11 12:00:00	IWM	ETF	106.97	107.5	106.97	107.47	7183347.0
2013-10-11 13:00:00	IWM	ETF	107.475	107.73	107.37	107.45	7263265.0
2013-10-11 14:00:00	IWM	ETF	107.44	107.57	107.36	107.4	2849646.0
2013-10-11 15:00:00	IWM	ETF	107.39	107.7	107.21	107.69	8144290.0
2013-10-11 16:00:00	IWM	ETF	107.69	107.84	107.2723	107.8	1711082.0
2013-10-11 17:00:00	IWM	ETF	107.84	107.87	107.8	107.87	5290.0
2013-10-11 18:00:00	IWM	ETF	107.8	107.92	107.8	107.85	5136.0
2013-10-11 19:00:00	IWM	ETF	107.8	107.81	107.8	107.81	355.0
2013-10-11 08:00:00	DIA	ETF	150.99	150.99	150.69	150.69	570.0
2013-10-11 09:00:00	DIA	ETF	150.82	151.51	150.76	151.5	773352.0

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

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