PREVIEW / etf_1hour / 2019-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-26.parquet
  size:    341 KB
  rows:    11,162

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-08-26 04:00:00	SPY	ETF	286.7	288.08	286.37	287.91	79985.0
2019-08-26 05:00:00	SPY	ETF	287.98	288.73	286.54	286.9	155676.0
2019-08-26 06:00:00	SPY	ETF	287.02	287.5	286.66	287.01	215351.0
2019-08-26 07:00:00	SPY	ETF	286.93	287.87	286.71	287.1	667160.0
2019-08-26 08:00:00	SPY	ETF	287.05	288.07	283.01	287.73	1588315.0
2019-08-26 09:00:00	SPY	ETF	287.74	287.8	286.19	286.88	9910176.0
2019-08-26 10:00:00	SPY	ETF	286.86	286.96	285.58	286.44	11261682.0
2019-08-26 11:00:00	SPY	ETF	286.42	287.46	286.29	286.92	8356871.0
2019-08-26 12:00:00	SPY	ETF	286.91	287.91	286.78	287.47	4875754.0
2019-08-26 13:00:00	SPY	ETF	287.47	287.84	286.95	287.13	3360054.0
2019-08-26 14:00:00	SPY	ETF	287.13	287.16	286.46	286.92	8581575.0
2019-08-26 15:00:00	SPY	ETF	286.92	287.99	286.7	287.97	12591353.0
2019-08-26 16:00:00	SPY	ETF	287.98	288.41	284.7553	288.23	8877509.0
2019-08-26 17:00:00	SPY	ETF	288.22	288.32	288.22	288.28	107291.0
2019-08-26 18:00:00	SPY	ETF	288.3	288.45	288.09	288.13	115998.0
2019-08-26 19:00:00	SPY	ETF	288.16	288.16	287.66	287.72	131849.0
2019-08-26 04:00:00	QQQ	ETF	184.1	185.27	183.8	185.13	81668.0
2019-08-26 05:00:00	QQQ	ETF	185.19	185.83	183.99	184.38	147357.0
2019-08-26 06:00:00	QQQ	ETF	184.47	185.02	184.1	184.44	150612.0
2019-08-26 07:00:00	QQQ	ETF	184.28	184.81	184.15	184.25	392729.0
2019-08-26 08:00:00	QQQ	ETF	184.21	185.0	181.67	184.52	837293.0
2019-08-26 09:00:00	QQQ	ETF	184.49	184.53	183.44	183.97	4639899.0
2019-08-26 10:00:00	QQQ	ETF	183.97	184.22	183.08	183.78	3936511.0
2019-08-26 11:00:00	QQQ	ETF	183.77	184.49	183.66	184.04	3260419.0
2019-08-26 12:00:00	QQQ	ETF	184.05	184.8297	183.93	184.47	1870472.0
2019-08-26 13:00:00	QQQ	ETF	184.48	184.66	184.11	184.23	1135811.0
2019-08-26 14:00:00	QQQ	ETF	184.26	184.27	183.8	184.18	1548437.0
2019-08-26 15:00:00	QQQ	ETF	184.16	184.87	183.95	184.84	4567508.0
2019-08-26 16:00:00	QQQ	ETF	184.83	185.23	183.8653	184.99	1495807.0
2019-08-26 17:00:00	QQQ	ETF	185.08	185.09	184.97	185.03	20894.0
2019-08-26 18:00:00	QQQ	ETF	185.05	185.16	184.85	184.9	35000.0
2019-08-26 19:00:00	QQQ	ETF	184.88	184.88	184.57	184.63	74888.0
2019-08-26 04:00:00	IWM	ETF	146.44	147.23	146.43	147.22	12421.0
2019-08-26 05:00:00	IWM	ETF	147.12	147.7	146.68	146.72	8389.0
2019-08-26 06:00:00	IWM	ETF	146.72	146.95	146.71	146.87	25831.0
2019-08-26 07:00:00	IWM	ETF	146.77	147.26	145.39	146.76	106596.0
2019-08-26 08:00:00	IWM	ETF	146.91	147.35	144.78	147.21	102231.0
2019-08-26 09:00:00	IWM	ETF	147.22	147.22	145.73	146.13	3550551.0
2019-08-26 10:00:00	IWM	ETF	146.13	146.28	145.71	145.96	2706333.0
2019-08-26 11:00:00	IWM	ETF	145.96	146.52	145.9	146.44	2071529.0
2019-08-26 12:00:00	IWM	ETF	146.445	146.83	146.25	146.77	1088929.0
2019-08-26 13:00:00	IWM	ETF	146.78	146.98	146.64	146.727	1598691.0
2019-08-26 14:00:00	IWM	ETF	146.73	146.75	146.41	146.63	1246974.0
2019-08-26 15:00:00	IWM	ETF	146.62	147.05	146.51	147.03	2602373.0
2019-08-26 16:00:00	IWM	ETF	147.03	147.44	147.02	147.37	2120454.0
2019-08-26 17:00:00	IWM	ETF	147.39	147.39	147.27	147.35	6350.0
2019-08-26 18:00:00	IWM	ETF	147.38	147.46	147.27	147.27	10033.0
2019-08-26 19:00:00	IWM	ETF	147.27	147.27	147.06	147.06	14211.0
2019-08-26 04:00:00	DIA	ETF	258.24	259.18	258.24	259.14	3546.0
2019-08-26 05:00:00	DIA	ETF	259.08	259.62	258.14	258.14	3382.0

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

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