PREVIEW / etf_1hour / 2003-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-03-20.parquet
  size:    17 KB
  rows:    393

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-03-20 08:00:00	SPY	ETF	87.87	87.87	87.37	87.37	136000.0
2003-03-20 09:00:00	SPY	ETF	87.33	87.63	86.91	87.17	6194300.0
2003-03-20 10:00:00	SPY	ETF	86.97	87.4	86.35	87.29	12178800.0
2003-03-20 11:00:00	SPY	ETF	87.28	87.95	87.21	87.54	11181100.0
2003-03-20 12:00:00	SPY	ETF	87.52	88.06	87.3	87.62	6211100.0
2003-03-20 13:00:00	SPY	ETF	87.6	88.59	87.56	88.33	10450700.0
2003-03-20 14:00:00	SPY	ETF	88.31	88.43	87.8	87.8	5980400.0
2003-03-20 15:00:00	SPY	ETF	87.83	88.39	87.71	88.13	7143400.0
2003-03-20 16:00:00	SPY	ETF	88.13	88.26	88.01	88.05	1930400.0
2003-03-20 17:00:00	SPY	ETF	88.07	88.3	88.0	88.16	160400.0
2003-03-20 18:00:00	SPY	ETF	88.16	88.33	88.05	88.22	106900.0
2003-03-20 19:00:00	SPY	ETF	88.22	88.33	88.14	88.14	5100.0
2003-03-20 08:00:00	QQQ	ETF	26.65	26.65	26.46	26.49	176900.0
2003-03-20 09:00:00	QQQ	ETF	26.46	26.58	26.32	26.35	8513000.0
2003-03-20 10:00:00	QQQ	ETF	26.35	26.59	26.17	26.52	16191000.0
2003-03-20 11:00:00	QQQ	ETF	26.54	26.78	26.48	26.61	11047400.0
2003-03-20 12:00:00	QQQ	ETF	26.61	26.97	26.52	26.75	8130000.0
2003-03-20 13:00:00	QQQ	ETF	26.75	27.14	26.7	27.0	12820600.0
2003-03-20 14:00:00	QQQ	ETF	27.0	27.05	26.8	26.82	10279800.0
2003-03-20 15:00:00	QQQ	ETF	26.82	27.03	26.72	26.83	12042300.0
2003-03-20 16:00:00	QQQ	ETF	26.87	27.1	26.77	26.86	2892900.0
2003-03-20 17:00:00	QQQ	ETF	26.85	26.86	26.77	26.8	284100.0
2003-03-20 18:00:00	QQQ	ETF	26.84	26.86	26.79	26.86	295900.0
2003-03-20 19:00:00	QQQ	ETF	26.86	26.87	26.82	26.87	18300.0
2003-03-20 08:00:00	IWM	ETF	36.6	36.6	36.6	36.6	5000.0
2003-03-20 09:00:00	IWM	ETF	36.55	36.55	36.2	36.2	336600.0
2003-03-20 10:00:00	IWM	ETF	36.24	36.4	36.03	36.4	384600.0
2003-03-20 11:00:00	IWM	ETF	36.41	36.605	36.375	36.43	258200.0
2003-03-20 12:00:00	IWM	ETF	36.475	36.72	36.385	36.625	430600.0
2003-03-20 13:00:00	IWM	ETF	36.65	36.995	36.64	36.94	624000.0
2003-03-20 14:00:00	IWM	ETF	36.92	36.935	36.72	36.73	432200.0
2003-03-20 15:00:00	IWM	ETF	36.705	36.905	36.665	36.87	311800.0
2003-03-20 16:00:00	IWM	ETF	36.87	36.91	36.87	36.875	24200.0
2003-03-20 08:00:00	DIA	ETF	82.72	82.73	82.32	82.36	57000.0
2003-03-20 09:00:00	DIA	ETF	82.33	82.5	81.93	81.94	1054100.0
2003-03-20 10:00:00	DIA	ETF	81.94	82.4	81.47	82.24	2597700.0
2003-03-20 11:00:00	DIA	ETF	82.31	82.8	82.23	82.49	2623400.0
2003-03-20 12:00:00	DIA	ETF	82.49	82.99	82.27	82.55	1261400.0
2003-03-20 13:00:00	DIA	ETF	82.51	83.45	82.47	83.24	2645400.0
2003-03-20 14:00:00	DIA	ETF	83.23	83.32	82.77	82.78	1667000.0
2003-03-20 15:00:00	DIA	ETF	82.8	83.27	82.66	83.09	1727900.0
2003-03-20 16:00:00	DIA	ETF	83.1	83.13	82.99	83.0	148600.0
2003-03-20 17:00:00	DIA	ETF	83.01	83.35	83.01	83.16	17100.0
2003-03-20 18:00:00	DIA	ETF	83.24	83.24	83.14	83.2	8100.0
2003-03-20 19:00:00	DIA	ETF	83.3	83.35	83.15	83.15	2600.0
2003-03-20 09:00:00	TLT	ETF	87.82	87.85	87.67	87.67	30100.0
2003-03-20 10:00:00	TLT	ETF	87.65	87.95	87.5	87.5	10300.0
2003-03-20 11:00:00	TLT	ETF	87.46	87.55	87.37	87.38	16200.0
2003-03-20 12:00:00	TLT	ETF	87.5	87.5	87.11	87.11	14400.0
2003-03-20 13:00:00	TLT	ETF	87.34	87.43	86.76	86.96	39800.0

> showing 50 of 393 rows — these rows as CSV

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