PREVIEW / etf_1hour / 2018-03-13

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-13.parquet
  size:    299 KB
  rows:    9,847

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
2018-03-13 04:00:00	SPY	ETF	278.97	279.1	278.9	279.03	10291.0
2018-03-13 05:00:00	SPY	ETF	279.09	279.27	279.05	279.13	8520.0
2018-03-13 06:00:00	SPY	ETF	279.14	279.32	279.1	279.25	14516.0
2018-03-13 07:00:00	SPY	ETF	279.2	279.27	279.09	279.16	157231.0
2018-03-13 08:00:00	SPY	ETF	279.17	280.17	278.76	279.68	2333941.0
2018-03-13 09:00:00	SPY	ETF	279.66	280.41	279.4	279.9	7750164.0
2018-03-13 10:00:00	SPY	ETF	279.91	280.09	279.0	279.025	7991546.0
2018-03-13 11:00:00	SPY	ETF	279.02	279.07	278.01	278.2	13904410.0
2018-03-13 12:00:00	SPY	ETF	278.2	278.39	277.15	278.18	10349987.0
2018-03-13 13:00:00	SPY	ETF	278.19	278.535	277.56	277.64	5451683.0
2018-03-13 14:00:00	SPY	ETF	277.635	277.93	276.91	277.21	7449992.0
2018-03-13 15:00:00	SPY	ETF	277.21	277.49	276.03	276.69	24154334.0
2018-03-13 16:00:00	SPY	ETF	276.69	277.1	276.63	276.65	8727292.0
2018-03-13 17:00:00	SPY	ETF	276.63	277.05	276.3	276.41	2203220.0
2018-03-13 18:00:00	SPY	ETF	276.45	276.54	276.0	276.5	215877.0
2018-03-13 19:00:00	SPY	ETF	276.53	276.65	276.36	276.55	46529.0
2018-03-13 04:00:00	QQQ	ETF	174.2	174.2	174.06	174.1	27050.0
2018-03-13 05:00:00	QQQ	ETF	174.22	174.26	174.09	174.14	6400.0
2018-03-13 06:00:00	QQQ	ETF	174.13	174.24	174.13	174.24	17320.0
2018-03-13 07:00:00	QQQ	ETF	174.26	174.29	174.17	174.27	105869.0
2018-03-13 08:00:00	QQQ	ETF	174.21	174.9	173.85	174.7	647973.0
2018-03-13 09:00:00	QQQ	ETF	174.69	175.21	174.55	174.79	3685132.0
2018-03-13 10:00:00	QQQ	ETF	174.8	175.06	173.85	173.88	4508061.0
2018-03-13 11:00:00	QQQ	ETF	173.89	173.91	172.72	173.0201	7115504.0
2018-03-13 12:00:00	QQQ	ETF	173.02	173.09	171.96	172.94	5688621.0
2018-03-13 13:00:00	QQQ	ETF	172.94	173.275	172.56	172.6001	3732574.0
2018-03-13 14:00:00	QQQ	ETF	172.61	172.82	171.89	172.18	4827818.0
2018-03-13 15:00:00	QQQ	ETF	172.19	172.41	171.2666	171.77	8062552.0
2018-03-13 16:00:00	QQQ	ETF	171.775	172.7751	171.71	171.74	1180340.0
2018-03-13 17:00:00	QQQ	ETF	171.78	171.8	171.21	171.44	100970.0
2018-03-13 18:00:00	QQQ	ETF	171.42	171.71	171.18	171.64	1167107.0
2018-03-13 19:00:00	QQQ	ETF	171.66	171.7	171.49	171.62	52714.0
2018-03-13 05:00:00	IWM	ETF	159.69	159.8	159.68	159.71	14144.0
2018-03-13 06:00:00	IWM	ETF	159.74	159.84	159.74	159.84	2495.0
2018-03-13 07:00:00	IWM	ETF	159.85	159.85	159.72	159.72	56202.0
2018-03-13 08:00:00	IWM	ETF	159.81	160.15	159.37	159.89	277150.0
2018-03-13 09:00:00	IWM	ETF	159.92	160.3	159.76	159.7925	1435299.0
2018-03-13 10:00:00	IWM	ETF	159.79	160.23	159.495	159.64	1777815.0
2018-03-13 11:00:00	IWM	ETF	159.67	159.68	158.79	158.935	1786160.0
2018-03-13 12:00:00	IWM	ETF	158.94	159.4	158.33	159.27	2007328.0
2018-03-13 13:00:00	IWM	ETF	159.27	159.49	158.87	159.0	1112333.0
2018-03-13 14:00:00	IWM	ETF	158.99	159.07	158.5075	158.7	1498454.0
2018-03-13 15:00:00	IWM	ETF	158.7	158.84	158.14	158.41	4410279.0
2018-03-13 16:00:00	IWM	ETF	158.41	159.0	158.3675	158.63	1135490.0
2018-03-13 17:00:00	IWM	ETF	158.55	158.56	158.46	158.46	3316.0
2018-03-13 18:00:00	IWM	ETF	158.53	158.58	158.29	158.58	17201.0
2018-03-13 19:00:00	IWM	ETF	158.6	158.63	158.48	158.63	5967.0
2018-03-13 04:00:00	DIA	ETF	252.69	252.79	252.69	252.79	1100.0
2018-03-13 05:00:00	DIA	ETF	252.75	252.75	252.75	252.75	4800.0
2018-03-13 07:00:00	DIA	ETF	252.79	252.79	252.76	252.76	2800.0

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

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