PREVIEW / etf_1hour / 2013-02-12

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-12.parquet
  size:    195 KB
  rows:    6,080

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-12 04:00:00	SPY	ETF	151.49	151.57	151.41	151.41	9600.0
2013-02-12 05:00:00	SPY	ETF	151.45	151.72	151.45	151.65	68135.0
2013-02-12 06:00:00	SPY	ETF	151.64	151.74	151.64	151.68	23551.0
2013-02-12 07:00:00	SPY	ETF	151.68	151.72	151.56	151.67	51602.0
2013-02-12 08:00:00	SPY	ETF	151.64	151.99	151.36	151.82	998137.0
2013-02-12 09:00:00	SPY	ETF	151.81	151.9	151.61	151.762	10269550.0
2013-02-12 10:00:00	SPY	ETF	151.76	152.03	151.75	151.902	10812248.0
2013-02-12 11:00:00	SPY	ETF	151.91	152.0	151.8	151.91	6640385.0
2013-02-12 12:00:00	SPY	ETF	151.915	152.18	151.89	152.15	6151553.0
2013-02-12 13:00:00	SPY	ETF	152.15	152.3	152.13	152.14	5505872.0
2013-02-12 14:00:00	SPY	ETF	152.14	152.16	152.05	152.07	5286111.0
2013-02-12 15:00:00	SPY	ETF	152.08	152.1	151.91	152.01	12128533.0
2013-02-12 16:00:00	SPY	ETF	152.0	152.13	152.0	152.1	5131661.0
2013-02-12 17:00:00	SPY	ETF	152.11	152.2	152.11	152.16	1135150.0
2013-02-12 18:00:00	SPY	ETF	152.16	152.19	152.15	152.17	27341.0
2013-02-12 19:00:00	SPY	ETF	152.18	152.2	152.13	152.19	54234.0
2013-02-12 04:00:00	QQQ	ETF	67.86	67.86	67.86	67.86	100.0
2013-02-12 05:00:00	QQQ	ETF	67.89	67.9	67.89	67.9	350.0
2013-02-12 06:00:00	QQQ	ETF	67.92	67.92	67.92	67.92	300.0
2013-02-12 07:00:00	QQQ	ETF	67.85	67.88	67.85	67.86	36945.0
2013-02-12 08:00:00	QQQ	ETF	67.87	67.99	67.83	67.92	192582.0
2013-02-12 09:00:00	QQQ	ETF	67.93	67.97	67.82	67.84	3151423.0
2013-02-12 10:00:00	QQQ	ETF	67.85	68.05	67.75	67.91	4294329.0
2013-02-12 11:00:00	QQQ	ETF	67.92	67.94	67.66	67.77	3020099.0
2013-02-12 12:00:00	QQQ	ETF	67.765	67.96	67.715	67.92	1939118.0
2013-02-12 13:00:00	QQQ	ETF	67.93	67.98	67.82	67.83	1915058.0
2013-02-12 14:00:00	QQQ	ETF	67.83	67.88	67.8	67.81	1427871.0
2013-02-12 15:00:00	QQQ	ETF	67.81	67.82	67.69	67.71	3724015.0
2013-02-12 16:00:00	QQQ	ETF	67.71	67.83	67.696	67.82	1704778.0
2013-02-12 17:00:00	QQQ	ETF	67.82	67.85	67.73	67.83	65532.0
2013-02-12 18:00:00	QQQ	ETF	67.84	67.85	67.82	67.82	7200.0
2013-02-12 19:00:00	QQQ	ETF	67.8	67.84	67.8	67.84	2300.0
2013-02-12 05:00:00	IWM	ETF	90.69	90.69	90.69	90.69	100.0
2013-02-12 07:00:00	IWM	ETF	90.7	90.7	90.6	90.64	5600.0
2013-02-12 08:00:00	IWM	ETF	90.62	90.89	90.62	90.76	385593.0
2013-02-12 09:00:00	IWM	ETF	90.76	90.91	90.68	90.85	2209657.0
2013-02-12 10:00:00	IWM	ETF	90.86	91.1	90.82	91.015	2667181.0
2013-02-12 11:00:00	IWM	ETF	91.01	91.1	90.96	91.0299	1454216.0
2013-02-12 12:00:00	IWM	ETF	91.03	91.17	90.965	91.15	1494566.0
2013-02-12 13:00:00	IWM	ETF	91.15	91.24	91.12	91.14	1765536.0
2013-02-12 14:00:00	IWM	ETF	91.14	91.17	91.03	91.11	2188361.0
2013-02-12 15:00:00	IWM	ETF	91.11	91.16	91.01	91.08	4419523.0
2013-02-12 16:00:00	IWM	ETF	91.07	91.16	91.07	91.11	1424356.0
2013-02-12 17:00:00	IWM	ETF	91.12	91.14	91.12	91.12	32432.0
2013-02-12 18:00:00	IWM	ETF	91.12	91.14	91.12	91.12	4390.0
2013-02-12 19:00:00	IWM	ETF	91.12	91.16	91.12	91.13	7620.0
2013-02-12 08:00:00	DIA	ETF	139.65	139.74	139.65	139.7	1200.0
2013-02-12 09:00:00	DIA	ETF	139.66	139.75	139.51	139.63	440215.0
2013-02-12 10:00:00	DIA	ETF	139.64	139.88	139.64	139.8	400943.0
2013-02-12 11:00:00	DIA	ETF	139.812	139.93	139.78	139.86	427699.0

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

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