PREVIEW / etf_1hour / 2017-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-16.parquet
  size:    284 KB
  rows:    9,388

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
2017-10-16 04:00:00	SPY	ETF	255.05	255.1	255.05	255.05	6900.0
2017-10-16 05:00:00	SPY	ETF	255.08	255.14	255.08	255.14	5330.0
2017-10-16 06:00:00	SPY	ETF	255.12	255.15	255.11	255.15	10100.0
2017-10-16 07:00:00	SPY	ETF	255.1	255.12	254.99	255.05	212193.0
2017-10-16 08:00:00	SPY	ETF	255.05	255.26	254.95	255.18	943852.0
2017-10-16 09:00:00	SPY	ETF	255.16	255.51	255.11	255.37	4240552.0
2017-10-16 10:00:00	SPY	ETF	255.37	255.42	254.93	254.99	4589627.0
2017-10-16 11:00:00	SPY	ETF	254.995	255.22	254.97	255.06	4947300.0
2017-10-16 12:00:00	SPY	ETF	255.06	255.085	254.82	254.98	3141737.0
2017-10-16 13:00:00	SPY	ETF	254.98	255.18	254.94	255.02	2886057.0
2017-10-16 14:00:00	SPY	ETF	255.02	255.17	255.01	255.1183	2627000.0
2017-10-16 15:00:00	SPY	ETF	255.115	255.34	255.08	255.3	7927081.0
2017-10-16 16:00:00	SPY	ETF	255.3	255.41	255.22	255.31	5365574.0
2017-10-16 17:00:00	SPY	ETF	255.3	255.3	255.18	255.25	121600.0
2017-10-16 18:00:00	SPY	ETF	255.27	255.29	255.25	255.28	26493.0
2017-10-16 19:00:00	SPY	ETF	255.27	255.32	255.27	255.3	62187.0
2017-10-16 04:00:00	QQQ	ETF	148.65	148.69	148.61	148.61	10390.0
2017-10-16 05:00:00	QQQ	ETF	148.62	148.64	148.59	148.59	1200.0
2017-10-16 06:00:00	QQQ	ETF	148.63	148.64	148.62	148.64	10500.0
2017-10-16 07:00:00	QQQ	ETF	148.61	148.63	148.53	148.62	39694.0
2017-10-16 08:00:00	QQQ	ETF	148.61	148.72	148.55	148.71	66837.0
2017-10-16 09:00:00	QQQ	ETF	148.67	148.89	148.67	148.82	3685087.0
2017-10-16 10:00:00	QQQ	ETF	148.83	148.88	148.53	148.69	3469150.0
2017-10-16 11:00:00	QQQ	ETF	148.69	148.78	148.58	148.69	1264722.0
2017-10-16 12:00:00	QQQ	ETF	148.7	148.74	148.3928	148.57	2127591.0
2017-10-16 13:00:00	QQQ	ETF	148.58	148.68	148.495	148.57	733401.0
2017-10-16 14:00:00	QQQ	ETF	148.58	148.72	148.57	148.6898	673375.0
2017-10-16 15:00:00	QQQ	ETF	148.6867	148.87	148.675	148.85	2712875.0
2017-10-16 16:00:00	QQQ	ETF	148.87	148.97	148.83	148.94	616955.0
2017-10-16 17:00:00	QQQ	ETF	148.94	148.94	148.9	148.9	1249.0
2017-10-16 18:00:00	QQQ	ETF	148.91	148.91	148.88	148.9	14272.0
2017-10-16 19:00:00	QQQ	ETF	148.93	148.99	148.93	148.98	7320.0
2017-10-16 06:00:00	IWM	ETF	149.67	149.67	149.67	149.67	200.0
2017-10-16 07:00:00	IWM	ETF	149.61	149.65	149.61	149.65	3750.0
2017-10-16 08:00:00	IWM	ETF	149.62	149.79	149.62	149.7	32901.0
2017-10-16 09:00:00	IWM	ETF	149.61	150.16	149.505	150.14	2067775.0
2017-10-16 10:00:00	IWM	ETF	150.14	150.35	149.34	149.41	2495972.0
2017-10-16 11:00:00	IWM	ETF	149.41	149.58	149.26	149.2951	1417007.0
2017-10-16 12:00:00	IWM	ETF	149.29	149.3666	149.03	149.14	1110825.0
2017-10-16 13:00:00	IWM	ETF	149.14	149.49	149.06	149.23	1564477.0
2017-10-16 14:00:00	IWM	ETF	149.2267	149.32	149.085	149.14	780272.0
2017-10-16 15:00:00	IWM	ETF	149.13	149.38	149.13	149.25	2996435.0
2017-10-16 16:00:00	IWM	ETF	149.26	149.45	148.85	149.37	2893549.0
2017-10-16 17:00:00	IWM	ETF	149.3308	149.36	149.3308	149.36	15791.0
2017-10-16 18:00:00	IWM	ETF	149.39	149.39	149.39	149.39	300.0
2017-10-16 19:00:00	IWM	ETF	149.41	149.44	149.41	149.41	5855.0
2017-10-16 06:00:00	DIA	ETF	229.08	229.08	229.08	229.08	100.0
2017-10-16 07:00:00	DIA	ETF	228.82	228.88	228.8	228.88	3983.0
2017-10-16 08:00:00	DIA	ETF	228.89	229.04	228.89	229.0	7946.0
2017-10-16 09:00:00	DIA	ETF	228.97	229.4	228.97	229.3	508974.0

> showing 50 of 9,388 rows — these rows as CSV

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