PREVIEW / etf_1hour / 2020-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-24.parquet
  size:    362 KB
  rows:    12,161

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-04-24 04:00:00	SPY	ETF	278.25	278.27	277.18	277.86	61271.0
2020-04-24 05:00:00	SPY	ETF	277.95	279.96	277.95	279.58	226539.0
2020-04-24 06:00:00	SPY	ETF	279.64	280.85	279.32	280.85	203514.0
2020-04-24 07:00:00	SPY	ETF	280.8	280.98	279.83	279.95	419057.0
2020-04-24 08:00:00	SPY	ETF	280.9399	281.43	276.13	280.7	1090248.0
2020-04-24 09:00:00	SPY	ETF	280.72	281.29	278.77	278.86	7243955.0
2020-04-24 10:00:00	SPY	ETF	278.89	280.91	278.81	279.59	8852541.0
2020-04-24 11:00:00	SPY	ETF	279.59	279.73	278.5	279.3501	12253926.0
2020-04-24 12:00:00	SPY	ETF	279.35	280.52	279.06	280.22	6666981.0
2020-04-24 13:00:00	SPY	ETF	280.2127	281.56	279.78	281.52	7088932.0
2020-04-24 14:00:00	SPY	ETF	281.51	282.52	281.24	282.21	9612033.0
2020-04-24 15:00:00	SPY	ETF	282.21	283.7	281.81	283.04	21532933.0
2020-04-24 16:00:00	SPY	ETF	283.05	283.35	282.77	283.0	8654504.0
2020-04-24 17:00:00	SPY	ETF	283.01	283.25	282.82	283.25	349409.0
2020-04-24 18:00:00	SPY	ETF	283.2499	283.2499	282.97	283.12	51583.0
2020-04-24 19:00:00	SPY	ETF	283.15	283.35	283.0	283.35	66302.0
2020-04-24 04:00:00	QQQ	ETF	209.5	209.5	208.55	208.98	162121.0
2020-04-24 05:00:00	QQQ	ETF	209.27	210.72	209.24	210.45	50057.0
2020-04-24 06:00:00	QQQ	ETF	210.4	211.42	210.22	211.42	33685.0
2020-04-24 07:00:00	QQQ	ETF	211.4	211.43	210.62	210.74	187473.0
2020-04-24 08:00:00	QQQ	ETF	211.09	211.68	208.0	211.25	262195.0
2020-04-24 09:00:00	QQQ	ETF	211.23	211.53	209.5	209.61	4231098.0
2020-04-24 10:00:00	QQQ	ETF	209.61	211.6	209.61	210.83	5336931.0
2020-04-24 11:00:00	QQQ	ETF	210.8	211.3	210.13	211.07	3472961.0
2020-04-24 12:00:00	QQQ	ETF	211.052	212.17	210.75	211.925	3230236.0
2020-04-24 13:00:00	QQQ	ETF	211.95	212.82	211.53	212.78	2616627.0
2020-04-24 14:00:00	QQQ	ETF	212.7701	213.4296	212.62	213.1658	3683601.0
2020-04-24 15:00:00	QQQ	ETF	213.16	214.3	212.84	214.06	6024591.0
2020-04-24 16:00:00	QQQ	ETF	214.05	214.21	213.83	213.9	1096808.0
2020-04-24 17:00:00	QQQ	ETF	214.07	214.16	213.84	214.06	38845.0
2020-04-24 18:00:00	QQQ	ETF	213.97	214.15	213.97	214.13	16833.0
2020-04-24 19:00:00	QQQ	ETF	214.14	214.5	214.02	214.4	51434.0
2020-04-24 04:00:00	IWM	ETF	119.9	119.9	119.52	119.89	4605.0
2020-04-24 05:00:00	IWM	ETF	120.19	121.0	120.19	121.0	7405.0
2020-04-24 06:00:00	IWM	ETF	120.69	121.3	120.69	121.3	86448.0
2020-04-24 07:00:00	IWM	ETF	121.34	121.35	120.75	120.77	59213.0
2020-04-24 08:00:00	IWM	ETF	121.07	121.42	119.1	121.18	107582.0
2020-04-24 09:00:00	IWM	ETF	120.2	122.0	119.26	120.36	3630393.0
2020-04-24 10:00:00	IWM	ETF	120.38	121.27	120.18	120.76	3274320.0
2020-04-24 11:00:00	IWM	ETF	120.76	120.89	120.09	120.74	2708405.0
2020-04-24 12:00:00	IWM	ETF	120.74	121.23	120.56	121.07	1532976.0
2020-04-24 13:00:00	IWM	ETF	121.06	122.2014	120.96	122.19	1825265.0
2020-04-24 14:00:00	IWM	ETF	122.19	122.61	121.94	122.49	2453883.0
2020-04-24 15:00:00	IWM	ETF	122.485	123.32	122.34	122.54	7161147.0
2020-04-24 16:00:00	IWM	ETF	122.54	122.64	122.0	122.1	1066622.0
2020-04-24 17:00:00	IWM	ETF	122.17	122.4	122.1599	122.38	7986.0
2020-04-24 18:00:00	IWM	ETF	122.4	122.4	122.25	122.4	2642.0
2020-04-24 19:00:00	IWM	ETF	122.38	122.4	122.25	122.25	5347.0
2020-04-24 04:00:00	DIA	ETF	234.2	234.2	234.2	234.2	100.0
2020-04-24 05:00:00	DIA	ETF	234.56	235.29	234.56	235.23	500.0

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

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