PREVIEW / etf_1hour / 2013-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-03.parquet
  size:    204 KB
  rows:    6,351

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-01-03 04:00:00	SPY	ETF	145.65	145.72	145.62	145.66	14655.0
2013-01-03 05:00:00	SPY	ETF	145.63	145.73	145.63	145.73	6800.0
2013-01-03 06:00:00	SPY	ETF	145.67	145.7	145.59	145.59	30150.0
2013-01-03 07:00:00	SPY	ETF	145.62	145.66	145.58	145.65	260049.0
2013-01-03 08:00:00	SPY	ETF	145.65	146.15	145.59	145.9	2427546.0
2013-01-03 09:00:00	SPY	ETF	145.91	146.0	145.61	145.79	16543033.0
2013-01-03 10:00:00	SPY	ETF	145.79	146.04	145.77	145.89	16936559.0
2013-01-03 11:00:00	SPY	ETF	145.9	146.28	145.88	146.165	13684381.0
2013-01-03 12:00:00	SPY	ETF	146.16	146.3	146.07	146.19	10198722.0
2013-01-03 13:00:00	SPY	ETF	146.19	146.37	146.1	146.3	10188366.0
2013-01-03 14:00:00	SPY	ETF	146.3	146.31	145.62	145.85	27921428.0
2013-01-03 15:00:00	SPY	ETF	145.85	145.9	145.34	145.77	31566877.0
2013-01-03 16:00:00	SPY	ETF	145.77	146.12	145.53	145.76	8242540.0
2013-01-03 17:00:00	SPY	ETF	145.77	145.84	145.7	145.72	3083464.0
2013-01-03 18:00:00	SPY	ETF	145.73	145.77	145.62	145.62	48299.0
2013-01-03 19:00:00	SPY	ETF	145.66	145.85	145.61	145.78	42498.0
2013-01-03 04:00:00	QQQ	ETF	67.1	67.1	67.1	67.1	200.0
2013-01-03 05:00:00	QQQ	ETF	67.11	67.11	67.11	67.11	400.0
2013-01-03 06:00:00	QQQ	ETF	67.06	67.06	67.05	67.05	1100.0
2013-01-03 07:00:00	QQQ	ETF	67.02	67.07	66.98	67.02	75100.0
2013-01-03 08:00:00	QQQ	ETF	67.02	67.18	67.0	67.13	1072246.0
2013-01-03 09:00:00	QQQ	ETF	67.12	67.22	67.0	67.19	5804661.0
2013-01-03 10:00:00	QQQ	ETF	67.18	67.31	67.1	67.14	4847695.0
2013-01-03 11:00:00	QQQ	ETF	67.13	67.34	67.12	67.239	3671488.0
2013-01-03 12:00:00	QQQ	ETF	67.23	67.3	67.17	67.181	3166146.0
2013-01-03 13:00:00	QQQ	ETF	67.1899	67.28	67.13	67.25	3920870.0
2013-01-03 14:00:00	QQQ	ETF	67.24	67.28	66.89	66.99	4943369.0
2013-01-03 15:00:00	QQQ	ETF	66.99	67.01	66.65	66.88	10509564.0
2013-01-03 16:00:00	QQQ	ETF	66.87	67.2654	66.7602	66.86	5436297.0
2013-01-03 17:00:00	QQQ	ETF	66.87	67.2178	66.79	66.8	1506970.0
2013-01-03 18:00:00	QQQ	ETF	66.81	66.85	66.81	66.82	4460.0
2013-01-03 19:00:00	QQQ	ETF	66.8	66.86	66.78	66.86	10919.0
2013-01-03 06:00:00	IWM	ETF	86.82	86.82	86.82	86.82	120.0
2013-01-03 07:00:00	IWM	ETF	86.63	86.65	86.56	86.56	83120.0
2013-01-03 08:00:00	IWM	ETF	86.56	86.88	86.55	86.85	1220495.0
2013-01-03 09:00:00	IWM	ETF	86.85	86.9	86.53	86.63	3652478.0
2013-01-03 10:00:00	IWM	ETF	86.63	86.91	86.58	86.87	5334605.0
2013-01-03 11:00:00	IWM	ETF	86.87	87.08	86.86	87.05	4411581.0
2013-01-03 12:00:00	IWM	ETF	87.0501	87.2	87.035	87.12	3749744.0
2013-01-03 13:00:00	IWM	ETF	87.13	87.28	87.05	87.25	4295389.0
2013-01-03 14:00:00	IWM	ETF	87.25	87.265	86.69	86.8	5331022.0
2013-01-03 15:00:00	IWM	ETF	86.8	86.865	86.37	86.66	8428300.0
2013-01-03 16:00:00	IWM	ETF	86.65	86.81	86.55	86.8	1748877.0
2013-01-03 17:00:00	IWM	ETF	86.79	86.81	86.65	86.77	621610.0
2013-01-03 18:00:00	IWM	ETF	86.78	86.78	86.71	86.71	1699.0
2013-01-03 19:00:00	IWM	ETF	86.74	86.79	86.71	86.77	9393.0
2013-01-03 04:00:00	DIA	ETF	133.47	133.47	133.47	133.47	1000.0
2013-01-03 06:00:00	DIA	ETF	133.52	133.52	133.52	133.52	200.0
2013-01-03 07:00:00	DIA	ETF	133.44	133.44	133.44	133.44	4000.0
2013-01-03 08:00:00	DIA	ETF	133.43	133.69	133.43	133.56	956237.0

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

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