PREVIEW / etf_1hour / 2019-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-09.parquet
  size:    318 KB
  rows:    10,624

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
2019-04-09 04:00:00	SPY	ETF	288.48	288.63	288.4	288.63	6420.0
2019-04-09 05:00:00	SPY	ETF	288.63	288.7	288.55	288.63	2225.0
2019-04-09 06:00:00	SPY	ETF	288.58	288.58	288.5	288.5	3500.0
2019-04-09 07:00:00	SPY	ETF	288.6	288.64	288.46	288.46	176666.0
2019-04-09 08:00:00	SPY	ETF	288.49	288.61	288.03	288.05	2130632.0
2019-04-09 09:00:00	SPY	ETF	288.05	288.13	286.99	287.45	8379152.0
2019-04-09 10:00:00	SPY	ETF	287.46	287.81	287.14	287.52	8910308.0
2019-04-09 11:00:00	SPY	ETF	287.53	287.79	287.38	287.59	7582816.0
2019-04-09 12:00:00	SPY	ETF	287.58	288.08	287.52	287.68	5855128.0
2019-04-09 13:00:00	SPY	ETF	287.6715	287.6715	287.24	287.35	4192749.0
2019-04-09 14:00:00	SPY	ETF	287.35	287.4	286.93	287.04	7286813.0
2019-04-09 15:00:00	SPY	ETF	287.042	287.5718	286.7	287.305	14922747.0
2019-04-09 16:00:00	SPY	ETF	287.3	287.36	287.03	287.18	5142161.0
2019-04-09 17:00:00	SPY	ETF	287.16	287.2	287.1	287.12	36807.0
2019-04-09 18:00:00	SPY	ETF	287.14	287.24	287.12	287.14	34601.0
2019-04-09 19:00:00	SPY	ETF	287.14	287.21	287.01	287.12	26394.0
2019-04-09 04:00:00	QQQ	ETF	184.92	185.05	184.88	184.9	27317.0
2019-04-09 05:00:00	QQQ	ETF	184.86	185.0	184.8	184.97	59150.0
2019-04-09 06:00:00	QQQ	ETF	184.96	184.97	184.88	184.91	6150.0
2019-04-09 07:00:00	QQQ	ETF	184.93	185.02	184.85	184.93	104631.0
2019-04-09 08:00:00	QQQ	ETF	184.89	185.11	184.58	184.7	285042.0
2019-04-09 09:00:00	QQQ	ETF	184.67	184.84	184.22	184.75	3454237.0
2019-04-09 10:00:00	QQQ	ETF	184.76	185.1	184.4937	184.79	5227543.0
2019-04-09 11:00:00	QQQ	ETF	184.8	185.03	184.67	184.82	2367441.0
2019-04-09 12:00:00	QQQ	ETF	184.82	185.11	184.77	184.86	1376556.0
2019-04-09 13:00:00	QQQ	ETF	184.85	184.86	184.37	184.47	1628326.0
2019-04-09 14:00:00	QQQ	ETF	184.48	184.56	184.27	184.43	2458125.0
2019-04-09 15:00:00	QQQ	ETF	184.43	184.6101	184.09	184.48	4461823.0
2019-04-09 16:00:00	QQQ	ETF	184.48	185.1779	184.28	184.35	453939.0
2019-04-09 17:00:00	QQQ	ETF	184.43	184.45	184.31	184.36	5698.0
2019-04-09 18:00:00	QQQ	ETF	184.35	184.4	184.3	184.33	56683.0
2019-04-09 19:00:00	QQQ	ETF	184.33	184.35	184.23	184.32	21432.0
2019-04-09 04:00:00	IWM	ETF	156.86	156.87	156.86	156.87	1300.0
2019-04-09 05:00:00	IWM	ETF	157.05	157.09	157.05	157.08	7500.0
2019-04-09 06:00:00	IWM	ETF	157.0	157.03	156.99	157.0	2500.0
2019-04-09 07:00:00	IWM	ETF	157.0	157.04	156.95	156.97	11500.0
2019-04-09 08:00:00	IWM	ETF	156.96	156.96	156.63	156.63	43878.0
2019-04-09 09:00:00	IWM	ETF	156.63	156.68	155.95	156.37	2132007.0
2019-04-09 10:00:00	IWM	ETF	156.38	156.42	155.6	155.96	2858377.0
2019-04-09 11:00:00	IWM	ETF	155.97	156.46	155.91	156.31	1218116.0
2019-04-09 12:00:00	IWM	ETF	156.3	156.7	156.24	156.265	940076.0
2019-04-09 13:00:00	IWM	ETF	156.26	156.29	155.905	155.94	1123726.0
2019-04-09 14:00:00	IWM	ETF	155.94	155.96	155.6	155.69	1504518.0
2019-04-09 15:00:00	IWM	ETF	155.6831	155.83	154.91	155.21	5748410.0
2019-04-09 16:00:00	IWM	ETF	155.22	155.26	155.04	155.2	1544129.0
2019-04-09 17:00:00	IWM	ETF	155.2	155.2	155.17	155.17	914.0
2019-04-09 18:00:00	IWM	ETF	155.19	155.22	155.15	155.19	9878.0
2019-04-09 19:00:00	IWM	ETF	155.19	155.19	155.08	155.12	7235.0
2019-04-09 06:00:00	DIA	ETF	263.2	263.2	263.2	263.2	150.0
2019-04-09 07:00:00	DIA	ETF	263.14	263.18	263.06	263.06	1045.0

> showing 50 of 10,624 rows — these rows as CSV

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