PREVIEW / etf_1hour / 2003-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-22.parquet
  size:    17 KB
  rows:    419

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-08-22 08:00:00	SPY	ETF	100.75	101.6	100.72	101.54	141200.0
2003-08-22 09:00:00	SPY	ETF	101.52	101.818	101.4	101.62	4656300.0
2003-08-22 10:00:00	SPY	ETF	101.619	101.64	100.65	100.84	10163500.0
2003-08-22 11:00:00	SPY	ETF	100.83	100.94	100.27	100.42	5684700.0
2003-08-22 12:00:00	SPY	ETF	100.43	100.57	100.33	100.5	2953900.0
2003-08-22 13:00:00	SPY	ETF	100.48	100.53	100.27	100.39	2515700.0
2003-08-22 14:00:00	SPY	ETF	100.37	100.38	99.87	99.96	6418500.0
2003-08-22 15:00:00	SPY	ETF	99.98	100.15	99.74	99.77	7533100.0
2003-08-22 16:00:00	SPY	ETF	99.75	99.86	99.71	99.72	1721600.0
2003-08-22 17:00:00	SPY	ETF	99.74	99.76	99.7	99.71	10100.0
2003-08-22 18:00:00	SPY	ETF	99.71	99.73	99.71	99.72	1700.0
2003-08-22 19:00:00	SPY	ETF	99.72	99.72	99.7	99.7	600.0
2003-08-22 08:00:00	QQQ	ETF	32.7	33.3	32.65	33.25	536800.0
2003-08-22 09:00:00	QQQ	ETF	33.25	33.37	33.16	33.35	13332000.0
2003-08-22 10:00:00	QQQ	ETF	33.34	33.36	32.859	32.94	22692200.0
2003-08-22 11:00:00	QQQ	ETF	32.93	32.99	32.74	32.79	9356100.0
2003-08-22 12:00:00	QQQ	ETF	32.79	32.87	32.73	32.78	6070900.0
2003-08-22 13:00:00	QQQ	ETF	32.78	32.85	32.67	32.78	6353400.0
2003-08-22 14:00:00	QQQ	ETF	32.8	32.8	32.447	32.476	14141700.0
2003-08-22 15:00:00	QQQ	ETF	32.47	32.69	32.44	32.47	8408400.0
2003-08-22 16:00:00	QQQ	ETF	32.47	32.49	32.38	32.42	2853000.0
2003-08-22 17:00:00	QQQ	ETF	32.43	32.48	32.41	32.45	49000.0
2003-08-22 18:00:00	QQQ	ETF	32.45	32.46	32.43	32.45	11700.0
2003-08-22 19:00:00	QQQ	ETF	32.45	32.45	32.44	32.44	3000.0
2003-08-22 09:00:00	IWM	ETF	49.72	49.895	49.5	49.645	424200.0
2003-08-22 10:00:00	IWM	ETF	49.685	49.725	48.745	48.785	1469400.0
2003-08-22 11:00:00	IWM	ETF	48.815	48.92	48.625	48.675	848000.0
2003-08-22 12:00:00	IWM	ETF	48.67	48.78	48.66	48.73	702200.0
2003-08-22 13:00:00	IWM	ETF	48.73	48.77	48.67	48.72	340000.0
2003-08-22 14:00:00	IWM	ETF	48.66	48.705	48.445	48.57	1238200.0
2003-08-22 15:00:00	IWM	ETF	48.58	48.725	48.49	48.52	1203600.0
2003-08-22 16:00:00	IWM	ETF	48.52	48.76	48.46	48.76	159400.0
2003-08-22 08:00:00	DIA	ETF	94.84	95.14	94.77	95.1	15800.0
2003-08-22 09:00:00	DIA	ETF	95.1	95.24	94.89	95.09	829400.0
2003-08-22 10:00:00	DIA	ETF	95.11	95.15	94.44	94.61	1565100.0
2003-08-22 11:00:00	DIA	ETF	94.59	94.73	94.17	94.36	649900.0
2003-08-22 12:00:00	DIA	ETF	94.34	94.45	94.26	94.39	354600.0
2003-08-22 13:00:00	DIA	ETF	94.4	94.44	94.21	94.29	240000.0
2003-08-22 14:00:00	DIA	ETF	94.25	94.31	93.85	93.9	638100.0
2003-08-22 15:00:00	DIA	ETF	93.92	94.1	93.65	93.68	695700.0
2003-08-22 16:00:00	DIA	ETF	93.674	93.77	93.61	93.66	432400.0
2003-08-22 17:00:00	DIA	ETF	93.7	93.7	93.52	93.66	2900.0
2003-08-22 19:00:00	DIA	ETF	93.68	93.68	93.68	93.68	200.0
2003-08-22 09:00:00	TLT	ETF	82.95	83.15	82.9	82.95	35800.0
2003-08-22 10:00:00	TLT	ETF	82.99	83.35	82.97	83.16	72300.0
2003-08-22 11:00:00	TLT	ETF	83.2	83.38	83.16	83.3	32600.0
2003-08-22 12:00:00	TLT	ETF	83.34	83.4	83.18	83.27	20800.0
2003-08-22 13:00:00	TLT	ETF	83.2	83.35	83.19	83.3	19000.0
2003-08-22 14:00:00	TLT	ETF	83.36	83.74	83.35	83.54	106600.0
2003-08-22 15:00:00	TLT	ETF	83.52	83.52	83.26	83.36	102700.0

> showing 50 of 419 rows — these rows as CSV

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