PREVIEW / etf_1hour / 2021-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-02.parquet
  size:    411 KB
  rows:    14,404

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-09-02 04:00:00	SPY	ETF	452.23	452.86	450.0	452.79	13452.0
2021-09-02 05:00:00	SPY	ETF	452.81	452.81	452.48	452.48	10684.0
2021-09-02 06:00:00	SPY	ETF	452.62	452.67	452.45	452.55	14186.0
2021-09-02 07:00:00	SPY	ETF	452.57	452.69	452.47	452.64	46856.0
2021-09-02 08:00:00	SPY	ETF	452.6101	453.08	452.15	453.02	190261.0
2021-09-02 09:00:00	SPY	ETF	453.08	454.05	452.93	453.4	5365265.0
2021-09-02 10:00:00	SPY	ETF	453.4	453.715	453.05	453.46	4887713.0
2021-09-02 11:00:00	SPY	ETF	453.47	453.77	453.27	453.48	4122699.0
2021-09-02 12:00:00	SPY	ETF	453.47	453.525	453.08	453.38	2189316.0
2021-09-02 13:00:00	SPY	ETF	453.38	453.44	452.2401	452.36	3834124.0
2021-09-02 14:00:00	SPY	ETF	452.36	452.79	451.91	452.7117	4594218.0
2021-09-02 15:00:00	SPY	ETF	452.72	453.22	452.12	453.2	8446200.0
2021-09-02 16:00:00	SPY	ETF	453.2	453.33	452.94	453.27	1588437.0
2021-09-02 17:00:00	SPY	ETF	453.28	453.35	453.23	453.27	43433.0
2021-09-02 18:00:00	SPY	ETF	453.28	453.39	453.15	453.32	50196.0
2021-09-02 19:00:00	SPY	ETF	453.3	453.31	453.07	453.13	50597.0
2021-09-02 04:00:00	QQQ	ETF	380.99	381.47	380.99	381.37	16723.0
2021-09-02 05:00:00	QQQ	ETF	381.45	381.57	381.18	381.24	28232.0
2021-09-02 06:00:00	QQQ	ETF	381.24	381.42	381.24	381.29	28360.0
2021-09-02 07:00:00	QQQ	ETF	381.27	381.7	381.27	381.53	44222.0
2021-09-02 08:00:00	QQQ	ETF	381.54	381.83	381.03	381.67	104817.0
2021-09-02 09:00:00	QQQ	ETF	381.7	382.31	381.39	381.5201	2683148.0
2021-09-02 10:00:00	QQQ	ETF	381.54	381.82	380.71	381.368	3529332.0
2021-09-02 11:00:00	QQQ	ETF	381.38	381.695	380.8	381.075	1876548.0
2021-09-02 12:00:00	QQQ	ETF	381.08	381.1474	380.39	380.81	2094817.0
2021-09-02 13:00:00	QQQ	ETF	380.81	380.9525	379.63	379.82	2705755.0
2021-09-02 14:00:00	QQQ	ETF	379.81	380.35	379.15	380.275	2664676.0
2021-09-02 15:00:00	QQQ	ETF	380.28	380.47	379.78	380.42	4040793.0
2021-09-02 16:00:00	QQQ	ETF	380.45	380.85	379.96	380.32	837007.0
2021-09-02 17:00:00	QQQ	ETF	380.3	380.4	380.26	380.29	24130.0
2021-09-02 18:00:00	QQQ	ETF	380.29	380.5	380.23	380.48	27398.0
2021-09-02 19:00:00	QQQ	ETF	380.48	380.49	380.25	380.25	26042.0
2021-09-02 04:00:00	IWM	ETF	227.52	228.18	227.52	228.12	8281.0
2021-09-02 05:00:00	IWM	ETF	228.05	228.09	227.88	227.95	3664.0
2021-09-02 06:00:00	IWM	ETF	227.97	228.1	227.9	228.04	8945.0
2021-09-02 07:00:00	IWM	ETF	228.02	228.1	227.84	228.09	21979.0
2021-09-02 08:00:00	IWM	ETF	228.0001	228.49	227.39	228.46	181682.0
2021-09-02 09:00:00	IWM	ETF	228.44	228.57	227.6	228.489	2995961.0
2021-09-02 10:00:00	IWM	ETF	228.47	229.24	228.34	228.82	2973631.0
2021-09-02 11:00:00	IWM	ETF	228.8	229.809	228.8	229.75	1690196.0
2021-09-02 12:00:00	IWM	ETF	229.76	229.84	229.115	229.545	1510063.0
2021-09-02 13:00:00	IWM	ETF	229.54	229.58	228.73	228.88	1914953.0
2021-09-02 14:00:00	IWM	ETF	228.89	229.08	228.43	229.03	1663467.0
2021-09-02 15:00:00	IWM	ETF	229.04	229.18	228.65	229.01	2907407.0
2021-09-02 16:00:00	IWM	ETF	229.02	229.2	228.9	229.17	1048262.0
2021-09-02 17:00:00	IWM	ETF	229.06	229.2	229.02	229.05	35782.0
2021-09-02 18:00:00	IWM	ETF	229.15	229.3	229.02	229.27	25437.0
2021-09-02 19:00:00	IWM	ETF	229.26	229.28	229.07	229.15	28794.0
2021-09-02 04:00:00	DIA	ETF	354.12	354.12	354.12	354.12	200.0
2021-09-02 05:00:00	DIA	ETF	354.14	354.14	354.14	354.14	100.0

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

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