PREVIEW / etf_1hour / 2017-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-15.parquet
  size:    291 KB
  rows:    9,613

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-11-15 04:00:00	SPY	ETF	256.78	256.85	256.47	256.7	22008.0
2017-11-15 05:00:00	SPY	ETF	256.71	256.71	256.3	256.42	27009.0
2017-11-15 06:00:00	SPY	ETF	256.45	256.62	256.4	256.52	103113.0
2017-11-15 07:00:00	SPY	ETF	256.55	256.84	256.55	256.78	222647.0
2017-11-15 08:00:00	SPY	ETF	256.81	257.171	256.58	256.76	677905.0
2017-11-15 09:00:00	SPY	ETF	256.76	256.76	255.63	255.9163	12112371.0
2017-11-15 10:00:00	SPY	ETF	255.91	256.92	255.84	256.91	11372089.0
2017-11-15 11:00:00	SPY	ETF	256.92	257.22	256.81	257.02	7605259.0
2017-11-15 12:00:00	SPY	ETF	257.015	257.05	256.67	256.94	5061313.0
2017-11-15 13:00:00	SPY	ETF	256.95	256.95	256.6	256.63	7299987.0
2017-11-15 14:00:00	SPY	ETF	256.63	256.865	256.51	256.79	4326096.0
2017-11-15 15:00:00	SPY	ETF	256.79	257.02	256.26	256.43	18313328.0
2017-11-15 16:00:00	SPY	ETF	256.44	256.62	256.39	256.47	10511792.0
2017-11-15 17:00:00	SPY	ETF	256.47	256.5	256.4	256.48	498541.0
2017-11-15 18:00:00	SPY	ETF	256.47	256.55	256.3	256.45	337801.0
2017-11-15 19:00:00	SPY	ETF	256.4	256.87	256.38	256.78	149224.0
2017-11-15 20:00:00	SPY	ETF	256.44	256.44	256.4038	256.4038	500000.0
2017-11-15 04:00:00	QQQ	ETF	152.64	152.69	152.46	152.58	40636.0
2017-11-15 05:00:00	QQQ	ETF	152.61	152.63	152.46	152.48	25298.0
2017-11-15 06:00:00	QQQ	ETF	152.47	152.59	152.46	152.54	8686.0
2017-11-15 07:00:00	QQQ	ETF	152.55	152.86	152.55	152.8	94722.0
2017-11-15 08:00:00	QQQ	ETF	152.82	152.94	152.61	152.78	208210.0
2017-11-15 09:00:00	QQQ	ETF	152.75	152.75	151.78	152.0082	5002060.0
2017-11-15 10:00:00	QQQ	ETF	151.97	152.81	151.95	152.81	3501686.0
2017-11-15 11:00:00	QQQ	ETF	152.81	153.0	152.69	152.86	2152556.0
2017-11-15 12:00:00	QQQ	ETF	152.87	152.88	152.62	152.78	1053887.0
2017-11-15 13:00:00	QQQ	ETF	152.78	152.79	152.51	152.679	1477873.0
2017-11-15 14:00:00	QQQ	ETF	152.68	152.8657	152.59	152.83	1032833.0
2017-11-15 15:00:00	QQQ	ETF	152.83	152.96	152.27	152.57	5014207.0
2017-11-15 16:00:00	QQQ	ETF	152.58	152.69	152.0388	152.57	686041.0
2017-11-15 17:00:00	QQQ	ETF	152.55	152.63	152.54	152.63	3005.0
2017-11-15 18:00:00	QQQ	ETF	152.61	152.64	152.53	152.59	17221.0
2017-11-15 19:00:00	QQQ	ETF	152.67	152.9	152.67	152.82	23324.0
2017-11-15 04:00:00	IWM	ETF	145.3	145.33	145.2	145.23	16836.0
2017-11-15 05:00:00	IWM	ETF	145.31	145.31	145.01	145.06	4868.0
2017-11-15 06:00:00	IWM	ETF	145.05	145.15	145.02	145.14	21492.0
2017-11-15 07:00:00	IWM	ETF	145.07	145.39	145.07	145.32	127018.0
2017-11-15 08:00:00	IWM	ETF	145.12	145.49	145.12	145.33	113711.0
2017-11-15 09:00:00	IWM	ETF	145.3	145.35	144.5	145.0	4447466.0
2017-11-15 10:00:00	IWM	ETF	145.0	145.97	144.93	145.95	4875202.0
2017-11-15 11:00:00	IWM	ETF	145.94	146.21	145.755	145.99	1947478.0
2017-11-15 12:00:00	IWM	ETF	146.0	146.15	145.73	145.975	1017166.0
2017-11-15 13:00:00	IWM	ETF	145.98	146.0	145.5002	145.6	1397591.0
2017-11-15 14:00:00	IWM	ETF	145.61	146.03	145.6	145.97	901608.0
2017-11-15 15:00:00	IWM	ETF	145.97	146.05	145.44	145.63	3511429.0
2017-11-15 16:00:00	IWM	ETF	145.63	145.63	145.1473	145.5	975727.0
2017-11-15 17:00:00	IWM	ETF	145.63	145.63	145.43	145.5	208324.0
2017-11-15 18:00:00	IWM	ETF	145.54	145.63	145.4	145.5	17460.0
2017-11-15 19:00:00	IWM	ETF	145.53	145.78	145.5	145.75	386662.0
2017-11-15 04:00:00	DIA	ETF	233.44	233.44	233.2	233.2	400.0

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

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