PREVIEW / etf_1hour / 2021-02-16

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-16.parquet
  size:    445 KB
  rows:    15,511

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
2021-02-16 04:00:00	SPY	ETF	394.4	394.79	394.22	394.65	34938.0
2021-02-16 05:00:00	SPY	ETF	394.65	394.77	394.51	394.67	15602.0
2021-02-16 06:00:00	SPY	ETF	394.67	395.0	394.33	394.97	114826.0
2021-02-16 07:00:00	SPY	ETF	394.96	395.05	394.68	394.7	201680.0
2021-02-16 08:00:00	SPY	ETF	394.7	395.35	393.9	394.0	365230.0
2021-02-16 09:00:00	SPY	ETF	393.96	394.17	393.255	393.6799	4522914.0
2021-02-16 10:00:00	SPY	ETF	393.72	394.16	392.4	393.22	7009001.0
2021-02-16 11:00:00	SPY	ETF	393.21	393.37	391.91	392.07	4966890.0
2021-02-16 12:00:00	SPY	ETF	392.06	392.95	391.53	392.875	4542155.0
2021-02-16 13:00:00	SPY	ETF	392.89	393.2	392.47	392.5	2850681.0
2021-02-16 14:00:00	SPY	ETF	392.51	393.29	392.47	392.8301	3264833.0
2021-02-16 15:00:00	SPY	ETF	392.8319	393.0	392.01	392.34	8546064.0
2021-02-16 16:00:00	SPY	ETF	392.35	392.61	392.1	392.54	4100620.0
2021-02-16 17:00:00	SPY	ETF	392.5	392.6	392.36	392.46	106337.0
2021-02-16 18:00:00	SPY	ETF	392.5	392.72	391.66	391.73	258510.0
2021-02-16 19:00:00	SPY	ETF	391.71	391.72	391.25	391.47	105113.0
2021-02-16 04:00:00	QQQ	ETF	337.64	337.94	337.64	337.85	35469.0
2021-02-16 05:00:00	QQQ	ETF	337.88	338.11	337.83	338.06	20251.0
2021-02-16 06:00:00	QQQ	ETF	338.01	338.29	337.77	338.25	32141.0
2021-02-16 07:00:00	QQQ	ETF	338.2	338.35	338.06	338.32	99069.0
2021-02-16 08:00:00	QQQ	ETF	338.3	338.85	337.58	337.65	477186.0
2021-02-16 09:00:00	QQQ	ETF	337.62	338.03	336.66	337.64	3234513.0
2021-02-16 10:00:00	QQQ	ETF	337.67	338.19	336.7	337.1899	3393592.0
2021-02-16 11:00:00	QQQ	ETF	337.17	337.29	335.02	335.1694	3348014.0
2021-02-16 12:00:00	QQQ	ETF	335.14	336.18	334.34	336.122	2646596.0
2021-02-16 13:00:00	QQQ	ETF	336.11	336.42	335.24	335.2729	1399056.0
2021-02-16 14:00:00	QQQ	ETF	335.28	336.32	335.28	335.76	1365861.0
2021-02-16 15:00:00	QQQ	ETF	335.75	336.05	335.07	335.51	3126008.0
2021-02-16 16:00:00	QQQ	ETF	335.52	335.65	335.0	335.27	899460.0
2021-02-16 17:00:00	QQQ	ETF	335.27	335.35	335.12	335.24	27532.0
2021-02-16 18:00:00	QQQ	ETF	335.34	335.53	334.61	334.76	115712.0
2021-02-16 19:00:00	QQQ	ETF	334.74	334.74	334.12	334.37	132222.0
2021-02-16 04:00:00	IWM	ETF	229.11	229.54	229.11	229.5	22958.0
2021-02-16 05:00:00	IWM	ETF	229.5	229.66	229.49	229.59	6100.0
2021-02-16 06:00:00	IWM	ETF	229.61	229.66	229.13	229.48	71687.0
2021-02-16 07:00:00	IWM	ETF	229.44	229.57	229.24	229.24	92283.0
2021-02-16 08:00:00	IWM	ETF	229.37	229.54	228.81	228.81	183852.0
2021-02-16 09:00:00	IWM	ETF	228.84	229.63	227.59	227.625	2664767.0
2021-02-16 10:00:00	IWM	ETF	227.63	228.9	226.7	227.59	2628636.0
2021-02-16 11:00:00	IWM	ETF	227.56	227.64	225.81	225.87	2071103.0
2021-02-16 12:00:00	IWM	ETF	225.87	226.49	224.79	225.805	2816215.0
2021-02-16 13:00:00	IWM	ETF	225.82	226.43	225.38	225.58	1659429.0
2021-02-16 14:00:00	IWM	ETF	225.5925	226.34	225.55	226.23	1093825.0
2021-02-16 15:00:00	IWM	ETF	226.24	226.55	225.585	225.78	3133084.0
2021-02-16 16:00:00	IWM	ETF	225.79	227.3505	225.37	225.73	1677475.0
2021-02-16 17:00:00	IWM	ETF	225.79	225.85	225.7	225.76	19120.0
2021-02-16 18:00:00	IWM	ETF	225.75	225.95	225.15	225.29	39949.0
2021-02-16 19:00:00	IWM	ETF	225.15	225.15	224.42	224.61	36272.0
2021-02-16 04:00:00	DIA	ETF	317.17	317.17	316.85	316.96	3700.0
2021-02-16 05:00:00	DIA	ETF	317.05	317.05	317.05	317.05	5455.0

> showing 50 of 15,511 rows — these rows as CSV

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