PREVIEW / etf_1hour / 2022-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-02.parquet
  size:    451 KB
  rows:    16,275

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
2022-08-02 04:00:00	SPY	ETF	408.68	409.49	407.83	408.14	29240.0
2022-08-02 05:00:00	SPY	ETF	408.16	408.39	407.6	407.6	35306.0
2022-08-02 06:00:00	SPY	ETF	407.76	407.82	407.17	407.69	73983.0
2022-08-02 07:00:00	SPY	ETF	407.68	408.6	407.6	408.26	144683.0
2022-08-02 08:00:00	SPY	ETF	408.13	409.07	407.4204	408.27	548674.0
2022-08-02 09:00:00	SPY	ETF	408.29	409.77	407.6787	408.6	5786299.0
2022-08-02 10:00:00	SPY	ETF	408.5901	411.4	406.82	410.48	8116231.0
2022-08-02 11:00:00	SPY	ETF	410.48	411.08	409.47	410.6995	5099884.0
2022-08-02 12:00:00	SPY	ETF	410.7	413.0	410.54	412.63	4780197.0
2022-08-02 13:00:00	SPY	ETF	412.625	412.66	408.85	409.49	6571076.0
2022-08-02 14:00:00	SPY	ETF	409.5	410.82	409.1201	409.48	5964686.0
2022-08-02 15:00:00	SPY	ETF	409.49	409.97	407.93	408.12	9522706.0
2022-08-02 16:00:00	SPY	ETF	408.11	408.39	407.68	408.35	2727114.0
2022-08-02 17:00:00	SPY	ETF	408.22	408.5	408.22	408.39	61442.0
2022-08-02 18:00:00	SPY	ETF	408.48	408.96	408.39	408.68	79349.0
2022-08-02 19:00:00	SPY	ETF	408.6	408.8	408.0	408.16	82781.0
2022-08-02 04:00:00	QQQ	ETF	314.64	314.64	312.5	312.8	81312.0
2022-08-02 05:00:00	QQQ	ETF	312.79	313.0	312.0	312.02	43518.0
2022-08-02 06:00:00	QQQ	ETF	312.0	312.4	311.71	312.39	81443.0
2022-08-02 07:00:00	QQQ	ETF	312.4	313.3	312.4	312.74	259080.0
2022-08-02 08:00:00	QQQ	ETF	312.8	315.506	311.8904	312.57	368378.0
2022-08-02 09:00:00	QQQ	ETF	312.53	315.15	312.46	314.09	6083650.0
2022-08-02 10:00:00	QQQ	ETF	314.09	316.24	311.8401	315.45	6663453.0
2022-08-02 11:00:00	QQQ	ETF	315.45	316.09	314.2916	315.74	3631400.0
2022-08-02 12:00:00	QQQ	ETF	315.745	318.545	315.57	317.99	4222420.0
2022-08-02 13:00:00	QQQ	ETF	317.985	318.05	313.85	314.54	5392163.0
2022-08-02 14:00:00	QQQ	ETF	314.5511	316.2	314.14	315.16	4161990.0
2022-08-02 15:00:00	QQQ	ETF	315.146	315.7	314.24	314.3	5907336.0
2022-08-02 16:00:00	QQQ	ETF	314.31	314.48	313.46	314.25	1090769.0
2022-08-02 17:00:00	QQQ	ETF	314.31	314.43	314.22	314.32	60466.0
2022-08-02 18:00:00	QQQ	ETF	314.3	314.58	314.06	314.33	87016.0
2022-08-02 19:00:00	QQQ	ETF	314.29	314.54	313.84	313.85	56791.0
2022-08-02 04:00:00	IWM	ETF	186.43	186.48	185.83	186.01	15263.0
2022-08-02 05:00:00	IWM	ETF	185.96	186.07	185.75	185.79	15860.0
2022-08-02 06:00:00	IWM	ETF	185.85	185.85	185.57	185.7	37762.0
2022-08-02 07:00:00	IWM	ETF	185.79	186.31	185.79	186.25	60984.0
2022-08-02 08:00:00	IWM	ETF	185.8796	186.5	185.7	186.15	78936.0
2022-08-02 09:00:00	IWM	ETF	186.16	187.06	185.48	186.64	2638132.0
2022-08-02 10:00:00	IWM	ETF	186.66	187.79	185.98	187.43	2283758.0
2022-08-02 11:00:00	IWM	ETF	187.42	188.06	186.88	187.89	1026109.0
2022-08-02 12:00:00	IWM	ETF	187.89	189.02	187.86	188.84	1088010.0
2022-08-02 13:00:00	IWM	ETF	188.83	188.84	187.08	187.52	1301556.0
2022-08-02 14:00:00	IWM	ETF	187.52	188.12	187.26	187.7	1373616.0
2022-08-02 15:00:00	IWM	ETF	187.7	187.9167	186.94	187.0	2193580.0
2022-08-02 16:00:00	IWM	ETF	187.0	187.27	186.81	187.18	1051541.0
2022-08-02 17:00:00	IWM	ETF	187.27	187.39	187.05	187.16	23980.0
2022-08-02 18:00:00	IWM	ETF	187.3	187.58	187.27	187.4	33196.0
2022-08-02 19:00:00	IWM	ETF	187.34	187.5	186.9	187.06	25474.0
2022-08-02 04:00:00	DIA	ETF	326.75	326.75	326.66	326.67	1700.0
2022-08-02 06:00:00	DIA	ETF	326.18	326.18	325.86	325.94	2400.0

> showing 50 of 16,275 rows — these rows as CSV

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