PREVIEW / etf_1hour / 2018-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-04.parquet
  size:    326 KB
  rows:    10,663

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-10-04 04:00:00	SPY	ETF	290.7	291.25	290.21	290.4	126685.0
2018-10-04 05:00:00	SPY	ETF	290.39	290.68	290.18	290.5	30590.0
2018-10-04 06:00:00	SPY	ETF	290.55	290.94	290.55	290.92	26717.0
2018-10-04 07:00:00	SPY	ETF	290.92	291.04	290.75	290.91	253786.0
2018-10-04 08:00:00	SPY	ETF	291.72	291.72	290.26	291.02	531000.0
2018-10-04 09:00:00	SPY	ETF	291.02	291.24	290.63	290.74	7089183.0
2018-10-04 10:00:00	SPY	ETF	290.73	290.74	289.43	289.69	15324574.0
2018-10-04 11:00:00	SPY	ETF	289.6877	290.18	289.17	289.21	11065929.0
2018-10-04 12:00:00	SPY	ETF	289.215	289.37	288.28	288.765	15587963.0
2018-10-04 13:00:00	SPY	ETF	288.76	288.845	287.93	288.15	13249817.0
2018-10-04 14:00:00	SPY	ETF	288.14	289.16	287.66	289.0625	14699074.0
2018-10-04 15:00:00	SPY	ETF	289.06	289.67	288.62	289.47	20558992.0
2018-10-04 16:00:00	SPY	ETF	289.49	289.88	288.25	289.88	11094896.0
2018-10-04 17:00:00	SPY	ETF	289.87	289.91	289.71	289.85	280016.0
2018-10-04 18:00:00	SPY	ETF	289.84	289.9	289.66	289.69	95279.0
2018-10-04 19:00:00	SPY	ETF	289.72	289.94	289.64	289.88	71510.0
2018-10-04 04:00:00	QQQ	ETF	185.23	185.23	184.7	184.83	28574.0
2018-10-04 05:00:00	QQQ	ETF	184.64	184.96	184.56	184.79	33715.0
2018-10-04 06:00:00	QQQ	ETF	184.96	185.05	184.93	184.99	24819.0
2018-10-04 07:00:00	QQQ	ETF	185.13	185.24	184.9	185.08	186153.0
2018-10-04 08:00:00	QQQ	ETF	185.08	185.22	184.77	185.15	283444.0
2018-10-04 09:00:00	QQQ	ETF	185.14	185.32	183.95	184.3	6155746.0
2018-10-04 10:00:00	QQQ	ETF	184.29	184.3	182.96	183.1	9056887.0
2018-10-04 11:00:00	QQQ	ETF	183.1	183.56	182.48	182.58	6403315.0
2018-10-04 12:00:00	QQQ	ETF	182.5893	182.74	181.8	181.98	9841960.0
2018-10-04 13:00:00	QQQ	ETF	181.97	182.16	181.27	181.4537	7977412.0
2018-10-04 14:00:00	QQQ	ETF	181.4545	182.33	181.06	182.25	8843372.0
2018-10-04 15:00:00	QQQ	ETF	182.24	182.61	181.77	182.45	11310123.0
2018-10-04 16:00:00	QQQ	ETF	182.45	186.0106	182.35	182.67	2166320.0
2018-10-04 17:00:00	QQQ	ETF	182.67	182.7	182.5	182.7	35945.0
2018-10-04 18:00:00	QQQ	ETF	182.65	182.65	182.38	182.49	64872.0
2018-10-04 19:00:00	QQQ	ETF	182.44	182.6	182.37	182.6	33827.0
2018-10-04 04:00:00	IWM	ETF	165.0	165.08	165.0	165.07	6200.0
2018-10-04 05:00:00	IWM	ETF	164.99	165.26	164.97	165.16	31899.0
2018-10-04 06:00:00	IWM	ETF	165.29	165.38	165.29	165.37	8947.0
2018-10-04 07:00:00	IWM	ETF	165.46	165.49	165.38	165.42	59251.0
2018-10-04 08:00:00	IWM	ETF	165.97	165.97	165.11	165.47	75133.0
2018-10-04 09:00:00	IWM	ETF	165.45	165.65	164.84	165.05	1740249.0
2018-10-04 10:00:00	IWM	ETF	165.055	165.115	164.51	164.68	2943467.0
2018-10-04 11:00:00	IWM	ETF	164.68	165.05	164.29	164.31	2087322.0
2018-10-04 12:00:00	IWM	ETF	164.3	164.33	163.13	163.56	3981218.0
2018-10-04 13:00:00	IWM	ETF	163.56	163.79	163.3464	163.74	2178891.0
2018-10-04 14:00:00	IWM	ETF	163.74	163.9185	163.25	163.85	2261167.0
2018-10-04 15:00:00	IWM	ETF	163.86	163.96	163.205	163.68	4273842.0
2018-10-04 16:00:00	IWM	ETF	163.68	163.97	163.56	163.97	2034517.0
2018-10-04 17:00:00	IWM	ETF	163.78	166.0234	163.78	163.9499	650747.0
2018-10-04 18:00:00	IWM	ETF	163.91	163.95	163.64	163.86	13003.0
2018-10-04 19:00:00	IWM	ETF	163.84	163.96	163.81	163.96	4600.0
2018-10-04 04:00:00	DIA	ETF	267.29	267.29	267.07	267.07	2720.0
2018-10-04 06:00:00	DIA	ETF	267.51	267.51	267.51	267.51	100.0

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

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