PREVIEW / etf_1hour / 2016-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-24.parquet
  size:    247 KB
  rows:    7,918

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
2016-03-24 04:00:00	SPY	ETF	202.88	202.93	202.53	202.66	21486.0
2016-03-24 05:00:00	SPY	ETF	202.68	202.68	202.39	202.6	12510.0
2016-03-24 06:00:00	SPY	ETF	202.45	202.53	202.23	202.23	42202.0
2016-03-24 07:00:00	SPY	ETF	202.24	202.32	202.14	202.22	247848.0
2016-03-24 08:00:00	SPY	ETF	202.22	203.255	201.82	202.06	1899553.0
2016-03-24 09:00:00	SPY	ETF	202.05	202.3	201.74	202.25	11227142.0
2016-03-24 10:00:00	SPY	ETF	202.25	202.52	201.92	202.47	11060804.0
2016-03-24 11:00:00	SPY	ETF	202.47	202.65	202.09	202.3	7111986.0
2016-03-24 12:00:00	SPY	ETF	202.3	202.66	201.99	202.2	9500290.0
2016-03-24 13:00:00	SPY	ETF	202.2	202.63	202.18	202.531	5145326.0
2016-03-24 14:00:00	SPY	ETF	202.54	202.93	202.33	202.8	7131050.0
2016-03-24 15:00:00	SPY	ETF	202.8	203.16	202.66	203.14	19965449.0
2016-03-24 16:00:00	SPY	ETF	203.15	203.48	203.1	203.48	8226131.0
2016-03-24 17:00:00	SPY	ETF	203.43	203.48	203.38	203.43	103987.0
2016-03-24 18:00:00	SPY	ETF	203.43	203.61	203.37	203.52	215255.0
2016-03-24 19:00:00	SPY	ETF	203.54	203.56	203.46	203.52	80280.0
2016-03-24 04:00:00	QQQ	ETF	107.0	107.0	106.85	106.85	2178.0
2016-03-24 05:00:00	QQQ	ETF	106.74	106.74	106.74	106.74	3000.0
2016-03-24 06:00:00	QQQ	ETF	106.74	106.75	106.69	106.69	8964.0
2016-03-24 07:00:00	QQQ	ETF	106.66	106.71	106.61	106.67	27099.0
2016-03-24 08:00:00	QQQ	ETF	106.67	106.78	106.55	106.68	113760.0
2016-03-24 09:00:00	QQQ	ETF	106.64	106.97	106.53	106.95	3039271.0
2016-03-24 10:00:00	QQQ	ETF	106.94	107.185	106.75	107.14	2434043.0
2016-03-24 11:00:00	QQQ	ETF	107.14	107.26	106.892	107.0	1821523.0
2016-03-24 12:00:00	QQQ	ETF	106.99	107.13	106.7	106.82	1365081.0
2016-03-24 13:00:00	QQQ	ETF	106.825	107.01	106.81	106.92	1141481.0
2016-03-24 14:00:00	QQQ	ETF	106.93	107.2	106.82	107.13	1561531.0
2016-03-24 15:00:00	QQQ	ETF	107.14	107.29	107.05	107.25	2466132.0
2016-03-24 16:00:00	QQQ	ETF	107.24	107.38	106.9911	107.37	2040559.0
2016-03-24 17:00:00	QQQ	ETF	107.29	107.35	107.26	107.33	2300.0
2016-03-24 18:00:00	QQQ	ETF	107.35	107.35	107.3	107.31	2721.0
2016-03-24 19:00:00	QQQ	ETF	107.32	107.34	107.27	107.27	5571.0
2016-03-24 04:00:00	IWM	ETF	106.8	106.8	106.52	106.52	1535.0
2016-03-24 05:00:00	IWM	ETF	106.52	106.52	106.52	106.52	300.0
2016-03-24 06:00:00	IWM	ETF	106.53	106.53	106.4	106.46	6276.0
2016-03-24 07:00:00	IWM	ETF	106.39	106.39	106.31	106.31	27073.0
2016-03-24 08:00:00	IWM	ETF	106.4	106.46	106.11	106.24	149100.0
2016-03-24 09:00:00	IWM	ETF	106.23	106.38	105.74	106.2	4382868.0
2016-03-24 10:00:00	IWM	ETF	106.2	106.77	105.955	106.69	4772958.0
2016-03-24 11:00:00	IWM	ETF	106.69	106.8	106.31	106.45	2307007.0
2016-03-24 12:00:00	IWM	ETF	106.45	106.78	106.23	106.52	2170804.0
2016-03-24 13:00:00	IWM	ETF	106.515	106.7776	106.46	106.73	1856728.0
2016-03-24 14:00:00	IWM	ETF	106.74	107.02	106.5502	106.9	2533843.0
2016-03-24 15:00:00	IWM	ETF	106.92	107.22	106.8	107.19	5428261.0
2016-03-24 16:00:00	IWM	ETF	107.19	107.32	107.1	107.29	745172.0
2016-03-24 17:00:00	IWM	ETF	107.27	107.3	107.27	107.3	677.0
2016-03-24 18:00:00	IWM	ETF	107.22	107.25	107.22	107.25	800.0
2016-03-24 19:00:00	IWM	ETF	107.26	107.26	107.25	107.25	1396.0
2016-03-24 05:00:00	DIA	ETF	174.4	174.4	174.4	174.4	1000.0
2016-03-24 07:00:00	DIA	ETF	174.19	174.2	174.1	174.1	10400.0

> showing 50 of 7,918 rows — these rows as CSV

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