PREVIEW / etf_1hour / 2003-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-13.parquet
  size:    18 KB
  rows:    479

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-13 08:00:00	SPY	ETF	106.27	106.36	105.99	106.04	378900.0
2003-11-13 09:00:00	SPY	ETF	106.04	106.15	105.9	106.08	3483700.0
2003-11-13 10:00:00	SPY	ETF	106.11	106.24	105.78	105.85	4940600.0
2003-11-13 11:00:00	SPY	ETF	105.84	106.14	105.81	106.1	3240000.0
2003-11-13 12:00:00	SPY	ETF	106.1	106.25	106.0	106.24	2619800.0
2003-11-13 13:00:00	SPY	ETF	106.24	106.25	105.99	106.08	1337400.0
2003-11-13 14:00:00	SPY	ETF	106.07	106.33	105.91	106.31	2333200.0
2003-11-13 15:00:00	SPY	ETF	106.31	106.52	106.16	106.35	5987300.0
2003-11-13 16:00:00	SPY	ETF	106.36	106.45	106.2598	106.31	2265600.0
2003-11-13 17:00:00	SPY	ETF	106.32	106.32	106.23	106.25	477300.0
2003-11-13 18:00:00	SPY	ETF	106.26	106.36	106.26	106.35	1500.0
2003-11-13 19:00:00	SPY	ETF	106.32	106.32	106.31	106.31	800.0
2003-11-13 08:00:00	QQQ	ETF	35.89	35.93	35.66	35.68	271000.0
2003-11-13 09:00:00	QQQ	ETF	35.69	35.83	35.61	35.74	8587800.0
2003-11-13 10:00:00	QQQ	ETF	35.75	35.82	35.55	35.59	11703200.0
2003-11-13 11:00:00	QQQ	ETF	35.585	35.73	35.55	35.7	4782100.0
2003-11-13 12:00:00	QQQ	ETF	35.69	35.763	35.62	35.76	5608900.0
2003-11-13 13:00:00	QQQ	ETF	35.75	35.76	35.58	35.62	4724000.0
2003-11-13 14:00:00	QQQ	ETF	35.63	35.753	35.55	35.73	7194600.0
2003-11-13 15:00:00	QQQ	ETF	35.75	35.9	35.66	35.79	15547500.0
2003-11-13 16:00:00	QQQ	ETF	35.79	35.83	35.69	35.71	1410500.0
2003-11-13 17:00:00	QQQ	ETF	35.71	35.71	35.62	35.64	334100.0
2003-11-13 18:00:00	QQQ	ETF	35.68	35.69	35.66	35.69	29300.0
2003-11-13 19:00:00	QQQ	ETF	35.71	35.71	35.68	35.69	9100.0
2003-11-13 08:00:00	IWM	ETF	53.565	53.565	53.565	53.565	400.0
2003-11-13 09:00:00	IWM	ETF	53.73	54.11	53.625	54.055	583200.0
2003-11-13 10:00:00	IWM	ETF	54.07	54.215	53.7	53.745	1589000.0
2003-11-13 11:00:00	IWM	ETF	53.735	54.025	53.72	54.01	1264200.0
2003-11-13 12:00:00	IWM	ETF	53.965	54.045	53.931	53.99	257400.0
2003-11-13 13:00:00	IWM	ETF	54.0	54.02	53.87	53.93	475600.0
2003-11-13 14:00:00	IWM	ETF	53.96	54.055	53.82	54.055	438400.0
2003-11-13 15:00:00	IWM	ETF	54.025	54.125	53.9	54.07	1112600.0
2003-11-13 16:00:00	IWM	ETF	54.079	54.125	54.055	54.125	95400.0
2003-11-13 17:00:00	IWM	ETF	54.01	54.01	54.007	54.007	2000.0
2003-11-13 08:00:00	DIA	ETF	98.86	98.86	98.51	98.51	7600.0
2003-11-13 09:00:00	DIA	ETF	98.5	98.53	98.28	98.45	654900.0
2003-11-13 10:00:00	DIA	ETF	98.45	98.64	98.3	98.38	687100.0
2003-11-13 11:00:00	DIA	ETF	98.41	98.57	98.35	98.57	168700.0
2003-11-13 12:00:00	DIA	ETF	98.54	98.73	98.48	98.7	126400.0
2003-11-13 13:00:00	DIA	ETF	98.7	98.72	98.55	98.64	210700.0
2003-11-13 14:00:00	DIA	ETF	98.62	98.819	98.5	98.8	351200.0
2003-11-13 15:00:00	DIA	ETF	98.78	98.91	98.56	98.68	1473500.0
2003-11-13 16:00:00	DIA	ETF	98.68	98.78	98.67	98.71	45900.0
2003-11-13 17:00:00	DIA	ETF	98.68	98.75	98.67	98.67	700.0
2003-11-13 19:00:00	DIA	ETF	98.8	98.8	98.8	98.8	200.0
2003-11-13 09:00:00	TLT	ETF	84.6	84.8	84.6	84.77	136700.0
2003-11-13 10:00:00	TLT	ETF	84.65	84.75	84.6	84.61	188700.0
2003-11-13 11:00:00	TLT	ETF	84.65	84.7	84.55	84.6	135200.0
2003-11-13 12:00:00	TLT	ETF	84.62	84.71	84.56	84.64	53900.0
2003-11-13 13:00:00	TLT	ETF	84.73	85.08	84.61	85.03	82300.0

> showing 50 of 479 rows — these rows as CSV

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