PREVIEW / etf_1hour / 2003-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-12.parquet
  size:    17 KB
  rows:    430

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-12 08:00:00	SPY	ETF	100.95	101.0	100.76	100.92	73200.0
2003-06-12 09:00:00	SPY	ETF	100.89	100.9	100.33	100.33	5333200.0
2003-06-12 10:00:00	SPY	ETF	100.36	100.48	99.62	100.36	8943600.0
2003-06-12 11:00:00	SPY	ETF	100.34	100.47	100.06	100.07	3249000.0
2003-06-12 12:00:00	SPY	ETF	100.1	100.48	99.98	100.43	2767200.0
2003-06-12 13:00:00	SPY	ETF	100.43	100.46	99.9	100.04	3566800.0
2003-06-12 14:00:00	SPY	ETF	100.05	100.08	99.74	99.99	3416500.0
2003-06-12 15:00:00	SPY	ETF	99.95	100.62	99.81	100.48	5094100.0
2003-06-12 16:00:00	SPY	ETF	100.5	100.65	100.44	100.62	1010900.0
2003-06-12 17:00:00	SPY	ETF	100.61	100.63	100.42	100.55	80300.0
2003-06-12 18:00:00	SPY	ETF	100.51	100.57	100.51	100.57	4500.0
2003-06-12 19:00:00	SPY	ETF	100.57	100.57	100.45	100.45	2700.0
2003-06-12 08:00:00	QQQ	ETF	30.75	30.81	30.7	30.72	199900.0
2003-06-12 09:00:00	QQQ	ETF	30.72	30.75	30.44	30.45	16275800.0
2003-06-12 10:00:00	QQQ	ETF	30.45	30.63	30.26	30.56	19617400.0
2003-06-12 11:00:00	QQQ	ETF	30.55	30.66	30.44	30.47	8045000.0
2003-06-12 12:00:00	QQQ	ETF	30.48	30.57	30.37	30.5	5508000.0
2003-06-12 13:00:00	QQQ	ETF	30.52	30.55	30.34	30.39	3948500.0
2003-06-12 14:00:00	QQQ	ETF	30.4	30.45	30.3	30.42	6176900.0
2003-06-12 15:00:00	QQQ	ETF	30.42	30.63	30.38	30.55	10507500.0
2003-06-12 16:00:00	QQQ	ETF	30.56	30.69	30.01	30.54	2791000.0
2003-06-12 17:00:00	QQQ	ETF	30.65	30.71	30.65	30.66	542300.0
2003-06-12 18:00:00	QQQ	ETF	30.66	30.66	30.62	30.62	71000.0
2003-06-12 19:00:00	QQQ	ETF	30.63	30.63	30.61	30.63	42800.0
2003-06-12 09:00:00	IWM	ETF	45.705	45.805	45.615	45.665	301600.0
2003-06-12 10:00:00	IWM	ETF	45.595	45.71	45.42	45.7	427400.0
2003-06-12 11:00:00	IWM	ETF	45.7	45.735	45.59	45.59	253800.0
2003-06-12 12:00:00	IWM	ETF	45.59	45.64	45.54	45.64	92000.0
2003-06-12 13:00:00	IWM	ETF	45.64	45.64	45.45	45.465	340800.0
2003-06-12 14:00:00	IWM	ETF	45.455	45.48	45.4	45.435	295200.0
2003-06-12 15:00:00	IWM	ETF	45.425	45.705	45.425	45.605	377200.0
2003-06-12 16:00:00	IWM	ETF	45.67	45.705	45.645	45.705	11400.0
2003-06-12 08:00:00	DIA	ETF	92.55	92.75	92.55	92.71	34900.0
2003-06-12 09:00:00	DIA	ETF	92.7	92.7	92.13	92.16	1188000.0
2003-06-12 10:00:00	DIA	ETF	92.1	92.32	91.5	92.24	2457100.0
2003-06-12 11:00:00	DIA	ETF	92.25	92.35	92.0	92.01	441700.0
2003-06-12 12:00:00	DIA	ETF	92.07	92.42	92.0	92.38	777300.0
2003-06-12 13:00:00	DIA	ETF	92.39	92.42	91.93	92.03	666600.0
2003-06-12 14:00:00	DIA	ETF	92.03	92.03	91.74	91.95	892800.0
2003-06-12 15:00:00	DIA	ETF	91.95	92.41	91.8	92.29	1433500.0
2003-06-12 16:00:00	DIA	ETF	92.3	92.45	92.3	92.39	114700.0
2003-06-12 17:00:00	DIA	ETF	92.44	92.46	92.31	92.4	3100.0
2003-06-12 09:00:00	TLT	ETF	96.11	96.34	96.01	96.33	53000.0
2003-06-12 10:00:00	TLT	ETF	96.34	96.38	96.16	96.3	108200.0
2003-06-12 11:00:00	TLT	ETF	96.4	96.48	96.3	96.42	14000.0
2003-06-12 12:00:00	TLT	ETF	96.42	96.73	96.42	96.59	63600.0
2003-06-12 13:00:00	TLT	ETF	96.56	96.72	96.51	96.52	36700.0
2003-06-12 14:00:00	TLT	ETF	96.6	96.62	96.45	96.45	16200.0
2003-06-12 15:00:00	TLT	ETF	96.4	96.55	96.37	96.5	16300.0
2003-06-12 16:00:00	TLT	ETF	96.54	96.54	96.53	96.53	3000.0

> showing 50 of 430 rows — these rows as CSV

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