PREVIEW / etf_1hour / 2020-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-01.parquet
  size:    369 KB
  rows:    12,716

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-06-01 04:00:00	SPY	ETF	305.0	305.31	302.45	303.88	1266371.0
2020-06-01 05:00:00	SPY	ETF	303.84	304.21	303.39	303.56	451016.0
2020-06-01 06:00:00	SPY	ETF	303.5	304.37	303.2	304.36	222061.0
2020-06-01 07:00:00	SPY	ETF	304.42	305.05	304.2	304.58	414823.0
2020-06-01 08:00:00	SPY	ETF	304.8899	305.5	303.56	303.84	1834067.0
2020-06-01 09:00:00	SPY	ETF	303.81	304.71	303.06	304.21	8134284.0
2020-06-01 10:00:00	SPY	ETF	304.2065	305.29	303.95	305.07	8577902.0
2020-06-01 11:00:00	SPY	ETF	305.055	305.14	304.25	305.005	5324609.0
2020-06-01 12:00:00	SPY	ETF	304.99	305.67	304.705	305.5	4362588.0
2020-06-01 13:00:00	SPY	ETF	305.5	306.205	305.4733	305.905	4221380.0
2020-06-01 14:00:00	SPY	ETF	305.91	306.04	305.47	305.98	4735135.0
2020-06-01 15:00:00	SPY	ETF	305.99	306.15	305.25	305.58	11215656.0
2020-06-01 16:00:00	SPY	ETF	305.59	305.86	305.1196	305.75	3281664.0
2020-06-01 17:00:00	SPY	ETF	305.68	305.75	305.54	305.54	94903.0
2020-06-01 18:00:00	SPY	ETF	305.54	305.77	304.56	304.9299	512424.0
2020-06-01 19:00:00	SPY	ETF	304.8	304.87	303.88	304.19	570101.0
2020-06-01 04:00:00	QQQ	ETF	233.37	233.52	231.42	232.26	98731.0
2020-06-01 05:00:00	QQQ	ETF	232.21	232.45	231.69	231.89	34329.0
2020-06-01 06:00:00	QQQ	ETF	231.8	232.52	231.69	232.52	61979.0
2020-06-01 07:00:00	QQQ	ETF	232.59	233.07	232.55	232.75	106077.0
2020-06-01 08:00:00	QQQ	ETF	232.86	233.89	231.96	232.4	416653.0
2020-06-01 09:00:00	QQQ	ETF	232.3	233.47	232.0	233.12	4169526.0
2020-06-01 10:00:00	QQQ	ETF	233.13	233.92	232.9	233.63	4140205.0
2020-06-01 11:00:00	QQQ	ETF	233.64	233.72	232.74	233.42	2446565.0
2020-06-01 12:00:00	QQQ	ETF	233.4	234.14	233.11	233.845	2025850.0
2020-06-01 13:00:00	QQQ	ETF	233.85	234.45	233.85	234.161	1697262.0
2020-06-01 14:00:00	QQQ	ETF	234.17	234.28	233.84	234.145	1707811.0
2020-06-01 15:00:00	QQQ	ETF	234.16	234.34	233.71	234.18	3839670.0
2020-06-01 16:00:00	QQQ	ETF	234.18	234.29	233.22	234.17	1042947.0
2020-06-01 17:00:00	QQQ	ETF	234.12	234.14	234.0	234.059	18435.0
2020-06-01 18:00:00	QQQ	ETF	234.07	234.23	233.48	233.74	61888.0
2020-06-01 19:00:00	QQQ	ETF	233.72	233.78	233.25	233.5	304564.0
2020-06-01 04:00:00	IWM	ETF	139.8	139.8	137.8	138.9	48044.0
2020-06-01 05:00:00	IWM	ETF	138.83	139.15	138.67	138.84	13582.0
2020-06-01 06:00:00	IWM	ETF	138.61	139.55	138.6	139.46	39006.0
2020-06-01 07:00:00	IWM	ETF	139.59	139.95	139.32	139.64	101725.0
2020-06-01 08:00:00	IWM	ETF	139.7501	139.94	138.9	139.29	224786.0
2020-06-01 09:00:00	IWM	ETF	139.18	140.07	138.61	139.5383	2551939.0
2020-06-01 10:00:00	IWM	ETF	139.54	141.21	139.46	140.74	4762885.0
2020-06-01 11:00:00	IWM	ETF	140.75	140.97	139.85	140.8783	3481447.0
2020-06-01 12:00:00	IWM	ETF	140.88	141.11	140.56	141.06	1493502.0
2020-06-01 13:00:00	IWM	ETF	141.06	141.67	141.005	141.44	1702092.0
2020-06-01 14:00:00	IWM	ETF	141.44	141.47	140.62	141.05	1702687.0
2020-06-01 15:00:00	IWM	ETF	141.055	141.33	140.08	140.21	4186497.0
2020-06-01 16:00:00	IWM	ETF	140.22	140.23	139.73	140.1	1672571.0
2020-06-01 17:00:00	IWM	ETF	140.01	140.13	139.96	139.96	22182.0
2020-06-01 18:00:00	IWM	ETF	139.95	140.1	139.45	139.56	27636.0
2020-06-01 19:00:00	IWM	ETF	139.55	139.55	138.5	138.68	71701.0
2020-06-01 04:00:00	DIA	ETF	255.45	255.5	253.0	254.11	10584.0
2020-06-01 05:00:00	DIA	ETF	254.18	254.33	253.9	253.9	3079.0

> showing 50 of 12,716 rows — these rows as CSV

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