PREVIEW / etf_1hour / 2016-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-28.parquet
  size:    242 KB
  rows:    7,809

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-28 04:00:00	SPY	ETF	204.29	204.44	204.15	204.18	16110.0
2016-03-28 05:00:00	SPY	ETF	204.12	204.12	204.05	204.05	1578.0
2016-03-28 06:00:00	SPY	ETF	204.04	204.08	203.87	203.88	33849.0
2016-03-28 07:00:00	SPY	ETF	203.87	203.96	203.75	203.77	89972.0
2016-03-28 08:00:00	SPY	ETF	203.75	203.91	203.61	203.67	397878.0
2016-03-28 09:00:00	SPY	ETF	203.67	203.79	203.05	203.2038	6774452.0
2016-03-28 10:00:00	SPY	ETF	203.2	203.46	202.705	203.015	9375009.0
2016-03-28 11:00:00	SPY	ETF	203.02	203.33	202.8	203.26	6803255.0
2016-03-28 12:00:00	SPY	ETF	203.26	203.67	203.04	203.6487	5202496.0
2016-03-28 13:00:00	SPY	ETF	203.64	203.66	203.41	203.59	3899456.0
2016-03-28 14:00:00	SPY	ETF	203.59	203.86	203.11	203.265	7522859.0
2016-03-28 15:00:00	SPY	ETF	203.26	203.67	203.08	203.26	14823612.0
2016-03-28 16:00:00	SPY	ETF	203.25	203.42	203.19	203.27	4090588.0
2016-03-28 17:00:00	SPY	ETF	203.24	203.32	203.15	203.23	79517.0
2016-03-28 18:00:00	SPY	ETF	203.18	203.45	203.16	203.45	580857.0
2016-03-28 19:00:00	SPY	ETF	203.43	203.43	203.18	203.22	46516.0
2016-03-28 04:00:00	QQQ	ETF	107.98	107.99	107.89	107.94	827.0
2016-03-28 05:00:00	QQQ	ETF	107.79	107.79	107.79	107.79	300.0
2016-03-28 07:00:00	QQQ	ETF	107.63	107.66	107.56	107.56	14452.0
2016-03-28 08:00:00	QQQ	ETF	107.57	107.64	107.57	107.58	16533.0
2016-03-28 09:00:00	QQQ	ETF	107.6	107.69	106.92	107.105	1935829.0
2016-03-28 10:00:00	QQQ	ETF	107.1	107.48	107.02	107.18	2286331.0
2016-03-28 11:00:00	QQQ	ETF	107.18	107.39	107.05	107.36	1304546.0
2016-03-28 12:00:00	QQQ	ETF	107.36	107.44	107.15	107.38	1336876.0
2016-03-28 13:00:00	QQQ	ETF	107.38	107.38	107.15	107.31	1285381.0
2016-03-28 14:00:00	QQQ	ETF	107.32	107.48	106.975	107.06	1569031.0
2016-03-28 15:00:00	QQQ	ETF	107.07	107.32	107.01	107.12	3133797.0
2016-03-28 16:00:00	QQQ	ETF	107.14	107.16	107.09	107.13	194967.0
2016-03-28 17:00:00	QQQ	ETF	107.12	107.12	107.09	107.09	5800.0
2016-03-28 18:00:00	QQQ	ETF	107.12	107.2	107.12	107.2	18686.0
2016-03-28 19:00:00	QQQ	ETF	107.2	107.2	107.13	107.15	7822.0
2016-03-28 04:00:00	IWM	ETF	107.81	107.81	107.81	107.81	1000.0
2016-03-28 07:00:00	IWM	ETF	107.54	107.54	107.5	107.5	2100.0
2016-03-28 08:00:00	IWM	ETF	107.52	107.64	107.48	107.55	8786.0
2016-03-28 09:00:00	IWM	ETF	107.56	107.65	106.97	107.18	1941134.0
2016-03-28 10:00:00	IWM	ETF	107.18	107.3231	106.58	106.69	2858387.0
2016-03-28 11:00:00	IWM	ETF	106.69	106.84	106.55	106.76	1881454.0
2016-03-28 12:00:00	IWM	ETF	106.75	107.7	106.65	107.61	2174431.0
2016-03-28 13:00:00	IWM	ETF	107.615	107.78	107.48	107.6625	1349588.0
2016-03-28 14:00:00	IWM	ETF	107.67	107.76	107.275	107.365	2079380.0
2016-03-28 15:00:00	IWM	ETF	107.37	107.58	107.09	107.31	4689874.0
2016-03-28 16:00:00	IWM	ETF	107.32	107.33	107.2	107.23	2896116.0
2016-03-28 17:00:00	IWM	ETF	107.21	107.21	107.13	107.21	17300.0
2016-03-28 18:00:00	IWM	ETF	107.23	107.27	107.23	107.27	557.0
2016-03-28 19:00:00	IWM	ETF	107.21	107.21	107.21	107.21	1000.0
2016-03-28 04:00:00	DIA	ETF	175.82	175.82	175.82	175.82	111.0
2016-03-28 08:00:00	DIA	ETF	175.66	175.66	175.4	175.4	4800.0
2016-03-28 09:00:00	DIA	ETF	175.35	175.38	174.91	175.1	382294.0
2016-03-28 10:00:00	DIA	ETF	175.1032	175.34	174.66	174.8	321241.0
2016-03-28 11:00:00	DIA	ETF	174.82	175.1	174.71	175.0799	297201.0

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

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