PREVIEW / etf_1hour / 2021-02-03

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-03.parquet
  size:    414 KB
  rows:    14,360

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-03 04:00:00	SPY	ETF	383.17	383.3	382.54	382.74	40761.0
2021-02-03 05:00:00	SPY	ETF	382.71	383.23	382.61	383.12	23366.0
2021-02-03 06:00:00	SPY	ETF	383.1	383.2	382.83	383.16	147122.0
2021-02-03 07:00:00	SPY	ETF	383.13	383.18	382.45	382.56	194784.0
2021-02-03 08:00:00	SPY	ETF	382.54	383.5	382.41	382.99	454202.0
2021-02-03 09:00:00	SPY	ETF	382.96	383.05	381.55	382.893	5669963.0
2021-02-03 10:00:00	SPY	ETF	382.91	383.08	380.48	381.65	6925745.0
2021-02-03 11:00:00	SPY	ETF	381.66	382.7699	381.42	382.69	3177464.0
2021-02-03 12:00:00	SPY	ETF	382.69	382.99	382.19	382.88	2540604.0
2021-02-03 13:00:00	SPY	ETF	382.88	383.365	382.64	383.3098	2544086.0
2021-02-03 14:00:00	SPY	ETF	383.3001	383.7	383.02	383.02	4553478.0
2021-02-03 15:00:00	SPY	ETF	383.01	383.195	381.84	381.86	9155772.0
2021-02-03 16:00:00	SPY	ETF	381.87	382.89	381.8	382.83	5294109.0
2021-02-03 17:00:00	SPY	ETF	382.78	383.03	382.76	383.03	188711.0
2021-02-03 18:00:00	SPY	ETF	383.03	383.16	381.85	382.89	201629.0
2021-02-03 19:00:00	SPY	ETF	382.8	383.05	382.25	382.34	220784.0
2021-02-03 04:00:00	QQQ	ETF	330.11	330.33	329.48	329.54	28898.0
2021-02-03 05:00:00	QQQ	ETF	329.52	330.23	329.48	330.15	25254.0
2021-02-03 06:00:00	QQQ	ETF	329.84	330.34	329.84	330.31	31363.0
2021-02-03 07:00:00	QQQ	ETF	330.3	330.31	329.59	329.78	211980.0
2021-02-03 08:00:00	QQQ	ETF	329.9704	330.9	327.68	330.0	363001.0
2021-02-03 09:00:00	QQQ	ETF	330.0104	330.195	328.115	329.67	3872350.0
2021-02-03 10:00:00	QQQ	ETF	329.72	329.83	326.4	327.22	4229112.0
2021-02-03 11:00:00	QQQ	ETF	327.29	328.42	327.0442	328.32	1662032.0
2021-02-03 12:00:00	QQQ	ETF	328.33	328.86	327.965	328.6	1661012.0
2021-02-03 13:00:00	QQQ	ETF	328.61	328.98	328.08	328.77	1360062.0
2021-02-03 14:00:00	QQQ	ETF	328.79	328.889	327.87	327.87	1413923.0
2021-02-03 15:00:00	QQQ	ETF	327.86	328.04	326.32	326.33	3685462.0
2021-02-03 16:00:00	QQQ	ETF	326.34	327.01	326.33	327.0	1194430.0
2021-02-03 17:00:00	QQQ	ETF	327.07	327.5	326.33	327.41	106497.0
2021-02-03 18:00:00	QQQ	ETF	327.56	327.86	327.41	327.65	154537.0
2021-02-03 19:00:00	QQQ	ETF	327.6	327.71	327.03	327.1	89633.0
2021-02-03 04:00:00	IWM	ETF	213.0	213.19	212.62	212.95	21329.0
2021-02-03 05:00:00	IWM	ETF	213.09	213.29	212.9	213.29	2100.0
2021-02-03 06:00:00	IWM	ETF	213.08	213.29	213.07	213.29	15700.0
2021-02-03 07:00:00	IWM	ETF	213.21	213.34	212.91	212.99	142844.0
2021-02-03 08:00:00	IWM	ETF	213.15	213.59	212.9	213.2	140328.0
2021-02-03 09:00:00	IWM	ETF	213.2001	214.74	212.9	213.6	2496143.0
2021-02-03 10:00:00	IWM	ETF	213.595	213.89	211.59	212.06	4200279.0
2021-02-03 11:00:00	IWM	ETF	212.06	212.96	211.64	212.915	2164935.0
2021-02-03 12:00:00	IWM	ETF	212.92	213.4	212.425	213.22	1355700.0
2021-02-03 13:00:00	IWM	ETF	213.22	214.16	213.04	214.075	1350092.0
2021-02-03 14:00:00	IWM	ETF	214.08	214.62	214.05	214.47	1540115.0
2021-02-03 15:00:00	IWM	ETF	214.47	214.57	213.76	214.23	2582816.0
2021-02-03 16:00:00	IWM	ETF	214.23	214.74	214.1663	214.69	817882.0
2021-02-03 17:00:00	IWM	ETF	214.7	214.8	214.25	214.25	600905.0
2021-02-03 18:00:00	IWM	ETF	214.59	214.73	214.25	214.45	43431.0
2021-02-03 19:00:00	IWM	ETF	214.35	214.49	214.15	214.16	28004.0
2021-02-03 04:00:00	DIA	ETF	306.93	306.93	306.93	306.93	195.0
2021-02-03 05:00:00	DIA	ETF	307.4	307.4	307.21	307.21	407.0

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

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