PREVIEW / etf_1hour / 2013-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-29.parquet
  size:    205 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-29 04:00:00	SPY	ETF	176.28	176.56	176.25	176.5	10200.0
2013-10-29 05:00:00	SPY	ETF	176.51	176.52	176.29	176.34	50843.0
2013-10-29 06:00:00	SPY	ETF	176.31	176.44	176.3	176.35	33696.0
2013-10-29 07:00:00	SPY	ETF	176.32	176.6	176.32	176.51	116017.0
2013-10-29 08:00:00	SPY	ETF	176.5	176.63	176.43	176.53	751226.0
2013-10-29 09:00:00	SPY	ETF	176.52	176.87	176.5	176.59	11697321.0
2013-10-29 10:00:00	SPY	ETF	176.59	176.81	176.38	176.46	12064830.0
2013-10-29 11:00:00	SPY	ETF	176.46	176.77	176.44	176.68	7704167.0
2013-10-29 12:00:00	SPY	ETF	176.69	177.03	176.66	176.94	8417670.0
2013-10-29 13:00:00	SPY	ETF	176.94	177.08	176.83	176.93	6027894.0
2013-10-29 14:00:00	SPY	ETF	176.93	177.07	176.9	177.01	9344314.0
2013-10-29 15:00:00	SPY	ETF	177.01	177.23	176.79	177.22	15800233.0
2013-10-29 16:00:00	SPY	ETF	177.22	177.27	176.1792	177.25	10789099.0
2013-10-29 17:00:00	SPY	ETF	177.24	177.33	177.22	177.3	203166.0
2013-10-29 18:00:00	SPY	ETF	177.29	177.29	177.17	177.17	79997.0
2013-10-29 19:00:00	SPY	ETF	177.18	177.2	177.13	177.17	75675.0
2013-10-29 04:00:00	QQQ	ETF	82.9	83.09	82.89	83.06	34946.0
2013-10-29 05:00:00	QQQ	ETF	83.07	83.07	82.98	83.0	60900.0
2013-10-29 06:00:00	QQQ	ETF	82.99	83.06	82.98	83.04	15200.0
2013-10-29 07:00:00	QQQ	ETF	83.03	83.15	83.02	83.13	119448.0
2013-10-29 08:00:00	QQQ	ETF	83.13	83.14	83.06	83.09	233889.0
2013-10-29 09:00:00	QQQ	ETF	83.1	83.26	82.8202	82.87	5258493.0
2013-10-29 10:00:00	QQQ	ETF	82.8763	83.03	82.7	82.79	8228777.0
2013-10-29 11:00:00	QQQ	ETF	82.78	83.0	82.72	82.89	6417396.0
2013-10-29 12:00:00	QQQ	ETF	82.895	83.1377	82.88	83.0958	3348373.0
2013-10-29 13:00:00	QQQ	ETF	83.1	83.169	83.0	83.1099	1538428.0
2013-10-29 14:00:00	QQQ	ETF	83.105	83.1651	83.03	83.09	1418995.0
2013-10-29 15:00:00	QQQ	ETF	83.09	83.1	82.88	83.05	5536026.0
2013-10-29 16:00:00	QQQ	ETF	83.05	83.14	82.8538	83.14	2316048.0
2013-10-29 17:00:00	QQQ	ETF	83.16	83.2	83.12	83.14	66800.0
2013-10-29 18:00:00	QQQ	ETF	83.18	83.18	83.13	83.13	46348.0
2013-10-29 19:00:00	QQQ	ETF	83.12	83.15	83.11	83.15	22136.0
2013-10-29 04:00:00	IWM	ETF	111.05	111.05	111.05	111.05	125.0
2013-10-29 06:00:00	IWM	ETF	111.06	111.06	111.06	111.06	500.0
2013-10-29 07:00:00	IWM	ETF	111.35	111.44	111.34	111.38	60667.0
2013-10-29 08:00:00	IWM	ETF	111.37	111.43	111.02	111.31	100164.0
2013-10-29 09:00:00	IWM	ETF	111.29	111.62	111.23	111.24	4278752.0
2013-10-29 10:00:00	IWM	ETF	111.24	111.35	110.89	110.9	3513255.0
2013-10-29 11:00:00	IWM	ETF	110.9	111.05	110.7	110.8	3689518.0
2013-10-29 12:00:00	IWM	ETF	110.81	110.96	110.77	110.895	2843719.0
2013-10-29 13:00:00	IWM	ETF	110.9	110.915	110.53	110.69	2907802.0
2013-10-29 14:00:00	IWM	ETF	110.69	111.078	110.68	110.989	2184756.0
2013-10-29 15:00:00	IWM	ETF	110.99	111.36	110.96	111.36	5083825.0
2013-10-29 16:00:00	IWM	ETF	111.35	111.38	110.9606	111.34	2275361.0
2013-10-29 17:00:00	IWM	ETF	111.34	111.42	111.34	111.42	43467.0
2013-10-29 18:00:00	IWM	ETF	111.38	111.38	111.3	111.3	2200.0
2013-10-29 19:00:00	IWM	ETF	111.38	111.41	111.3	111.34	5532.0
2013-10-29 07:00:00	DIA	ETF	155.6	155.6	155.6	155.6	1100.0
2013-10-29 08:00:00	DIA	ETF	155.67	155.67	155.59	155.59	1250.0
2013-10-29 09:00:00	DIA	ETF	155.65	156.0	155.6	155.87	850040.0

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

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