PREVIEW / etf_1hour / 2023-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-01.parquet
  size:    497 KB
  rows:    18,160

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
2023-08-01 04:00:00	SPY	ETF	457.3	457.3	456.31	456.78	40034.0
2023-08-01 05:00:00	SPY	ETF	456.63	456.66	456.22	456.59	20409.0
2023-08-01 06:00:00	SPY	ETF	456.58	457.14	456.54	457.1	68783.0
2023-08-01 07:00:00	SPY	ETF	457.1	457.19	456.26	456.35	314871.0
2023-08-01 08:00:00	SPY	ETF	457.18	458.15	455.57	455.86	358623.0
2023-08-01 09:00:00	SPY	ETF	455.86	456.94	455.69	456.79	4522262.0
2023-08-01 10:00:00	SPY	ETF	456.8	457.25	455.53	456.33	9702606.0
2023-08-01 11:00:00	SPY	ETF	456.34	456.46	455.8	456.13	3880778.0
2023-08-01 12:00:00	SPY	ETF	456.14	456.35	455.49	456.315	3614445.0
2023-08-01 13:00:00	SPY	ETF	456.32	456.5	455.975	456.43	2966857.0
2023-08-01 14:00:00	SPY	ETF	456.44	456.97	456.415	456.71	4393242.0
2023-08-01 15:00:00	SPY	ETF	456.72	456.99	456.19	456.465	8035587.0
2023-08-01 16:00:00	SPY	ETF	456.47	456.52	456.14	456.26	1596239.0
2023-08-01 17:00:00	SPY	ETF	456.29	456.48	454.35	454.75	1278007.0
2023-08-01 18:00:00	SPY	ETF	454.63	455.09	453.54	455.09	386586.0
2023-08-01 19:00:00	SPY	ETF	455.09	455.16	454.67	455.02	71263.0
2023-08-01 04:00:00	QQQ	ETF	383.07	383.16	382.31	382.67	55118.0
2023-08-01 05:00:00	QQQ	ETF	382.54	382.75	382.1	382.56	35171.0
2023-08-01 06:00:00	QQQ	ETF	382.58	383.04	382.52	382.97	22340.0
2023-08-01 07:00:00	QQQ	ETF	382.98	383.1	381.65	381.65	202102.0
2023-08-01 08:00:00	QQQ	ETF	382.9795	383.99	381.36	381.779	378347.0
2023-08-01 09:00:00	QQQ	ETF	381.73	382.589	381.56	381.92	4351063.0
2023-08-01 10:00:00	QQQ	ETF	381.96	383.28	380.69	382.84	7750049.0
2023-08-01 11:00:00	QQQ	ETF	382.85	383.115	382.28	382.925	3584603.0
2023-08-01 12:00:00	QQQ	ETF	382.92	383.08	381.88	383.04	2824609.0
2023-08-01 13:00:00	QQQ	ETF	383.03	383.44	382.285	383.065	2290667.0
2023-08-01 14:00:00	QQQ	ETF	383.085	383.51	382.88	383.183	2458049.0
2023-08-01 15:00:00	QQQ	ETF	383.19	383.56	382.72	382.8	3623154.0
2023-08-01 16:00:00	QQQ	ETF	382.81	383.04	382.42	382.62	1552010.0
2023-08-01 17:00:00	QQQ	ETF	382.65	382.74	381.23	381.27	325479.0
2023-08-01 18:00:00	QQQ	ETF	381.27	381.3583	379.68	381.3583	416016.0
2023-08-01 19:00:00	QQQ	ETF	381.31	381.39	380.92	381.27	93087.0
2023-08-01 04:00:00	IWM	ETF	198.63	198.63	198.18	198.41	17044.0
2023-08-01 05:00:00	IWM	ETF	198.34	198.4	197.99	198.11	28859.0
2023-08-01 06:00:00	IWM	ETF	198.18	198.55	198.13	198.54	67552.0
2023-08-01 07:00:00	IWM	ETF	198.58	198.6	198.03	198.13	43648.0
2023-08-01 08:00:00	IWM	ETF	198.4896	198.57	197.46	197.69	151032.0
2023-08-01 09:00:00	IWM	ETF	197.65	197.78	196.53	197.53	4668584.0
2023-08-01 10:00:00	IWM	ETF	197.53	197.72	195.78	196.485	5419351.0
2023-08-01 11:00:00	IWM	ETF	196.49	196.94	196.19	196.83	1896463.0
2023-08-01 12:00:00	IWM	ETF	196.825	197.06	196.45	196.915	1471478.0
2023-08-01 13:00:00	IWM	ETF	196.92	197.32	196.89	197.25	1007451.0
2023-08-01 14:00:00	IWM	ETF	197.25	197.62	197.245	197.49	1578255.0
2023-08-01 15:00:00	IWM	ETF	197.5	197.935	197.43	197.79	2787861.0
2023-08-01 16:00:00	IWM	ETF	197.8	197.83	197.54	197.56	393339.0
2023-08-01 17:00:00	IWM	ETF	197.54	197.6	196.6	196.63	97353.0
2023-08-01 18:00:00	IWM	ETF	196.7	196.96	196.17	196.77	143277.0
2023-08-01 19:00:00	IWM	ETF	196.8	196.89	196.68	196.86	26331.0
2023-08-01 04:00:00	DIA	ETF	354.9	354.9	354.63	354.63	1400.0
2023-08-01 05:00:00	DIA	ETF	354.42	354.42	354.37	354.37	219.0

> showing 50 of 18,160 rows — these rows as CSV

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