PREVIEW / etf_1hour / 2013-02-19

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-19.parquet
  size:    200 KB
  rows:    6,260

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-19 04:00:00	SPY	ETF	152.17	152.35	152.15	152.35	50400.0
2013-02-19 05:00:00	SPY	ETF	152.32	152.37	152.32	152.33	59534.0
2013-02-19 06:00:00	SPY	ETF	152.3	152.31	152.25	152.27	9800.0
2013-02-19 07:00:00	SPY	ETF	152.26	152.49	152.26	152.34	379592.0
2013-02-19 08:00:00	SPY	ETF	152.34	152.47	152.32	152.41	552016.0
2013-02-19 09:00:00	SPY	ETF	152.42	152.87	152.31	152.82	16841883.0
2013-02-19 10:00:00	SPY	ETF	152.82	152.9	152.66	152.72	11066875.0
2013-02-19 11:00:00	SPY	ETF	152.72	153.02	152.66	152.975	7303806.0
2013-02-19 12:00:00	SPY	ETF	152.98	153.0	152.815	152.95	6070812.0
2013-02-19 13:00:00	SPY	ETF	152.945	152.99	152.9	152.97	4393121.0
2013-02-19 14:00:00	SPY	ETF	152.97	153.24	152.96	153.09	8242504.0
2013-02-19 15:00:00	SPY	ETF	153.09	153.28	153.0	153.22	21296890.0
2013-02-19 16:00:00	SPY	ETF	153.22	153.29	152.1629	153.25	15224461.0
2013-02-19 17:00:00	SPY	ETF	153.26	153.28	153.25	153.25	37860.0
2013-02-19 18:00:00	SPY	ETF	153.26	153.27	153.22	153.25	32353.0
2013-02-19 19:00:00	SPY	ETF	153.27	153.28	153.24	153.28	29573.0
2013-02-19 04:00:00	QQQ	ETF	67.75	67.86	67.75	67.86	17700.0
2013-02-19 05:00:00	QQQ	ETF	67.83	67.83	67.83	67.83	500.0
2013-02-19 06:00:00	QQQ	ETF	67.8	67.8	67.8	67.8	300.0
2013-02-19 07:00:00	QQQ	ETF	67.79	67.9	67.79	67.9	7350.0
2013-02-19 08:00:00	QQQ	ETF	67.89	67.93	67.89	67.92	40602.0
2013-02-19 09:00:00	QQQ	ETF	67.92	68.12	67.86	68.05	3779929.0
2013-02-19 10:00:00	QQQ	ETF	68.05	68.1	67.895	67.94	3217362.0
2013-02-19 11:00:00	QQQ	ETF	67.94	68.05	67.89	68.04	2058420.0
2013-02-19 12:00:00	QQQ	ETF	68.05	68.05	67.9431	68.04	1138041.0
2013-02-19 13:00:00	QQQ	ETF	68.0475	68.08	67.93	67.965	1440680.0
2013-02-19 14:00:00	QQQ	ETF	67.965	68.2	67.96	68.16	2561790.0
2013-02-19 15:00:00	QQQ	ETF	68.16	68.26	68.1	68.24	4319424.0
2013-02-19 16:00:00	QQQ	ETF	68.23	68.31	67.8095	68.28	3170228.0
2013-02-19 17:00:00	QQQ	ETF	68.31	68.32	68.28	68.31	10700.0
2013-02-19 18:00:00	QQQ	ETF	68.27	68.28	68.23	68.23	14523.0
2013-02-19 19:00:00	QQQ	ETF	68.25	68.29	68.25	68.29	1900.0
2013-02-19 07:00:00	IWM	ETF	91.8	91.8	91.8	91.8	200.0
2013-02-19 08:00:00	IWM	ETF	91.77	91.84	91.77	91.79	96247.0
2013-02-19 09:00:00	IWM	ETF	91.8	92.33	91.8	92.28	2776483.0
2013-02-19 10:00:00	IWM	ETF	92.27	92.39	92.19	92.31	2376811.0
2013-02-19 11:00:00	IWM	ETF	92.32	92.38	92.26	92.27	1694545.0
2013-02-19 12:00:00	IWM	ETF	92.27	92.28	92.04	92.1899	2389039.0
2013-02-19 13:00:00	IWM	ETF	92.19	92.23	92.13	92.23	973195.0
2013-02-19 14:00:00	IWM	ETF	92.2299	92.43	92.21	92.34	2009044.0
2013-02-19 15:00:00	IWM	ETF	92.34	92.56	92.3	92.53	5886023.0
2013-02-19 16:00:00	IWM	ETF	92.54	92.74	92.3	92.55	1488906.0
2013-02-19 17:00:00	IWM	ETF	92.7	92.75	92.7	92.75	4900.0
2013-02-19 18:00:00	IWM	ETF	92.73	92.73	92.71	92.72	800.0
2013-02-19 19:00:00	IWM	ETF	92.72	92.77	92.69	92.77	7440.0
2013-02-19 07:00:00	DIA	ETF	139.6	139.6	139.6	139.6	2900.0
2013-02-19 08:00:00	DIA	ETF	139.62	139.62	139.52	139.61	8698.0
2013-02-19 09:00:00	DIA	ETF	139.57	140.13	139.52	140.109	799769.0
2013-02-19 10:00:00	DIA	ETF	140.06	140.16	139.9	139.95	528756.0
2013-02-19 11:00:00	DIA	ETF	139.96	140.13	139.87	140.05	471191.0

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

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