PREVIEW / etf_1hour / 2017-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-25.parquet
  size:    285 KB
  rows:    9,304

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-09-25 04:00:00	SPY	ETF	249.36	249.36	249.07	249.34	18709.0
2017-09-25 05:00:00	SPY	ETF	249.34	249.34	249.11	249.25	13215.0
2017-09-25 06:00:00	SPY	ETF	249.28	249.37	249.28	249.37	19123.0
2017-09-25 07:00:00	SPY	ETF	249.39	249.45	249.34	249.4	40853.0
2017-09-25 08:00:00	SPY	ETF	249.45	249.45	249.14	249.17	153004.0
2017-09-25 09:00:00	SPY	ETF	249.17	249.34	249.05	249.23	3963325.0
2017-09-25 10:00:00	SPY	ETF	249.2201	249.5532	248.57	248.605	10122404.0
2017-09-25 11:00:00	SPY	ETF	248.6	248.82	248.08	248.53	9098104.0
2017-09-25 12:00:00	SPY	ETF	248.54	248.795	248.16	248.695	5550874.0
2017-09-25 13:00:00	SPY	ETF	248.69	248.88	248.56	248.72	3687280.0
2017-09-25 14:00:00	SPY	ETF	248.73	248.85	248.38	248.65	5779563.0
2017-09-25 15:00:00	SPY	ETF	248.66	249.01	248.53	248.94	10731186.0
2017-09-25 16:00:00	SPY	ETF	248.94	249.36	248.93	249.33	5970611.0
2017-09-25 17:00:00	SPY	ETF	249.33	249.35	248.7074	249.33	125453.0
2017-09-25 18:00:00	SPY	ETF	249.34	249.37	249.28	249.3	65436.0
2017-09-25 19:00:00	SPY	ETF	249.3	249.32	249.15	249.23	79118.0
2017-09-25 04:00:00	QQQ	ETF	144.06	144.2	144.06	144.2	11297.0
2017-09-25 05:00:00	QQQ	ETF	144.2	144.2	144.07	144.14	10014.0
2017-09-25 06:00:00	QQQ	ETF	144.12	144.26	144.12	144.26	5722.0
2017-09-25 07:00:00	QQQ	ETF	144.25	144.29	144.13	144.13	47665.0
2017-09-25 08:00:00	QQQ	ETF	144.23	144.25	143.73	143.75	183972.0
2017-09-25 09:00:00	QQQ	ETF	143.72	143.76	143.16	143.35	3966370.0
2017-09-25 10:00:00	QQQ	ETF	143.36	143.8299	142.53	142.61	8237597.0
2017-09-25 11:00:00	QQQ	ETF	142.6	142.91	142.34	142.58	5914321.0
2017-09-25 12:00:00	QQQ	ETF	142.59	142.78	142.17	142.67	7058334.0
2017-09-25 13:00:00	QQQ	ETF	142.6762	142.78	142.48	142.619	3807001.0
2017-09-25 14:00:00	QQQ	ETF	142.63	142.72	142.1	142.4333	3424084.0
2017-09-25 15:00:00	QQQ	ETF	142.43	142.82	142.28	142.81	8971276.0
2017-09-25 16:00:00	QQQ	ETF	142.81	143.0	142.7308	143.0	2376462.0
2017-09-25 17:00:00	QQQ	ETF	142.445	143.04	142.445	142.96	22393.0
2017-09-25 18:00:00	QQQ	ETF	142.96	143.0	142.9	142.91	14751.0
2017-09-25 19:00:00	QQQ	ETF	142.94	142.94	142.83	142.9	35408.0
2017-09-25 04:00:00	IWM	ETF	144.45	144.45	144.12	144.12	440.0
2017-09-25 05:00:00	IWM	ETF	144.24	144.24	144.13	144.16	1287.0
2017-09-25 06:00:00	IWM	ETF	144.2	144.31	144.2	144.31	16815.0
2017-09-25 07:00:00	IWM	ETF	144.31	144.35	144.21	144.28	32889.0
2017-09-25 08:00:00	IWM	ETF	144.28	144.33	144.13	144.15	53592.0
2017-09-25 09:00:00	IWM	ETF	144.15	144.7	144.05	144.57	3273442.0
2017-09-25 10:00:00	IWM	ETF	144.57	144.94	144.21	144.23	3743347.0
2017-09-25 11:00:00	IWM	ETF	144.23	144.26	143.79	144.04	5714518.0
2017-09-25 12:00:00	IWM	ETF	144.045	144.295	143.69	144.19	2893419.0
2017-09-25 13:00:00	IWM	ETF	144.19	144.355	144.15	144.33	1579679.0
2017-09-25 14:00:00	IWM	ETF	144.34	144.47	144.235	144.45	1721256.0
2017-09-25 15:00:00	IWM	ETF	144.44	144.54	144.35	144.51	3291127.0
2017-09-25 16:00:00	IWM	ETF	144.5	144.75	144.394	144.73	4924303.0
2017-09-25 17:00:00	IWM	ETF	144.38	144.75	144.38	144.7	70564.0
2017-09-25 18:00:00	IWM	ETF	144.73	144.75	144.73	144.73	4900.0
2017-09-25 19:00:00	IWM	ETF	144.68	144.75	144.61	144.64	29946.0
2017-09-25 06:00:00	DIA	ETF	223.28	223.28	223.28	223.28	100.0
2017-09-25 09:00:00	DIA	ETF	222.98	223.34	222.95	223.21	461880.0

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

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