PREVIEW / etf_1hour / 2003-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-31.parquet
  size:    17 KB
  rows:    420

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-07-31 08:00:00	SPY	ETF	99.16	99.87	99.0	99.8	248500.0
2003-07-31 09:00:00	SPY	ETF	99.82	100.214	99.38	99.89	5187800.0
2003-07-31 10:00:00	SPY	ETF	99.857	100.74	99.172	100.74	15240400.0
2003-07-31 11:00:00	SPY	ETF	100.74	100.94	100.58	100.64	4860300.0
2003-07-31 12:00:00	SPY	ETF	100.59	100.78	100.54	100.73	2420000.0
2003-07-31 13:00:00	SPY	ETF	100.73	100.9	100.65	100.76	2646100.0
2003-07-31 14:00:00	SPY	ETF	100.769	100.86	100.1	100.27	5613400.0
2003-07-31 15:00:00	SPY	ETF	100.3	100.54	99.25	99.41	10551400.0
2003-07-31 16:00:00	SPY	ETF	99.41	99.46	99.1318	99.4	3802800.0
2003-07-31 17:00:00	SPY	ETF	99.4	99.49	99.38	99.45	17400.0
2003-07-31 18:00:00	SPY	ETF	99.41	99.6	99.25	99.6	4142600.0
2003-07-31 19:00:00	SPY	ETF	99.52	99.56	99.5	99.5	9800.0
2003-07-31 08:00:00	QQQ	ETF	31.47	31.8	31.44	31.78	521900.0
2003-07-31 09:00:00	QQQ	ETF	31.78	31.925	31.63	31.85	9768100.0
2003-07-31 10:00:00	QQQ	ETF	31.83	32.23	31.52	32.201	20560300.0
2003-07-31 11:00:00	QQQ	ETF	32.23	32.31	32.13	32.14	11185100.0
2003-07-31 12:00:00	QQQ	ETF	32.16	32.26	32.14	32.22	3803800.0
2003-07-31 13:00:00	QQQ	ETF	32.22	32.29	32.17	32.22	4217400.0
2003-07-31 14:00:00	QQQ	ETF	32.22	32.26	31.95	32.02	8713800.0
2003-07-31 15:00:00	QQQ	ETF	32.01	32.16	31.66	31.709	16692400.0
2003-07-31 16:00:00	QQQ	ETF	31.7	31.84	31.4111	31.79	3407800.0
2003-07-31 17:00:00	QQQ	ETF	31.78	31.807	31.76	31.8	28700.0
2003-07-31 18:00:00	QQQ	ETF	31.79	31.83	31.77	31.82	35100.0
2003-07-31 19:00:00	QQQ	ETF	31.81	31.9	31.81	31.86	18400.0
2003-07-31 08:00:00	IWM	ETF	47.29	47.34	47.28	47.34	55400.0
2003-07-31 09:00:00	IWM	ETF	47.325	47.5	47.25	47.405	277600.0
2003-07-31 10:00:00	IWM	ETF	47.33	47.62	47.235	47.61	1028600.0
2003-07-31 11:00:00	IWM	ETF	47.64	47.87	47.6	47.7	591200.0
2003-07-31 12:00:00	IWM	ETF	47.69	47.74	47.685	47.715	102600.0
2003-07-31 13:00:00	IWM	ETF	47.74	47.85	47.7	47.78	138800.0
2003-07-31 14:00:00	IWM	ETF	47.78	47.8	47.545	47.625	316000.0
2003-07-31 15:00:00	IWM	ETF	47.64	47.74	47.355	47.485	1374200.0
2003-07-31 16:00:00	IWM	ETF	47.441	47.495	47.25	47.49	836000.0
2003-07-31 08:00:00	DIA	ETF	92.11	92.78	92.1	92.7	45300.0
2003-07-31 09:00:00	DIA	ETF	92.72	93.03	92.42	92.9	1028700.0
2003-07-31 10:00:00	DIA	ETF	92.9	93.65	92.38	93.64	2739500.0
2003-07-31 11:00:00	DIA	ETF	93.6	93.74	93.42	93.44	1593900.0
2003-07-31 12:00:00	DIA	ETF	93.45	93.65	93.42	93.62	351600.0
2003-07-31 13:00:00	DIA	ETF	93.61	93.77	93.53	93.63	345100.0
2003-07-31 14:00:00	DIA	ETF	93.65	93.72	93.06	93.22	1210700.0
2003-07-31 15:00:00	DIA	ETF	93.21	93.44	92.3	92.38	1840600.0
2003-07-31 16:00:00	DIA	ETF	92.38	92.47	92.28	92.43	107000.0
2003-07-31 17:00:00	DIA	ETF	92.4	92.5	92.38	92.5	3700.0
2003-07-31 18:00:00	DIA	ETF	92.4	92.49	92.3	92.49	5100.0
2003-07-31 19:00:00	DIA	ETF	92.43	92.67	92.43	92.5	4300.0
2003-07-31 09:00:00	TLT	ETF	83.69	83.69	83.3	83.4	321400.0
2003-07-31 10:00:00	TLT	ETF	83.35	83.71	83.2	83.21	655900.0
2003-07-31 11:00:00	TLT	ETF	83.22	83.39	82.87	82.91	312500.0
2003-07-31 12:00:00	TLT	ETF	82.91	83.13	82.76	82.76	298800.0
2003-07-31 13:00:00	TLT	ETF	82.78	82.8	82.45	82.8	459700.0

> showing 50 of 420 rows — these rows as CSV

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