PREVIEW / etf_1hour / 2001-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-10.parquet
  size:    12 KB
  rows:    229

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-10 09:00:00	SPY	ETF	120.29	120.64	120.26	120.35	999500.0
2001-07-10 10:00:00	SPY	ETF	120.26	120.35	119.64	119.74	950800.0
2001-07-10 11:00:00	SPY	ETF	119.78	119.9	119.25	119.59	918300.0
2001-07-10 12:00:00	SPY	ETF	119.59	119.84	119.5	119.5	470200.0
2001-07-10 13:00:00	SPY	ETF	119.5	119.52	118.85	118.92	1157900.0
2001-07-10 14:00:00	SPY	ETF	118.88	119.16	118.62	118.66	1274200.0
2001-07-10 15:00:00	SPY	ETF	118.68	118.89	118.21	118.35	2233900.0
2001-07-10 16:00:00	SPY	ETF	118.35	118.55	118.18	118.47	430100.0
2001-07-10 17:00:00	SPY	ETF	118.18	118.35	118.18	118.18	800.0
2001-07-10 18:00:00	SPY	ETF	118.36	118.97	118.36	118.97	1200.0
2001-07-10 09:00:00	QQQ	ETF	42.76	42.88	42.38	42.38	7536600.0
2001-07-10 10:00:00	QQQ	ETF	42.39	42.5	41.95	42.07	9249900.0
2001-07-10 11:00:00	QQQ	ETF	42.07	42.2	41.71	41.95	5657500.0
2001-07-10 12:00:00	QQQ	ETF	41.92	42.1	41.67	41.67	2910600.0
2001-07-10 13:00:00	QQQ	ETF	41.68	41.75	41.04	41.09	7685200.0
2001-07-10 14:00:00	QQQ	ETF	41.05	41.21	40.83	40.85	9240000.0
2001-07-10 15:00:00	QQQ	ETF	40.86	41.08	40.44	40.5	11717000.0
2001-07-10 16:00:00	QQQ	ETF	40.54	42.55	40.2	40.53	2247200.0
2001-07-10 17:00:00	QQQ	ETF	40.55	40.66	40.5	40.6	189700.0
2001-07-10 18:00:00	QQQ	ETF	40.56	41.05	40.56	40.75	62100.0
2001-07-10 09:00:00	IWM	ETF	48.55	48.55	48.5	48.55	107200.0
2001-07-10 10:00:00	IWM	ETF	48.275	48.42	48.25	48.275	52400.0
2001-07-10 11:00:00	IWM	ETF	48.345	48.35	48.105	48.195	160200.0
2001-07-10 12:00:00	IWM	ETF	48.21	48.375	48.15	48.21	147400.0
2001-07-10 13:00:00	IWM	ETF	48.21	48.235	47.91	47.91	117400.0
2001-07-10 14:00:00	IWM	ETF	47.75	47.885	47.73	47.835	65800.0
2001-07-10 15:00:00	IWM	ETF	47.78	47.835	47.29	47.29	90800.0
2001-07-10 16:00:00	IWM	ETF	47.425	47.5	47.425	47.5	24800.0
2001-07-10 09:00:00	DIA	ETF	103.4	103.5	103.12	103.16	203800.0
2001-07-10 10:00:00	DIA	ETF	103.25	103.25	102.53	102.81	414900.0
2001-07-10 11:00:00	DIA	ETF	102.83	102.95	102.5	102.7	349700.0
2001-07-10 12:00:00	DIA	ETF	102.71	103.0	102.67	102.76	90900.0
2001-07-10 13:00:00	DIA	ETF	102.76	102.78	102.2	102.2	213800.0
2001-07-10 14:00:00	DIA	ETF	102.2	102.47	102.04	102.05	253600.0
2001-07-10 15:00:00	DIA	ETF	102.11	102.3	101.7	101.8	464200.0
2001-07-10 16:00:00	DIA	ETF	101.84	101.9	101.76	101.82	25600.0
2001-07-10 17:00:00	DIA	ETF	101.82	101.85	101.82	101.85	600.0
2001-07-10 18:00:00	DIA	ETF	102.0	102.0	102.0	102.0	100.0

> showing 38 of 229 rows — these rows as CSV

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