PREVIEW / etf_1hour / 2003-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-04.parquet
  size:    19 KB
  rows:    477

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-04 08:00:00	SPY	ETF	106.02	106.04	105.99	106.03	43500.0
2003-11-04 09:00:00	SPY	ETF	106.03	106.08	105.73	105.8	4425131.0
2003-11-04 10:00:00	SPY	ETF	105.81	106.12	105.67	105.97	5301521.0
2003-11-04 11:00:00	SPY	ETF	105.97	106.27	105.94	106.1	5292732.0
2003-11-04 12:00:00	SPY	ETF	106.09	106.12	105.71	105.77	4572730.0
2003-11-04 13:00:00	SPY	ETF	105.76	105.88	105.65	105.74	1533801.0
2003-11-04 14:00:00	SPY	ETF	105.74	105.98	105.58	105.93	4081194.0
2003-11-04 15:00:00	SPY	ETF	105.93	105.94	105.6	105.78	2928611.0
2003-11-04 16:00:00	SPY	ETF	105.78	105.85	105.65	105.8	950797.0
2003-11-04 17:00:00	SPY	ETF	105.76	105.79	105.75	105.79	60300.0
2003-11-04 18:00:00	SPY	ETF	105.76	105.76	105.76	105.76	5200.0
2003-11-04 19:00:00	SPY	ETF	105.74	105.74	105.63	105.68	1700.0
2003-11-04 08:00:00	QQQ	ETF	35.8	35.8	35.67	35.69	53400.0
2003-11-04 09:00:00	QQQ	ETF	35.69	35.75	35.57	35.63	7475046.0
2003-11-04 10:00:00	QQQ	ETF	35.637	35.79	35.57	35.72	10357342.0
2003-11-04 11:00:00	QQQ	ETF	35.71	35.87	35.7	35.756	9166956.0
2003-11-04 12:00:00	QQQ	ETF	35.76	35.78	35.57	35.59	7684854.0
2003-11-04 13:00:00	QQQ	ETF	35.589	35.6	35.47	35.54	5346234.0
2003-11-04 14:00:00	QQQ	ETF	35.54	35.72	35.45	35.69	6960109.0
2003-11-04 15:00:00	QQQ	ETF	35.69	35.7	35.51	35.59	5053771.0
2003-11-04 16:00:00	QQQ	ETF	35.58	35.6	35.474	35.504	2293274.0
2003-11-04 17:00:00	QQQ	ETF	35.5	35.52	35.49	35.5	42000.0
2003-11-04 18:00:00	QQQ	ETF	35.5	35.508	35.49	35.49	28700.0
2003-11-04 19:00:00	QQQ	ETF	35.49	35.49	35.43	35.45	35900.0
2003-11-04 08:00:00	IWM	ETF	53.56	53.56	53.56	53.56	1800.0
2003-11-04 09:00:00	IWM	ETF	53.6	53.625	53.46	53.58	299190.0
2003-11-04 10:00:00	IWM	ETF	53.575	53.91	53.53	53.85	574766.0
2003-11-04 11:00:00	IWM	ETF	53.84	53.99	53.805	53.84	470410.0
2003-11-04 12:00:00	IWM	ETF	53.835	53.89	53.696	53.75	753830.0
2003-11-04 13:00:00	IWM	ETF	53.73	53.795	53.695	53.785	179364.0
2003-11-04 14:00:00	IWM	ETF	53.79	53.9	53.67	53.895	662790.0
2003-11-04 15:00:00	IWM	ETF	53.885	53.89	53.66	53.735	676392.0
2003-11-04 16:00:00	IWM	ETF	53.72	53.813	53.555	53.555	184960.0
2003-11-04 08:00:00	DIA	ETF	98.6	98.6	98.55	98.55	3200.0
2003-11-04 09:00:00	DIA	ETF	98.55	98.64	98.44	98.5	428734.0
2003-11-04 10:00:00	DIA	ETF	98.49	98.78	98.38	98.67	896962.0
2003-11-04 11:00:00	DIA	ETF	98.67	98.9	98.65	98.81	497438.0
2003-11-04 12:00:00	DIA	ETF	98.81	98.84	98.57	98.59	449349.0
2003-11-04 13:00:00	DIA	ETF	98.59	98.71	98.53	98.57	450195.0
2003-11-04 14:00:00	DIA	ETF	98.57	98.76	98.45	98.73	699902.0
2003-11-04 15:00:00	DIA	ETF	98.73	98.75	98.48	98.56	641872.0
2003-11-04 16:00:00	DIA	ETF	98.559	98.66	98.55	98.64	133100.0
2003-11-04 17:00:00	DIA	ETF	98.58	98.58	98.58	98.58	2200.0
2003-11-04 18:00:00	DIA	ETF	98.68	98.68	98.57	98.57	300.0
2003-11-04 19:00:00	DIA	ETF	98.57	98.57	98.52	98.52	1300.0
2003-11-04 09:00:00	TLT	ETF	84.65	84.79	84.61	84.72	53200.0
2003-11-04 10:00:00	TLT	ETF	84.78	84.97	84.78	84.85	46217.0
2003-11-04 11:00:00	TLT	ETF	84.89	84.89	84.59	84.71	40463.0
2003-11-04 12:00:00	TLT	ETF	84.64	84.86	84.62	84.73	4700.0
2003-11-04 13:00:00	TLT	ETF	84.83	84.89	84.72	84.77	19130.0

> showing 50 of 477 rows — these rows as CSV

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