PREVIEW / etf_1hour / 2019-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-02.parquet
  size:    352 KB
  rows:    11,467

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-10-02 04:00:00	SPY	ETF	292.12	292.12	291.39	291.62	49761.0
2019-10-02 05:00:00	SPY	ETF	291.6	291.78	290.9	291.22	108208.0
2019-10-02 06:00:00	SPY	ETF	291.26	291.36	290.97	291.08	103716.0
2019-10-02 07:00:00	SPY	ETF	291.08	291.8	291.08	291.71	253326.0
2019-10-02 08:00:00	SPY	ETF	291.73	293.9	291.12	291.22	578854.0
2019-10-02 09:00:00	SPY	ETF	291.2002	291.57	289.32	289.7891	12897128.0
2019-10-02 10:00:00	SPY	ETF	289.785	290.04	287.98	288.39	21639073.0
2019-10-02 11:00:00	SPY	ETF	288.4	288.88	287.46	288.22	14544406.0
2019-10-02 12:00:00	SPY	ETF	288.21	288.2539	286.64	286.97	14348179.0
2019-10-02 13:00:00	SPY	ETF	286.97	287.79	286.7506	287.32	9492644.0
2019-10-02 14:00:00	SPY	ETF	287.31	288.56	287.05	288.48	13035913.0
2019-10-02 15:00:00	SPY	ETF	288.48	288.95	287.61	288.04	24183217.0
2019-10-02 16:00:00	SPY	ETF	288.04	288.18	287.16	287.64	10077963.0
2019-10-02 17:00:00	SPY	ETF	287.65	288.06	287.64	287.79	1221564.0
2019-10-02 18:00:00	SPY	ETF	287.79	287.95	287.51	287.92	170878.0
2019-10-02 19:00:00	SPY	ETF	287.94	288.3	287.81	287.88	142038.0
2019-10-02 04:00:00	QQQ	ETF	186.3	186.42	185.9	186.02	115896.0
2019-10-02 05:00:00	QQQ	ETF	185.97	186.21	185.54	185.79	56921.0
2019-10-02 06:00:00	QQQ	ETF	185.81	185.87	185.62	185.72	29500.0
2019-10-02 07:00:00	QQQ	ETF	185.71	186.19	185.71	186.16	101180.0
2019-10-02 08:00:00	QQQ	ETF	186.03	187.42	185.7	185.74	257974.0
2019-10-02 09:00:00	QQQ	ETF	185.75	186.09	184.57	184.925	5493861.0
2019-10-02 10:00:00	QQQ	ETF	184.93	185.2493	183.79	184.15	8263088.0
2019-10-02 11:00:00	QQQ	ETF	184.14	184.47	183.5	183.925	5495499.0
2019-10-02 12:00:00	QQQ	ETF	183.92	183.95	183.02	183.239	3741309.0
2019-10-02 13:00:00	QQQ	ETF	183.23	183.8501	183.085	183.4	4266570.0
2019-10-02 14:00:00	QQQ	ETF	183.39	184.29	183.26	184.21	3953710.0
2019-10-02 15:00:00	QQQ	ETF	184.22	184.63	183.76	184.0	7959797.0
2019-10-02 16:00:00	QQQ	ETF	184.0	184.12	183.41	183.78	2917246.0
2019-10-02 17:00:00	QQQ	ETF	183.75	184.05	183.71	183.8	186788.0
2019-10-02 18:00:00	QQQ	ETF	183.74	183.96	183.63	183.94	41077.0
2019-10-02 19:00:00	QQQ	ETF	183.94	184.19	183.84	183.88	37637.0
2019-10-02 04:00:00	IWM	ETF	147.85	147.86	147.64	147.66	10115.0
2019-10-02 05:00:00	IWM	ETF	147.64	147.64	147.25	147.25	1700.0
2019-10-02 06:00:00	IWM	ETF	147.4	147.4	147.11	147.29	6900.0
2019-10-02 07:00:00	IWM	ETF	147.31	147.6	147.31	147.52	68975.0
2019-10-02 08:00:00	IWM	ETF	147.32	148.73	147.32	147.35	113824.0
2019-10-02 09:00:00	IWM	ETF	147.42	147.63	146.135	146.38	3378855.0
2019-10-02 10:00:00	IWM	ETF	146.38	147.55	146.15	146.83	4510384.0
2019-10-02 11:00:00	IWM	ETF	146.82	147.3	146.39	146.57	2325187.0
2019-10-02 12:00:00	IWM	ETF	146.56	146.61	145.86	146.11	1852242.0
2019-10-02 13:00:00	IWM	ETF	146.1	146.64	145.95	146.29	2167305.0
2019-10-02 14:00:00	IWM	ETF	146.29	147.02	146.14	146.9	1798930.0
2019-10-02 15:00:00	IWM	ETF	146.92	147.27	146.72	147.22	4180765.0
2019-10-02 16:00:00	IWM	ETF	147.22	147.25	146.56	146.94	809298.0
2019-10-02 17:00:00	IWM	ETF	146.97	147.25	146.97	147.07	83492.0
2019-10-02 18:00:00	IWM	ETF	147.01	147.25	146.85	147.05	58157.0
2019-10-02 19:00:00	IWM	ETF	147.11	147.24	146.97	146.97	14100.0
2019-10-02 04:00:00	DIA	ETF	264.75	264.75	264.19	264.19	835.0
2019-10-02 05:00:00	DIA	ETF	264.37	264.37	263.74	263.84	700.0

> showing 50 of 11,467 rows — these rows as CSV

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