PREVIEW / etf_1hour / 2019-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-17.parquet
  size:    317 KB
  rows:    10,540

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-05-17 04:00:00	SPY	ETF	287.01	287.01	285.99	286.05	25164.0
2019-05-17 05:00:00	SPY	ETF	286.25	286.88	286.0	286.61	39918.0
2019-05-17 06:00:00	SPY	ETF	286.61	286.61	286.24	286.44	89403.0
2019-05-17 07:00:00	SPY	ETF	286.47	286.53	285.55	285.73	590789.0
2019-05-17 08:00:00	SPY	ETF	285.71	287.7	285.19	285.61	2616903.0
2019-05-17 09:00:00	SPY	ETF	285.66	286.59	285.12	285.93	9167337.0
2019-05-17 10:00:00	SPY	ETF	285.92	288.39	285.63	288.0831	15986063.0
2019-05-17 11:00:00	SPY	ETF	288.08	288.6	287.12	287.53	12245877.0
2019-05-17 12:00:00	SPY	ETF	287.53	287.6	286.75	287.4	6235593.0
2019-05-17 13:00:00	SPY	ETF	287.39	287.885	287.21	287.64	5469621.0
2019-05-17 14:00:00	SPY	ETF	287.64	287.81	287.08	287.465	7197725.0
2019-05-17 15:00:00	SPY	ETF	287.465	287.525	285.5713	285.9	25716675.0
2019-05-17 16:00:00	SPY	ETF	285.89	286.2	285.76	285.97	10611353.0
2019-05-17 17:00:00	SPY	ETF	285.98	286.18	285.84	286.03	687795.0
2019-05-17 18:00:00	SPY	ETF	286.05	286.13	286.0	286.09	30732.0
2019-05-17 19:00:00	SPY	ETF	286.11	286.4	286.07	286.32	118930.0
2019-05-17 04:00:00	QQQ	ETF	184.81	184.81	183.65	183.75	73510.0
2019-05-17 05:00:00	QQQ	ETF	183.84	184.39	183.64	184.24	40931.0
2019-05-17 06:00:00	QQQ	ETF	184.24	184.25	183.91	183.94	76014.0
2019-05-17 07:00:00	QQQ	ETF	184.0	184.1	183.43	183.54	227750.0
2019-05-17 08:00:00	QQQ	ETF	183.9	184.5	182.89	183.23	782859.0
2019-05-17 09:00:00	QQQ	ETF	183.3101	184.35	182.96	183.78	5305605.0
2019-05-17 10:00:00	QQQ	ETF	183.77	185.42	183.3	185.2301	5946215.0
2019-05-17 11:00:00	QQQ	ETF	185.23	185.5813	184.0723	184.44	4077340.0
2019-05-17 12:00:00	QQQ	ETF	184.43	184.52	183.83	184.41	2829237.0
2019-05-17 13:00:00	QQQ	ETF	184.41	184.74	184.09	184.49	2087995.0
2019-05-17 14:00:00	QQQ	ETF	184.49	184.68	184.16	184.37	2009562.0
2019-05-17 15:00:00	QQQ	ETF	184.37	184.4	182.88	183.02	10298802.0
2019-05-17 16:00:00	QQQ	ETF	183.02	184.3131	181.7	182.99	2540426.0
2019-05-17 17:00:00	QQQ	ETF	183.01	183.04	182.88	182.91	35871.0
2019-05-17 18:00:00	QQQ	ETF	182.92	183.0	182.86	182.91	6186.0
2019-05-17 19:00:00	QQQ	ETF	182.91	183.19	182.91	183.19	25952.0
2019-05-17 04:00:00	IWM	ETF	154.23	154.23	154.23	154.23	500.0
2019-05-17 05:00:00	IWM	ETF	154.54	154.54	154.48	154.5	700.0
2019-05-17 06:00:00	IWM	ETF	154.41	154.42	154.24	154.32	4224.0
2019-05-17 07:00:00	IWM	ETF	154.35	154.35	153.95	154.0	25530.0
2019-05-17 08:00:00	IWM	ETF	154.02	154.3599	153.71	153.87	74127.0
2019-05-17 09:00:00	IWM	ETF	153.8	154.38	153.57	153.7917	1996488.0
2019-05-17 10:00:00	IWM	ETF	153.78	155.07	153.34	154.99	2792657.0
2019-05-17 11:00:00	IWM	ETF	154.99	155.27	153.77	154.05	2444079.0
2019-05-17 12:00:00	IWM	ETF	154.04	154.14	153.535	153.93	1558141.0
2019-05-17 13:00:00	IWM	ETF	153.92	154.28	153.85	154.09	813486.0
2019-05-17 14:00:00	IWM	ETF	154.08	154.22	153.81	154.12	943789.0
2019-05-17 15:00:00	IWM	ETF	154.12	154.15	152.66	152.86	5824471.0
2019-05-17 16:00:00	IWM	ETF	152.85	153.07	152.75	152.92	1235107.0
2019-05-17 17:00:00	IWM	ETF	152.94	152.94	152.78	152.85	11846.0
2019-05-17 18:00:00	IWM	ETF	152.85	152.85	152.84	152.84	964.0
2019-05-17 04:00:00	DIA	ETF	257.95	257.95	257.39	257.39	1200.0
2019-05-17 05:00:00	DIA	ETF	257.35	257.88	257.35	257.66	1200.0
2019-05-17 06:00:00	DIA	ETF	257.32	257.48	257.32	257.48	1300.0

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

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