PREVIEW / etf_1hour / 2020-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-26.parquet
  size:    375 KB
  rows:    12,993

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-05-26 04:00:00	SPY	ETF	300.51	301.48	300.51	301.4	145198.0
2020-05-26 05:00:00	SPY	ETF	301.4	301.79	301.24	301.3	87748.0
2020-05-26 06:00:00	SPY	ETF	301.33	301.55	301.0	301.15	196049.0
2020-05-26 07:00:00	SPY	ETF	301.11	301.36	300.75	301.03	547666.0
2020-05-26 08:00:00	SPY	ETF	301.03	301.8	300.11	301.7804	891999.0
2020-05-26 09:00:00	SPY	ETF	301.79	302.26	300.66	300.84	10884305.0
2020-05-26 10:00:00	SPY	ETF	300.83	301.54	300.37	301.3	12454585.0
2020-05-26 11:00:00	SPY	ETF	301.29	301.58	299.9	300.4117	11405818.0
2020-05-26 12:00:00	SPY	ETF	300.42	301.08	300.08	301.03	7926257.0
2020-05-26 13:00:00	SPY	ETF	301.035	301.47	300.8894	301.1101	7653159.0
2020-05-26 14:00:00	SPY	ETF	301.14	301.45	300.74	301.04	5407363.0
2020-05-26 15:00:00	SPY	ETF	301.035	301.08	298.69	299.15	25405428.0
2020-05-26 16:00:00	SPY	ETF	299.14	299.97	298.9666	299.8	4878043.0
2020-05-26 17:00:00	SPY	ETF	299.75	299.85	299.62	299.77	100191.0
2020-05-26 18:00:00	SPY	ETF	299.73	299.73	299.08	299.65	234688.0
2020-05-26 19:00:00	SPY	ETF	299.64	299.73	299.16	299.39	109856.0
2020-05-26 04:00:00	QQQ	ETF	233.35	234.14	233.35	233.98	48138.0
2020-05-26 05:00:00	QQQ	ETF	233.97	234.31	233.79	233.79	22684.0
2020-05-26 06:00:00	QQQ	ETF	233.88	234.02	233.56	233.64	172708.0
2020-05-26 07:00:00	QQQ	ETF	233.62	233.63	233.15	233.24	210559.0
2020-05-26 08:00:00	QQQ	ETF	230.63	234.2	230.63	233.13	333976.0
2020-05-26 09:00:00	QQQ	ETF	233.07	233.57	231.45	231.83	4547031.0
2020-05-26 10:00:00	QQQ	ETF	231.81	232.49	231.355	231.911	4100313.0
2020-05-26 11:00:00	QQQ	ETF	231.94	232.17	229.74	230.51	4840404.0
2020-05-26 12:00:00	QQQ	ETF	230.54	231.31	230.42	231.14	2893458.0
2020-05-26 13:00:00	QQQ	ETF	231.155	231.5361	230.71	231.06	1940705.0
2020-05-26 14:00:00	QQQ	ETF	231.07	231.1742	230.37	230.62	2352649.0
2020-05-26 15:00:00	QQQ	ETF	230.61	230.64	228.79	229.14	7607785.0
2020-05-26 16:00:00	QQQ	ETF	229.14	229.75	229.04	229.75	1063743.0
2020-05-26 17:00:00	QQQ	ETF	229.8	229.82	229.6	229.8	38019.0
2020-05-26 18:00:00	QQQ	ETF	229.8	229.81	229.27	229.67	134521.0
2020-05-26 19:00:00	QQQ	ETF	229.66	229.71	229.2	229.33	69604.0
2020-05-26 04:00:00	IWM	ETF	138.34	139.05	138.31	139.05	36722.0
2020-05-26 05:00:00	IWM	ETF	139.1	139.4	138.79	138.9	23127.0
2020-05-26 06:00:00	IWM	ETF	138.82	139.18	138.55	138.77	90934.0
2020-05-26 07:00:00	IWM	ETF	138.67	139.51	138.41	139.2	162558.0
2020-05-26 08:00:00	IWM	ETF	138.74	139.99	138.27	139.99	184723.0
2020-05-26 09:00:00	IWM	ETF	139.97	140.52	139.17	139.715	6765724.0
2020-05-26 10:00:00	IWM	ETF	139.73	140.375	139.23	139.77	4316421.0
2020-05-26 11:00:00	IWM	ETF	139.77	140.09	138.79	139.235	4490719.0
2020-05-26 12:00:00	IWM	ETF	139.245	139.9	138.77	139.8	2750979.0
2020-05-26 13:00:00	IWM	ETF	139.815	140.1074	139.685	139.73	1565757.0
2020-05-26 14:00:00	IWM	ETF	139.73	139.87	139.3	139.73	1936888.0
2020-05-26 15:00:00	IWM	ETF	139.72	139.78	138.465	138.71	7012353.0
2020-05-26 16:00:00	IWM	ETF	138.73	139.2	138.67	138.78	1483242.0
2020-05-26 17:00:00	IWM	ETF	138.97	139.16	138.88	139.16	33384.0
2020-05-26 18:00:00	IWM	ETF	139.1	139.19	138.68	139.03	124306.0
2020-05-26 19:00:00	IWM	ETF	139.04	139.15	138.78	138.92	43320.0
2020-05-26 04:00:00	DIA	ETF	248.52	250.22	247.96	250.22	4294.0
2020-05-26 05:00:00	DIA	ETF	250.3	250.61	250.05	250.05	900.0

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

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