PREVIEW / etf_1hour / 2003-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-18.parquet
  size:    17 KB
  rows:    422

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-18 08:00:00	SPY	ETF	101.69	101.69	101.32	101.39	70800.0
2003-06-18 09:00:00	SPY	ETF	101.39	101.42	101.0	101.19	4555500.0
2003-06-18 10:00:00	SPY	ETF	101.18	101.61	101.12	101.55	4879300.0
2003-06-18 11:00:00	SPY	ETF	101.52	102.14	101.42	101.9	6074200.0
2003-06-18 12:00:00	SPY	ETF	101.899	102.03	101.56	101.76	2774400.0
2003-06-18 13:00:00	SPY	ETF	101.77	101.88	101.55	101.78	2838700.0
2003-06-18 14:00:00	SPY	ETF	101.784	101.81	101.16	101.23	4441000.0
2003-06-18 15:00:00	SPY	ETF	101.27	101.57	101.12	101.55	4373800.0
2003-06-18 16:00:00	SPY	ETF	101.57	101.64	101.4395	101.505	1607100.0
2003-06-18 17:00:00	SPY	ETF	101.5	101.62	101.5	101.57	99800.0
2003-06-18 18:00:00	SPY	ETF	101.6	101.63	101.52	101.6	9400.0
2003-06-18 08:00:00	QQQ	ETF	30.8	30.8	30.66	30.69	96800.0
2003-06-18 09:00:00	QQQ	ETF	30.69	30.7	30.45	30.6	10877500.0
2003-06-18 10:00:00	QQQ	ETF	30.601	31.03	30.576	31.0	17078800.0
2003-06-18 11:00:00	QQQ	ETF	30.972	31.22	30.92	31.13	14445200.0
2003-06-18 12:00:00	QQQ	ETF	31.138	31.2	31.0	31.07	5396700.0
2003-06-18 13:00:00	QQQ	ETF	31.08	31.18	31.01	31.12	4936800.0
2003-06-18 14:00:00	QQQ	ETF	31.12	31.13	30.82	30.909	8086000.0
2003-06-18 15:00:00	QQQ	ETF	30.89	31.02	30.86	30.999	9226900.0
2003-06-18 16:00:00	QQQ	ETF	31.0	31.036	30.9	30.9	2079300.0
2003-06-18 17:00:00	QQQ	ETF	30.901	31.02	30.9	30.97	217300.0
2003-06-18 18:00:00	QQQ	ETF	30.98	31.0	30.969	31.0	7600.0
2003-06-18 19:00:00	QQQ	ETF	31.0	31.02	30.96	31.02	12300.0
2003-06-18 20:00:00	QQQ	ETF	31.02	31.03	31.02	31.03	800.0
2003-06-18 09:00:00	IWM	ETF	45.49	45.575	45.285	45.4	359400.0
2003-06-18 10:00:00	IWM	ETF	45.405	45.545	45.395	45.51	407800.0
2003-06-18 11:00:00	IWM	ETF	45.5	45.765	45.5	45.665	505400.0
2003-06-18 12:00:00	IWM	ETF	45.665	45.69	45.575	45.625	103600.0
2003-06-18 13:00:00	IWM	ETF	45.635	45.705	45.61	45.64	74400.0
2003-06-18 14:00:00	IWM	ETF	45.635	45.675	45.47	45.5	188000.0
2003-06-18 15:00:00	IWM	ETF	45.51	45.635	45.47	45.63	314600.0
2003-06-18 16:00:00	IWM	ETF	45.65	45.65	45.615	45.64	14600.0
2003-06-18 08:00:00	DIA	ETF	93.41	93.41	92.99	93.05	21600.0
2003-06-18 09:00:00	DIA	ETF	93.05	93.1	92.63	92.84	1144400.0
2003-06-18 10:00:00	DIA	ETF	92.84	93.22	92.76	93.13	1480500.0
2003-06-18 11:00:00	DIA	ETF	93.133	93.7	93.02	93.5	1262300.0
2003-06-18 12:00:00	DIA	ETF	93.45	93.51	93.08	93.31	820900.0
2003-06-18 13:00:00	DIA	ETF	93.28	93.4	93.12	93.32	435300.0
2003-06-18 14:00:00	DIA	ETF	93.35	93.38	92.9	92.96	913800.0
2003-06-18 15:00:00	DIA	ETF	92.97	93.24	92.88	93.23	1022000.0
2003-06-18 16:00:00	DIA	ETF	93.24	93.33	93.2	93.2	111000.0
2003-06-18 17:00:00	DIA	ETF	93.2	93.25	93.2	93.2	2100.0
2003-06-18 18:00:00	DIA	ETF	93.25	93.33	93.25	93.33	1300.0
2003-06-18 09:00:00	TLT	ETF	95.06	95.06	94.82	94.85	110900.0
2003-06-18 10:00:00	TLT	ETF	94.84	94.9	94.37	94.47	157100.0
2003-06-18 11:00:00	TLT	ETF	94.43	94.6	94.2	94.59	154800.0
2003-06-18 12:00:00	TLT	ETF	94.59	94.65	94.49	94.56	60900.0
2003-06-18 13:00:00	TLT	ETF	94.48	94.62	94.25	94.6	46100.0
2003-06-18 14:00:00	TLT	ETF	94.54	94.62	94.35	94.35	11900.0
2003-06-18 15:00:00	TLT	ETF	94.35	94.42	94.26	94.36	68200.0

> showing 50 of 422 rows — these rows as CSV

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