PREVIEW / etf_1hour / 2003-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-03.parquet
  size:    19 KB
  rows:    482

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
2003-11-03 08:00:00	SPY	ETF	105.91	105.94	105.73	105.76	30800.0
2003-11-03 09:00:00	SPY	ETF	105.77	106.28	105.71	106.22	5479960.0
2003-11-03 10:00:00	SPY	ETF	106.28	106.53	106.2	106.35	7939033.0
2003-11-03 11:00:00	SPY	ETF	106.34	106.48	106.25	106.37	3726083.0
2003-11-03 12:00:00	SPY	ETF	106.35	106.53	106.18	106.49	3032468.0
2003-11-03 13:00:00	SPY	ETF	106.48	106.53	106.25	106.39	2135936.0
2003-11-03 14:00:00	SPY	ETF	106.38	106.56	106.14	106.51	2630458.0
2003-11-03 15:00:00	SPY	ETF	106.52	106.61	106.22	106.32	5864992.0
2003-11-03 16:00:00	SPY	ETF	106.33	106.37	105.92	106.06	1574713.0
2003-11-03 17:00:00	SPY	ETF	106.07	106.15	105.98	106.07	32500.0
2003-11-03 18:00:00	SPY	ETF	106.07	106.12	106.06	106.06	9600.0
2003-11-03 19:00:00	SPY	ETF	106.09	106.12	106.09	106.11	5600.0
2003-11-03 08:00:00	QQQ	ETF	35.39	35.53	35.39	35.45	86600.0
2003-11-03 09:00:00	QQQ	ETF	35.44	35.721	35.36	35.71	10332201.0
2003-11-03 10:00:00	QQQ	ETF	35.728	35.81	35.67	35.75	14017336.0
2003-11-03 11:00:00	QQQ	ETF	35.747	35.83	35.67	35.74	5613118.0
2003-11-03 12:00:00	QQQ	ETF	35.74	35.843	35.68	35.826	5284347.0
2003-11-03 13:00:00	QQQ	ETF	35.82	35.905	35.8	35.87	7425356.0
2003-11-03 14:00:00	QQQ	ETF	35.87	35.91	35.74	35.88	5811696.0
2003-11-03 15:00:00	QQQ	ETF	35.88	35.98	35.8	35.87	10794711.0
2003-11-03 16:00:00	QQQ	ETF	35.873	35.92	35.75	35.79	2906866.0
2003-11-03 17:00:00	QQQ	ETF	35.79	35.83	35.78	35.82	45501.0
2003-11-03 18:00:00	QQQ	ETF	35.81	35.82	35.78	35.81	34100.0
2003-11-03 19:00:00	QQQ	ETF	35.81	35.82	35.8	35.8	20000.0
2003-11-03 09:00:00	IWM	ETF	53.095	53.565	53.094	53.541	1323570.0
2003-11-03 10:00:00	IWM	ETF	53.614	53.751	53.52	53.595	1299800.0
2003-11-03 11:00:00	IWM	ETF	53.6	53.67	53.543	53.6	182160.0
2003-11-03 12:00:00	IWM	ETF	53.595	53.665	53.52	53.645	276344.0
2003-11-03 13:00:00	IWM	ETF	53.64	53.685	53.59	53.64	254454.0
2003-11-03 14:00:00	IWM	ETF	53.62	53.685	53.51	53.645	340992.0
2003-11-03 15:00:00	IWM	ETF	53.665	53.735	53.493	53.71	890622.0
2003-11-03 16:00:00	IWM	ETF	53.72	53.725	53.525	53.655	77132.0
2003-11-03 08:00:00	DIA	ETF	98.55	98.56	98.46	98.51	4800.0
2003-11-03 09:00:00	DIA	ETF	98.5	98.909	98.45	98.9	843741.0
2003-11-03 10:00:00	DIA	ETF	98.88	99.15	98.82	98.96	1846632.0
2003-11-03 11:00:00	DIA	ETF	98.97	99.05	98.87	99.0	291725.0
2003-11-03 12:00:00	DIA	ETF	99.0	99.12	98.85	99.09	236710.0
2003-11-03 13:00:00	DIA	ETF	99.06	99.1	98.83	98.96	335588.0
2003-11-03 14:00:00	DIA	ETF	98.96	99.04	98.66	98.99	430390.0
2003-11-03 15:00:00	DIA	ETF	98.99	99.078	98.73	98.84	450913.0
2003-11-03 16:00:00	DIA	ETF	98.85	98.883	98.51	98.53	304045.0
2003-11-03 17:00:00	DIA	ETF	98.58	98.65	98.58	98.6	3100.0
2003-11-03 18:00:00	DIA	ETF	98.7	98.7	98.7	98.7	900.0
2003-11-03 09:00:00	TLT	ETF	84.56	84.58	84.48	84.5	329420.0
2003-11-03 10:00:00	TLT	ETF	84.46	84.48	84.17	84.17	377707.0
2003-11-03 11:00:00	TLT	ETF	84.16	84.24	84.04	84.22	40700.0
2003-11-03 12:00:00	TLT	ETF	84.24	84.31	84.06	84.1	69428.0
2003-11-03 13:00:00	TLT	ETF	84.1	84.39	84.06	84.16	71578.0
2003-11-03 14:00:00	TLT	ETF	84.37	84.44	84.33	84.36	28500.0
2003-11-03 15:00:00	TLT	ETF	84.39	84.49	84.32	84.43	12969.0

> showing 50 of 482 rows — these rows as CSV

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