PREVIEW / etf_1hour / 2023-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-04.parquet
  size:    524 KB
  rows:    19,227

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-12-04 04:00:00	SPY	ETF	458.06	459.0	457.6	458.0	35320.0
2023-12-04 05:00:00	SPY	ETF	458.0	458.01	457.63	457.8	18531.0
2023-12-04 06:00:00	SPY	ETF	457.85	457.95	457.38	457.53	135577.0
2023-12-04 07:00:00	SPY	ETF	457.51	457.84	457.18	457.76	131360.0
2023-12-04 08:00:00	SPY	ETF	457.45	458.46	456.4	456.44	460779.0
2023-12-04 09:00:00	SPY	ETF	456.45	456.83	455.32	455.99	7511567.0
2023-12-04 10:00:00	SPY	ETF	455.98	456.315	454.34	454.5501	11529859.0
2023-12-04 11:00:00	SPY	ETF	454.55	456.03	454.43	455.94	6690040.0
2023-12-04 12:00:00	SPY	ETF	455.95	456.74	455.76	456.67	5900823.0
2023-12-04 13:00:00	SPY	ETF	456.67	456.69	455.765	455.89	4821411.0
2023-12-04 14:00:00	SPY	ETF	455.8898	456.19	455.495	455.985	4922360.0
2023-12-04 15:00:00	SPY	ETF	455.98	456.937	455.67	456.66	12531223.0
2023-12-04 16:00:00	SPY	ETF	456.66	456.7997	455.924	456.28	2885726.0
2023-12-04 17:00:00	SPY	ETF	456.28	456.29	456.1	456.2	48198.0
2023-12-04 18:00:00	SPY	ETF	456.21	456.27	455.86	455.96	53954.0
2023-12-04 19:00:00	SPY	ETF	455.9603	455.99	455.8199	455.82	58032.0
2023-12-04 04:00:00	QQQ	ETF	389.03	389.9	388.43	388.66	31632.0
2023-12-04 05:00:00	QQQ	ETF	388.71	388.83	388.37	388.61	25184.0
2023-12-04 06:00:00	QQQ	ETF	388.72	388.76	388.02	388.19	48902.0
2023-12-04 07:00:00	QQQ	ETF	388.16	388.6	387.75	388.51	121230.0
2023-12-04 08:00:00	QQQ	ETF	388.1494	390.232	387.09	387.17	339275.0
2023-12-04 09:00:00	QQQ	ETF	387.17	387.18	385.13	385.5291	5478293.0
2023-12-04 10:00:00	QQQ	ETF	385.51	386.295	382.66	383.055	9419690.0
2023-12-04 11:00:00	QQQ	ETF	383.05	385.285	382.84	385.195	4699914.0
2023-12-04 12:00:00	QQQ	ETF	385.2	386.19	384.97	386.0806	4474436.0
2023-12-04 13:00:00	QQQ	ETF	386.09	386.1	384.96	385.1	3412363.0
2023-12-04 14:00:00	QQQ	ETF	385.1	385.55	384.445	385.1866	3414345.0
2023-12-04 15:00:00	QQQ	ETF	385.18	386.595	384.733	386.27	6988852.0
2023-12-04 16:00:00	QQQ	ETF	386.27	386.32	385.84	385.92	1522340.0
2023-12-04 17:00:00	QQQ	ETF	385.9503	386.04	385.88	386.0	58903.0
2023-12-04 18:00:00	QQQ	ETF	386.0	386.0	385.64	385.75	35008.0
2023-12-04 19:00:00	QQQ	ETF	385.74	385.81	385.59	385.61	43563.0
2023-12-04 04:00:00	IWM	ETF	184.82	185.36	184.44	185.35	35554.0
2023-12-04 05:00:00	IWM	ETF	185.44	185.88	185.41	185.88	52701.0
2023-12-04 06:00:00	IWM	ETF	185.88	186.14	185.79	186.13	90399.0
2023-12-04 07:00:00	IWM	ETF	186.12	186.31	185.56	186.24	224208.0
2023-12-04 08:00:00	IWM	ETF	186.02	186.27	184.37	185.27	496000.0
2023-12-04 09:00:00	IWM	ETF	185.23	186.5398	184.02	185.29	8178981.0
2023-12-04 10:00:00	IWM	ETF	185.28	186.07	184.9	185.045	6804960.0
2023-12-04 11:00:00	IWM	ETF	185.04	186.23	184.86	186.185	3628411.0
2023-12-04 12:00:00	IWM	ETF	186.19	186.925	186.06	186.9099	3132591.0
2023-12-04 13:00:00	IWM	ETF	186.91	186.93	186.06	186.1799	2341678.0
2023-12-04 14:00:00	IWM	ETF	186.18	186.6	185.93	186.55	2254352.0
2023-12-04 15:00:00	IWM	ETF	186.56	186.99	186.38	186.875	6127584.0
2023-12-04 16:00:00	IWM	ETF	186.89	186.91	186.0764	186.8	1397022.0
2023-12-04 17:00:00	IWM	ETF	186.79	186.89	186.6901	186.71	521921.0
2023-12-04 18:00:00	IWM	ETF	186.7	186.7	186.34	186.52	42812.0
2023-12-04 19:00:00	IWM	ETF	186.54	186.59	186.47	186.52	25216.0
2023-12-04 04:00:00	DIA	ETF	362.37	362.38	362.08	362.38	1325.0
2023-12-04 05:00:00	DIA	ETF	362.24	362.24	362.24	362.24	200.0

> showing 50 of 19,227 rows — these rows as CSV

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