PREVIEW / etf_1hour / 2020-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-09.parquet
  size:    391 KB
  rows:    13,337

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-09 04:00:00	SPY	ETF	276.56	277.06	273.84	273.84	170659.0
2020-04-09 05:00:00	SPY	ETF	273.81	274.33	272.87	273.19	126242.0
2020-04-09 06:00:00	SPY	ETF	272.96	273.76	271.76	272.76	186133.0
2020-04-09 07:00:00	SPY	ETF	272.8	274.01	271.15	271.86	1109661.0
2020-04-09 08:00:00	SPY	ETF	274.0	277.26	270.4	276.94	6095355.0
2020-04-09 09:00:00	SPY	ETF	276.93	280.61	276.57	280.51	26786458.0
2020-04-09 10:00:00	SPY	ETF	280.51	280.58	277.06	279.36	34119983.0
2020-04-09 11:00:00	SPY	ETF	279.35	279.77	277.12	279.43	17154290.0
2020-04-09 12:00:00	SPY	ETF	279.44	280.96	279.12	280.591	16073899.0
2020-04-09 13:00:00	SPY	ETF	280.6	281.2	278.88	279.89	17882125.0
2020-04-09 14:00:00	SPY	ETF	279.87	279.98	275.47	276.585	24420377.0
2020-04-09 15:00:00	SPY	ETF	276.58	278.935	276.0	278.24	31369404.0
2020-04-09 16:00:00	SPY	ETF	278.25	279.35	277.7311	279.03	12955377.0
2020-04-09 17:00:00	SPY	ETF	279.03	279.03	278.2	278.8	759297.0
2020-04-09 18:00:00	SPY	ETF	278.83	279.29	278.2	278.82	214062.0
2020-04-09 19:00:00	SPY	ETF	278.8	279.19	278.8	279.0	115982.0
2020-04-09 04:00:00	QQQ	ETF	201.62	201.7	199.71	199.9	147334.0
2020-04-09 05:00:00	QQQ	ETF	199.77	200.14	199.07	199.29	96072.0
2020-04-09 06:00:00	QQQ	ETF	199.12	199.64	198.52	199.25	81772.0
2020-04-09 07:00:00	QQQ	ETF	199.29	200.05	198.24	198.72	256177.0
2020-04-09 08:00:00	QQQ	ETF	199.46	201.97	197.85	201.79	1116439.0
2020-04-09 09:00:00	QQQ	ETF	201.79	203.22	201.07	202.8	7846919.0
2020-04-09 10:00:00	QQQ	ETF	202.79	202.81	199.11	200.84	13389300.0
2020-04-09 11:00:00	QQQ	ETF	200.84	201.44	199.31	201.1615	7064059.0
2020-04-09 12:00:00	QQQ	ETF	201.18	202.16	200.71	201.94	4107942.0
2020-04-09 13:00:00	QQQ	ETF	201.93	202.19	200.9102	201.38	3921763.0
2020-04-09 14:00:00	QQQ	ETF	201.38	201.45	199.0281	199.68	5579596.0
2020-04-09 15:00:00	QQQ	ETF	199.67	200.89	199.28	200.81	8919589.0
2020-04-09 16:00:00	QQQ	ETF	200.81	201.32	200.54	201.15	1196611.0
2020-04-09 17:00:00	QQQ	ETF	201.1	201.2	200.88	201.1	41733.0
2020-04-09 18:00:00	QQQ	ETF	201.07	201.22	201.0	201.18	29953.0
2020-04-09 19:00:00	QQQ	ETF	201.2	201.44	201.18	201.44	41843.0
2020-04-09 04:00:00	IWM	ETF	119.39	119.49	117.91	117.91	14983.0
2020-04-09 05:00:00	IWM	ETF	117.53	118.08	117.5	117.52	7873.0
2020-04-09 06:00:00	IWM	ETF	117.82	117.82	117.2	117.35	7988.0
2020-04-09 07:00:00	IWM	ETF	117.55	118.01	116.82	117.11	163178.0
2020-04-09 08:00:00	IWM	ETF	117.85	120.51	116.42	120.34	565713.0
2020-04-09 09:00:00	IWM	ETF	120.45	124.61	120.4	124.52	10946554.0
2020-04-09 10:00:00	IWM	ETF	124.515	124.53	121.57	123.12	11468571.0
2020-04-09 11:00:00	IWM	ETF	123.105	123.59	121.85	123.55	6177821.0
2020-04-09 12:00:00	IWM	ETF	123.56	124.17	123.1	123.95	3566398.0
2020-04-09 13:00:00	IWM	ETF	123.955	124.6	123.75	124.17	5739372.0
2020-04-09 14:00:00	IWM	ETF	124.17	124.21	121.325	121.94	7504870.0
2020-04-09 15:00:00	IWM	ETF	121.94	124.25	121.75	123.71	11888632.0
2020-04-09 16:00:00	IWM	ETF	123.72	124.33	123.1623	124.33	2373341.0
2020-04-09 17:00:00	IWM	ETF	124.41	124.62	124.0	124.32	74663.0
2020-04-09 18:00:00	IWM	ETF	124.18	124.41	123.72	124.37	134946.0
2020-04-09 19:00:00	IWM	ETF	124.3	124.5	124.2	124.5	27768.0
2020-04-09 04:00:00	DIA	ETF	236.84	237.12	234.27	234.27	7951.0
2020-04-09 05:00:00	DIA	ETF	234.32	234.62	233.56	233.56	15500.0

> showing 50 of 13,337 rows — these rows as CSV

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