PREVIEW / etf_1hour / 2003-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-16.parquet
  size:    18 KB
  rows:    435

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-06-16 08:00:00	SPY	ETF	99.44	100.0	99.44	99.96	38500.0
2003-06-16 09:00:00	SPY	ETF	99.96	100.17	99.8	100.03	3608700.0
2003-06-16 10:00:00	SPY	ETF	100.03	100.97	100.0	100.91	6247200.0
2003-06-16 11:00:00	SPY	ETF	100.9	101.23	100.9	101.05	5346900.0
2003-06-16 12:00:00	SPY	ETF	101.07	101.25	100.91	100.96	2724000.0
2003-06-16 13:00:00	SPY	ETF	100.94	101.15	100.85	101.11	2064000.0
2003-06-16 14:00:00	SPY	ETF	101.129	101.34	101.08	101.28	4085200.0
2003-06-16 15:00:00	SPY	ETF	101.3	101.66	101.05	101.64	6886300.0
2003-06-16 16:00:00	SPY	ETF	101.626	101.7	101.37	101.63	1876200.0
2003-06-16 17:00:00	SPY	ETF	101.627	101.66	101.6	101.66	26300.0
2003-06-16 18:00:00	SPY	ETF	101.65	101.69	101.65	101.69	5500.0
2003-06-16 19:00:00	SPY	ETF	101.64	101.73	101.59	101.73	75600.0
2003-06-16 08:00:00	QQQ	ETF	29.97	30.2	29.95	30.15	124200.0
2003-06-16 09:00:00	QQQ	ETF	30.16	30.24	30.0	30.08	7465400.0
2003-06-16 10:00:00	QQQ	ETF	30.08	30.57	30.06	30.53	16426900.0
2003-06-16 11:00:00	QQQ	ETF	30.54	30.69	30.52	30.6	11506800.0
2003-06-16 12:00:00	QQQ	ETF	30.62	30.694	30.56	30.57	4525100.0
2003-06-16 13:00:00	QQQ	ETF	30.573	30.67	30.52	30.66	2660400.0
2003-06-16 14:00:00	QQQ	ETF	30.66	30.798	30.66	30.73	8877000.0
2003-06-16 15:00:00	QQQ	ETF	30.74	30.84	30.6	30.81	10041700.0
2003-06-16 16:00:00	QQQ	ETF	30.81	30.949	30.78	30.93	2952500.0
2003-06-16 17:00:00	QQQ	ETF	30.921	30.94	30.91	30.93	335900.0
2003-06-16 18:00:00	QQQ	ETF	30.93	30.94	30.89	30.89	339800.0
2003-06-16 19:00:00	QQQ	ETF	30.88	30.9	30.87	30.89	16800.0
2003-06-16 09:00:00	IWM	ETF	45.1	45.15	44.97	45.035	446600.0
2003-06-16 10:00:00	IWM	ETF	45.055	45.48	45.025	45.465	458600.0
2003-06-16 11:00:00	IWM	ETF	45.475	45.56	45.35	45.36	639200.0
2003-06-16 12:00:00	IWM	ETF	45.38	45.41	45.29	45.29	179800.0
2003-06-16 13:00:00	IWM	ETF	45.31	45.36	45.27	45.345	176800.0
2003-06-16 14:00:00	IWM	ETF	45.36	45.51	45.34	45.43	265000.0
2003-06-16 15:00:00	IWM	ETF	45.425	45.62	45.365	45.62	505000.0
2003-06-16 16:00:00	IWM	ETF	45.55	45.58	45.51	45.575	205800.0
2003-06-16 08:00:00	DIA	ETF	91.58	91.93	91.58	91.9	3100.0
2003-06-16 09:00:00	DIA	ETF	91.95	92.16	91.81	91.99	994600.0
2003-06-16 10:00:00	DIA	ETF	92.0	92.82	91.93	92.73	1739600.0
2003-06-16 11:00:00	DIA	ETF	92.73	93.031	92.71	92.92	1454600.0
2003-06-16 12:00:00	DIA	ETF	92.94	93.06	92.78	92.84	537100.0
2003-06-16 13:00:00	DIA	ETF	92.85	93.03	92.77	92.99	332000.0
2003-06-16 14:00:00	DIA	ETF	92.99	93.24	92.92	93.15	595000.0
2003-06-16 15:00:00	DIA	ETF	93.13	93.56	92.92	93.54	1250100.0
2003-06-16 16:00:00	DIA	ETF	93.53	93.56	93.42	93.52	299300.0
2003-06-16 17:00:00	DIA	ETF	93.48	93.51	93.48	93.51	500.0
2003-06-16 18:00:00	DIA	ETF	93.5	93.55	93.5	93.52	1900.0
2003-06-16 19:00:00	DIA	ETF	93.52	93.52	93.52	93.52	100.0
2003-06-16 09:00:00	TLT	ETF	97.5	97.66	97.43	97.54	45200.0
2003-06-16 10:00:00	TLT	ETF	97.54	97.58	97.34	97.38	149000.0
2003-06-16 11:00:00	TLT	ETF	97.32	97.32	96.96	97.05	188200.0
2003-06-16 12:00:00	TLT	ETF	96.96	96.96	96.423	96.52	80800.0
2003-06-16 13:00:00	TLT	ETF	96.5	96.69	96.5	96.53	72900.0
2003-06-16 14:00:00	TLT	ETF	96.48	96.59	96.36	96.53	42100.0

> showing 50 of 435 rows — these rows as CSV

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