PREVIEW / etf_1hour / 2001-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-06.parquet
  size:    12 KB
  rows:    228

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
2001-07-06 09:00:00	SPY	ETF	121.31	121.49	120.75	120.83	982400.0
2001-07-06 10:00:00	SPY	ETF	120.81	120.89	119.75	119.91	1424500.0
2001-07-06 11:00:00	SPY	ETF	119.88	120.14	119.26	119.48	784600.0
2001-07-06 12:00:00	SPY	ETF	119.5	119.84	119.43	119.6	816800.0
2001-07-06 13:00:00	SPY	ETF	119.65	119.8	119.39	119.57	1125400.0
2001-07-06 14:00:00	SPY	ETF	119.56	119.7	119.05	119.32	1541400.0
2001-07-06 15:00:00	SPY	ETF	119.32	119.86	119.19	119.19	2368100.0
2001-07-06 16:00:00	SPY	ETF	119.19	119.37	118.01	118.5	2254700.0
2001-07-06 17:00:00	SPY	ETF	118.7	118.7	118.5	118.56	700.0
2001-07-06 09:00:00	QQQ	ETF	43.01	43.11	42.45	42.53	7866200.0
2001-07-06 10:00:00	QQQ	ETF	42.52	42.55	41.9	42.1	13240400.0
2001-07-06 11:00:00	QQQ	ETF	42.06	42.25	41.59	41.79	8656000.0
2001-07-06 12:00:00	QQQ	ETF	41.76	42.16	41.71	41.98	4425800.0
2001-07-06 13:00:00	QQQ	ETF	41.96	42.09	41.75	41.88	2455400.0
2001-07-06 14:00:00	QQQ	ETF	41.88	42.0	41.49	41.68	5548400.0
2001-07-06 15:00:00	QQQ	ETF	41.66	42.04	41.55	41.65	7877400.0
2001-07-06 16:00:00	QQQ	ETF	41.61	41.85	41.5	41.69	1764300.0
2001-07-06 17:00:00	QQQ	ETF	41.75	41.75	41.65	41.75	34700.0
2001-07-06 18:00:00	QQQ	ETF	41.7	41.75	41.67	41.67	9500.0
2001-07-06 09:00:00	IWM	ETF	48.55	48.725	48.55	48.55	24200.0
2001-07-06 10:00:00	IWM	ETF	48.305	48.4	48.0	48.05	150400.0
2001-07-06 11:00:00	IWM	ETF	48.055	48.155	47.775	47.9	23600.0
2001-07-06 12:00:00	IWM	ETF	47.89	48.055	47.89	48.0	10600.0
2001-07-06 13:00:00	IWM	ETF	48.005	48.08	47.98	48.05	44800.0
2001-07-06 14:00:00	IWM	ETF	48.07	48.07	47.91	48.025	105200.0
2001-07-06 15:00:00	IWM	ETF	48.065	48.255	47.825	47.94	221400.0
2001-07-06 16:00:00	IWM	ETF	47.975	48.0	47.925	47.95	5000.0
2001-07-06 09:00:00	DIA	ETF	104.63	104.63	103.85	103.9	186400.0
2001-07-06 10:00:00	DIA	ETF	103.9	104.0	102.9	103.15	637800.0
2001-07-06 11:00:00	DIA	ETF	103.02	103.3	102.43	102.64	584600.0
2001-07-06 12:00:00	DIA	ETF	102.55	102.94	102.51	102.8	182800.0
2001-07-06 13:00:00	DIA	ETF	102.8	102.88	102.55	102.68	156700.0
2001-07-06 14:00:00	DIA	ETF	102.6	102.77	102.32	102.6	317400.0
2001-07-06 15:00:00	DIA	ETF	102.61	102.9	102.4	102.45	365200.0
2001-07-06 16:00:00	DIA	ETF	102.5	102.66	102.5	102.56	136800.0

> showing 35 of 228 rows — these rows as CSV

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