PREVIEW / etf_1hour / 2013-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-30.parquet
  size:    200 KB
  rows:    6,263

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-30 04:00:00	SPY	ETF	150.88	150.95	150.88	150.95	880.0
2013-01-30 05:00:00	SPY	ETF	150.88	150.95	150.83	150.93	17555.0
2013-01-30 06:00:00	SPY	ETF	150.96	150.96	150.83	150.9	32836.0
2013-01-30 07:00:00	SPY	ETF	150.87	150.9	150.72	150.73	202667.0
2013-01-30 08:00:00	SPY	ETF	150.73	150.91	149.77	150.53	3631739.0
2013-01-30 09:00:00	SPY	ETF	150.53	150.94	150.49	150.66	14261867.0
2013-01-30 10:00:00	SPY	ETF	150.65	150.67	150.27	150.44	19405439.0
2013-01-30 11:00:00	SPY	ETF	150.44	150.7	150.44	150.6	9298755.0
2013-01-30 12:00:00	SPY	ETF	150.6	150.74	150.38	150.71	9354178.0
2013-01-30 13:00:00	SPY	ETF	150.71	150.74	150.53	150.6	4737024.0
2013-01-30 14:00:00	SPY	ETF	150.59	150.73	150.2	150.41	21278703.0
2013-01-30 15:00:00	SPY	ETF	150.4	150.46	149.93	150.1	30593406.0
2013-01-30 16:00:00	SPY	ETF	150.11	150.801	149.84	149.84	21906838.0
2013-01-30 17:00:00	SPY	ETF	150.7211	150.7211	149.75	149.85	1645027.0
2013-01-30 18:00:00	SPY	ETF	149.84	149.94	149.83	149.88	52012.0
2013-01-30 19:00:00	SPY	ETF	149.9	150.0	149.9	149.9	97622.0
2013-01-30 04:00:00	QQQ	ETF	67.3	67.3	67.3	67.3	100.0
2013-01-30 05:00:00	QQQ	ETF	67.33	67.36	67.32	67.36	1318.0
2013-01-30 06:00:00	QQQ	ETF	67.3	67.35	67.3	67.35	7918.0
2013-01-30 07:00:00	QQQ	ETF	67.3	67.31	67.29	67.29	25300.0
2013-01-30 08:00:00	QQQ	ETF	67.29	67.35	67.0	67.14	920069.0
2013-01-30 09:00:00	QQQ	ETF	67.14	67.48	67.135	67.3807	7947845.0
2013-01-30 10:00:00	QQQ	ETF	67.37	67.4	67.01	67.23	5155596.0
2013-01-30 11:00:00	QQQ	ETF	67.23	67.439	67.22	67.35	2849495.0
2013-01-30 12:00:00	QQQ	ETF	67.34	67.369	67.165	67.291	1892401.0
2013-01-30 13:00:00	QQQ	ETF	67.295	67.31	67.18	67.25	1581459.0
2013-01-30 14:00:00	QQQ	ETF	67.24	67.35	67.0799	67.178	3967498.0
2013-01-30 15:00:00	QQQ	ETF	67.17	67.2	66.87	67.04	6684237.0
2013-01-30 16:00:00	QQQ	ETF	67.03	67.17	66.98	67.1	1635143.0
2013-01-30 17:00:00	QQQ	ETF	67.08	67.11	67.03	67.05	16875.0
2013-01-30 18:00:00	QQQ	ETF	67.05	67.1	67.05	67.08	6911.0
2013-01-30 19:00:00	QQQ	ETF	67.1	67.1	67.08	67.09	50016.0
2013-01-30 07:00:00	IWM	ETF	90.16	90.18	90.09	90.09	30400.0
2013-01-30 08:00:00	IWM	ETF	90.18	90.18	89.84	89.91	321528.0
2013-01-30 09:00:00	IWM	ETF	89.9	90.02	89.71	89.72	3943530.0
2013-01-30 10:00:00	IWM	ETF	89.71	89.71	89.33	89.51	6039726.0
2013-01-30 11:00:00	IWM	ETF	89.52	89.83	89.47	89.67	3362392.0
2013-01-30 12:00:00	IWM	ETF	89.68	89.72	89.5	89.625	1638378.0
2013-01-30 13:00:00	IWM	ETF	89.62	89.69	89.5	89.56	2579699.0
2013-01-30 14:00:00	IWM	ETF	89.56	89.59	89.1199	89.18	4617418.0
2013-01-30 15:00:00	IWM	ETF	89.17	89.25	88.69	89.0	9830920.0
2013-01-30 16:00:00	IWM	ETF	89.0	89.5729	88.78	88.79	1816951.0
2013-01-30 17:00:00	IWM	ETF	88.77	88.79	88.73	88.74	41500.0
2013-01-30 18:00:00	IWM	ETF	88.86	88.86	88.84	88.86	5460.0
2013-01-30 19:00:00	IWM	ETF	88.86	88.94	88.86	88.94	8240.0
2013-01-30 07:00:00	DIA	ETF	139.4	139.4	139.35	139.35	1400.0
2013-01-30 08:00:00	DIA	ETF	139.5	139.5	139.06	139.18	92768.0
2013-01-30 09:00:00	DIA	ETF	139.2	139.37	139.06	139.12	676536.0
2013-01-30 10:00:00	DIA	ETF	139.11	139.16	138.96	139.1	971011.0
2013-01-30 11:00:00	DIA	ETF	139.099	139.258	139.09	139.21	645425.0

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

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