PREVIEW / etf_1hour / 2017-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-07.parquet
  size:    290 KB
  rows:    9,485

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-12-07 04:00:00	SPY	ETF	263.53	263.8	263.53	263.73	5770.0
2017-12-07 05:00:00	SPY	ETF	263.76	263.78	263.54	263.54	3300.0
2017-12-07 06:00:00	SPY	ETF	263.5	263.57	263.35	263.46	25300.0
2017-12-07 07:00:00	SPY	ETF	263.42	263.47	263.16	263.16	206189.0
2017-12-07 08:00:00	SPY	ETF	263.38	263.46	263.07	263.08	306036.0
2017-12-07 09:00:00	SPY	ETF	263.08	263.56	262.94	263.54	7902364.0
2017-12-07 10:00:00	SPY	ETF	263.55	263.95	263.27	263.93	7350031.0
2017-12-07 11:00:00	SPY	ETF	263.93	264.31	263.59	264.265	8683371.0
2017-12-07 12:00:00	SPY	ETF	264.27	264.31	264.08	264.305	4551940.0
2017-12-07 13:00:00	SPY	ETF	264.305	264.43	264.01	264.1671	6558511.0
2017-12-07 14:00:00	SPY	ETF	264.17	264.24	263.56	263.9	9250531.0
2017-12-07 15:00:00	SPY	ETF	263.9	264.11	263.74	264.04	15798660.0
2017-12-07 16:00:00	SPY	ETF	264.04	264.29	263.2394	264.24	9586511.0
2017-12-07 17:00:00	SPY	ETF	264.23	264.32	263.9363	264.28	224661.0
2017-12-07 18:00:00	SPY	ETF	264.28	264.42	264.07	264.42	165089.0
2017-12-07 19:00:00	SPY	ETF	264.41	264.42	264.08	264.3	66651.0
2017-12-07 04:00:00	QQQ	ETF	154.0	154.11	153.96	154.11	5403.0
2017-12-07 05:00:00	QQQ	ETF	154.03	154.15	154.01	154.01	34456.0
2017-12-07 06:00:00	QQQ	ETF	153.97	153.97	153.77	153.85	29500.0
2017-12-07 07:00:00	QQQ	ETF	153.87	153.89	153.61	153.62	208088.0
2017-12-07 08:00:00	QQQ	ETF	153.82	153.93	153.61	153.69	246399.0
2017-12-07 09:00:00	QQQ	ETF	153.7	153.99	153.33	153.77	3969969.0
2017-12-07 10:00:00	QQQ	ETF	153.76	154.38	153.37	154.31	5399487.0
2017-12-07 11:00:00	QQQ	ETF	154.31	154.46	153.96	154.41	2442205.0
2017-12-07 12:00:00	QQQ	ETF	154.41	154.42	154.15	154.34	1176487.0
2017-12-07 13:00:00	QQQ	ETF	154.35	154.43	153.9	154.1	3547257.0
2017-12-07 14:00:00	QQQ	ETF	154.1	154.155	153.58	153.94	2999516.0
2017-12-07 15:00:00	QQQ	ETF	153.93	154.14	153.82	154.04	4779208.0
2017-12-07 16:00:00	QQQ	ETF	154.04	154.19	153.99	154.19	2840894.0
2017-12-07 17:00:00	QQQ	ETF	154.08	154.2	154.08	154.17	8597.0
2017-12-07 18:00:00	QQQ	ETF	154.16	154.29	154.02	154.26	239277.0
2017-12-07 19:00:00	QQQ	ETF	154.26	154.33	154.1	154.29	55684.0
2017-12-07 04:00:00	IWM	ETF	150.39	150.45	150.37	150.4	5603.0
2017-12-07 05:00:00	IWM	ETF	150.44	150.44	150.44	150.44	100.0
2017-12-07 06:00:00	IWM	ETF	150.28	150.28	150.25	150.28	7265.0
2017-12-07 07:00:00	IWM	ETF	150.32	150.34	150.21	150.28	105956.0
2017-12-07 08:00:00	IWM	ETF	150.22	150.39	150.21	150.22	48708.0
2017-12-07 09:00:00	IWM	ETF	150.19	151.12	150.02	151.12	2177745.0
2017-12-07 10:00:00	IWM	ETF	151.13	151.72	150.83	151.61	4963986.0
2017-12-07 11:00:00	IWM	ETF	151.61	151.89	151.205	151.81	2194470.0
2017-12-07 12:00:00	IWM	ETF	151.81	151.83	151.3	151.441	1233179.0
2017-12-07 13:00:00	IWM	ETF	151.445	151.53	150.97	151.14	1483561.0
2017-12-07 14:00:00	IWM	ETF	151.15	151.26	150.99	151.24	1318499.0
2017-12-07 15:00:00	IWM	ETF	151.235	151.39	151.095	151.27	3451475.0
2017-12-07 16:00:00	IWM	ETF	151.28	151.44	151.2	151.39	3978911.0
2017-12-07 17:00:00	IWM	ETF	151.39	151.3943	151.39	151.3943	94394.0
2017-12-07 18:00:00	IWM	ETF	151.44	154.02	151.26	151.59	2814440.0
2017-12-07 19:00:00	IWM	ETF	151.55	151.55	151.36	151.41	22152.0
2017-12-07 05:00:00	DIA	ETF	241.9	241.9	241.8	241.8	750.0
2017-12-07 06:00:00	DIA	ETF	241.71	241.71	241.7	241.7	600.0

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

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