PREVIEW / etf_1hour / 2021-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-02.parquet
  size:    403 KB
  rows:    14,364

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-06-02 04:00:00	SPY	ETF	419.35	419.68	419.09	419.15	12088.0
2021-06-02 05:00:00	SPY	ETF	419.2	419.72	419.2	419.72	7138.0
2021-06-02 06:00:00	SPY	ETF	419.58	419.8	419.52	419.78	22567.0
2021-06-02 07:00:00	SPY	ETF	419.79	419.92	419.49	419.79	68722.0
2021-06-02 08:00:00	SPY	ETF	419.9099	420.47	419.57	420.455	132338.0
2021-06-02 09:00:00	SPY	ETF	420.46	420.68	419.55	420.41	4044609.0
2021-06-02 10:00:00	SPY	ETF	420.4	420.98	420.24	420.6952	4927446.0
2021-06-02 11:00:00	SPY	ETF	420.71	421.23	420.5	420.8435	3213611.0
2021-06-02 12:00:00	SPY	ETF	420.85	420.91	420.13	420.435	2509431.0
2021-06-02 13:00:00	SPY	ETF	420.435	420.53	419.57	419.79	3602711.0
2021-06-02 14:00:00	SPY	ETF	419.785	420.04	419.29	419.9	3532475.0
2021-06-02 15:00:00	SPY	ETF	419.89	420.47	419.58	420.3601	10446119.0
2021-06-02 16:00:00	SPY	ETF	420.36	420.44	419.9	420.38	2899708.0
2021-06-02 17:00:00	SPY	ETF	420.39	420.48	420.3	420.48	85025.0
2021-06-02 18:00:00	SPY	ETF	420.49	420.55	420.33	420.42	87789.0
2021-06-02 19:00:00	SPY	ETF	420.38	420.63	420.35	420.63	39045.0
2021-06-02 04:00:00	QQQ	ETF	332.39	332.6	332.15	332.26	8203.0
2021-06-02 05:00:00	QQQ	ETF	332.26	332.57	332.11	332.56	15482.0
2021-06-02 06:00:00	QQQ	ETF	332.52	332.73	332.34	332.73	15841.0
2021-06-02 07:00:00	QQQ	ETF	332.72	333.0	332.59	332.9	81848.0
2021-06-02 08:00:00	QQQ	ETF	332.7004	333.38	332.3504	333.31	128396.0
2021-06-02 09:00:00	QQQ	ETF	333.33	334.24	332.8601	333.53	2995422.0
2021-06-02 10:00:00	QQQ	ETF	333.53	334.34	333.02	333.66	3242035.0
2021-06-02 11:00:00	QQQ	ETF	333.66	334.185	333.47	333.945	1969204.0
2021-06-02 12:00:00	QQQ	ETF	333.96	334.01	332.97	333.2999	1836965.0
2021-06-02 13:00:00	QQQ	ETF	333.3	333.45	331.9499	332.29	3011675.0
2021-06-02 14:00:00	QQQ	ETF	332.27	332.6	331.695	332.515	2170040.0
2021-06-02 15:00:00	QQQ	ETF	332.51	333.51	332.25	333.42	2541606.0
2021-06-02 16:00:00	QQQ	ETF	333.44	333.55	333.15	333.48	758514.0
2021-06-02 17:00:00	QQQ	ETF	333.54	333.55	333.38	333.41	13881.0
2021-06-02 18:00:00	QQQ	ETF	333.5	333.71	333.48	333.569	63298.0
2021-06-02 19:00:00	QQQ	ETF	333.52	333.78	333.43	333.7	34212.0
2021-06-02 04:00:00	IWM	ETF	228.41	228.41	228.02	228.12	5324.0
2021-06-02 05:00:00	IWM	ETF	228.21	228.21	228.17	228.2	600.0
2021-06-02 06:00:00	IWM	ETF	228.2	228.2	228.2	228.2	100.0
2021-06-02 07:00:00	IWM	ETF	228.26	228.3	227.85	228.1	37100.0
2021-06-02 08:00:00	IWM	ETF	228.26	229.01	228.06	228.97	98161.0
2021-06-02 09:00:00	IWM	ETF	228.98	229.14	226.85	227.06	3617767.0
2021-06-02 10:00:00	IWM	ETF	227.09	227.93	226.825	227.6281	1654748.0
2021-06-02 11:00:00	IWM	ETF	227.62	227.87	227.32	227.65	1604175.0
2021-06-02 12:00:00	IWM	ETF	227.645	228.16	227.26	228.13	1738728.0
2021-06-02 13:00:00	IWM	ETF	228.14	228.7	227.35	227.6901	2064969.0
2021-06-02 14:00:00	IWM	ETF	227.7	227.99	227.02	227.89	1403908.0
2021-06-02 15:00:00	IWM	ETF	227.87	228.52	227.56	228.36	2592783.0
2021-06-02 16:00:00	IWM	ETF	228.33	228.59	228.06	228.58	682027.0
2021-06-02 17:00:00	IWM	ETF	228.59	228.63	228.27	228.35	11405.0
2021-06-02 18:00:00	IWM	ETF	228.53	228.58	228.33	228.41	13161.0
2021-06-02 19:00:00	IWM	ETF	228.36	228.54	228.33	228.52	6636.0
2021-06-02 04:00:00	DIA	ETF	345.9	346.11	345.9	346.11	300.0
2021-06-02 05:00:00	DIA	ETF	346.08	346.08	346.08	346.08	200.0

> showing 50 of 14,364 rows — these rows as CSV

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