PREVIEW / etf_1hour / 2020-02-28

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-28.parquet
  size:    422 KB
  rows:    14,267

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
2020-02-28 04:00:00	SPY	ETF	291.67	291.91	288.1	290.64	415743.0
2020-02-28 05:00:00	SPY	ETF	290.5	293.66	290.05	293.45	278656.0
2020-02-28 06:00:00	SPY	ETF	293.4	294.13	292.39	292.55	489786.0
2020-02-28 07:00:00	SPY	ETF	292.65	295.4	291.9	294.33	1583538.0
2020-02-28 08:00:00	SPY	ETF	294.35	297.51	290.0	290.13	2982784.0
2020-02-28 09:00:00	SPY	ETF	290.1	293.2	286.7	287.57	46885367.0
2020-02-28 10:00:00	SPY	ETF	287.56	290.54	285.54	289.95	57234381.0
2020-02-28 11:00:00	SPY	ETF	289.96	297.892	287.5	291.74	48963400.0
2020-02-28 12:00:00	SPY	ETF	291.75	294.77	290.0	294.55	32895220.0
2020-02-28 13:00:00	SPY	ETF	294.54	295.1	288.82	290.235	36941287.0
2020-02-28 14:00:00	SPY	ETF	290.23	294.25	288.03	291.65	42862638.0
2020-02-28 15:00:00	SPY	ETF	291.69	296.33	288.06	296.16	69630845.0
2020-02-28 16:00:00	SPY	ETF	296.12	299.7	295.4314	299.04	34625076.0
2020-02-28 17:00:00	SPY	ETF	298.95	299.1	296.26	298.76	1524008.0
2020-02-28 18:00:00	SPY	ETF	298.84	299.35	296.26	298.9	759437.0
2020-02-28 19:00:00	SPY	ETF	298.95	299.1	298.74	298.85	82718.0
2020-02-28 04:00:00	QQQ	ETF	201.36	201.47	198.24	200.3	377186.0
2020-02-28 05:00:00	QQQ	ETF	200.2	202.58	199.95	202.36	172426.0
2020-02-28 06:00:00	QQQ	ETF	202.38	203.33	202.16	202.47	252578.0
2020-02-28 07:00:00	QQQ	ETF	202.43	204.43	201.79	203.34	826041.0
2020-02-28 08:00:00	QQQ	ETF	203.3	205.64	199.21	200.0599	1445763.0
2020-02-28 09:00:00	QQQ	ETF	200.02	202.92	198.17	199.56	20220627.0
2020-02-28 10:00:00	QQQ	ETF	199.54	202.26	198.39	202.07	20732084.0
2020-02-28 11:00:00	QQQ	ETF	202.09	207.17	200.01	203.67	17596949.0
2020-02-28 12:00:00	QQQ	ETF	203.67	205.52	202.27	205.3	11180529.0
2020-02-28 13:00:00	QQQ	ETF	205.28	205.865	200.85	201.84	11509804.0
2020-02-28 14:00:00	QQQ	ETF	201.83	205.03	200.36	203.01	13000585.0
2020-02-28 15:00:00	QQQ	ETF	203.0	206.81	200.93	206.67	18680951.0
2020-02-28 16:00:00	QQQ	ETF	206.65	209.05	205.8	208.38	5682317.0
2020-02-28 17:00:00	QQQ	ETF	208.3	208.75	205.8	208.12	660133.0
2020-02-28 18:00:00	QQQ	ETF	208.24	208.48	207.81	208.0	55261.0
2020-02-28 19:00:00	QQQ	ETF	208.09	208.25	207.88	207.88	46675.0
2020-02-28 04:00:00	IWM	ETF	146.07	146.44	144.69	146.05	31665.0
2020-02-28 05:00:00	IWM	ETF	146.09	147.41	145.88	147.32	24663.0
2020-02-28 06:00:00	IWM	ETF	147.24	147.7	146.91	146.99	9286.0
2020-02-28 07:00:00	IWM	ETF	146.79	148.15	146.65	147.65	71927.0
2020-02-28 08:00:00	IWM	ETF	146.86	147.9	145.38	145.39	219993.0
2020-02-28 09:00:00	IWM	ETF	145.34	147.84	144.34	145.13	9234863.0
2020-02-28 10:00:00	IWM	ETF	145.13	146.2	144.27	145.53	10521548.0
2020-02-28 11:00:00	IWM	ETF	145.55	147.98	144.55	146.38	5359433.0
2020-02-28 12:00:00	IWM	ETF	146.39	147.5	145.62	147.41	3495690.0
2020-02-28 13:00:00	IWM	ETF	147.45	147.56	144.81	145.19	4050890.0
2020-02-28 14:00:00	IWM	ETF	145.17	146.5198	144.34	145.49	6469499.0
2020-02-28 15:00:00	IWM	ETF	145.51	147.34	143.91	147.21	11154481.0
2020-02-28 16:00:00	IWM	ETF	147.25	149.31	144.17	148.78	2606199.0
2020-02-28 17:00:00	IWM	ETF	148.71	148.83	146.33	146.33	204519.0
2020-02-28 18:00:00	IWM	ETF	148.79	149.0	146.33	148.7	711112.0
2020-02-28 19:00:00	IWM	ETF	148.61	149.1	148.61	149.1	9450.0
2020-02-28 04:00:00	DIA	ETF	251.88	252.39	249.34	251.25	23788.0
2020-02-28 05:00:00	DIA	ETF	251.35	253.6	251.24	252.8	26949.0

> showing 50 of 14,267 rows — these rows as CSV

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