PREVIEW / etf_1hour / 2003-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-04.parquet
  size:    19 KB
  rows:    494

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-12-04 08:00:00	SPY	ETF	107.41	107.46	107.17	107.22	80300.0
2003-12-04 09:00:00	SPY	ETF	107.2	107.34	107.1	107.25	2143100.0
2003-12-04 10:00:00	SPY	ETF	107.25	107.6	107.22	107.55	7027200.0
2003-12-04 11:00:00	SPY	ETF	107.59	107.65	107.415	107.55	3303500.0
2003-12-04 12:00:00	SPY	ETF	107.56	107.61	107.37	107.4	1726600.0
2003-12-04 13:00:00	SPY	ETF	107.4	107.46	106.96	107.05	6271400.0
2003-12-04 14:00:00	SPY	ETF	107.05	107.22	106.94	107.17	3203700.0
2003-12-04 15:00:00	SPY	ETF	107.22	107.7	107.2	107.68	4714400.0
2003-12-04 16:00:00	SPY	ETF	107.67	107.7	107.2	107.34	1432400.0
2003-12-04 17:00:00	SPY	ETF	107.36	107.38	107.33	107.38	8100.0
2003-12-04 18:00:00	SPY	ETF	107.37	107.4	107.35	107.35	3400.0
2003-12-04 19:00:00	SPY	ETF	107.4	107.4	107.4	107.4	300.0
2003-12-04 08:00:00	QQQ	ETF	35.51	35.56	35.36	35.4	364500.0
2003-12-04 09:00:00	QQQ	ETF	35.4	35.52	35.28	35.4	11860200.0
2003-12-04 10:00:00	QQQ	ETF	35.4	35.63	35.32	35.59	16472000.0
2003-12-04 11:00:00	QQQ	ETF	35.59	35.64	35.45	35.534	6694800.0
2003-12-04 12:00:00	QQQ	ETF	35.534	35.59	35.38	35.39	6587900.0
2003-12-04 13:00:00	QQQ	ETF	35.389	35.41	35.13	35.16	10819100.0
2003-12-04 14:00:00	QQQ	ETF	35.16	35.3	35.08	35.28	12055600.0
2003-12-04 15:00:00	QQQ	ETF	35.29	35.71	35.26	35.626	15947200.0
2003-12-04 16:00:00	QQQ	ETF	35.63	35.66	35.25	35.39	5516800.0
2003-12-04 17:00:00	QQQ	ETF	35.38	35.66	35.36	35.41	271000.0
2003-12-04 18:00:00	QQQ	ETF	35.41	35.43	35.4	35.42	89400.0
2003-12-04 19:00:00	QQQ	ETF	35.42	35.42	35.4	35.4	26600.0
2003-12-04 09:00:00	IWM	ETF	54.415	54.46	53.998	54.13	1140000.0
2003-12-04 10:00:00	IWM	ETF	54.135	54.4675	54.05	54.415	507800.0
2003-12-04 11:00:00	IWM	ETF	54.41	54.505	54.21	54.28	1087200.0
2003-12-04 12:00:00	IWM	ETF	54.295	54.335	54.091	54.105	310000.0
2003-12-04 13:00:00	IWM	ETF	54.145	54.175	53.57	53.635	672800.0
2003-12-04 14:00:00	IWM	ETF	53.63	53.815	53.555	53.8	1150000.0
2003-12-04 15:00:00	IWM	ETF	53.845	54.398	53.795	54.34	1633200.0
2003-12-04 16:00:00	IWM	ETF	54.39	54.475	53.865	54.22	487800.0
2003-12-04 17:00:00	IWM	ETF	54.27	54.274	53.785	53.785	9000.0
2003-12-04 18:00:00	IWM	ETF	54.205	54.205	54.2	54.2	3000.0
2003-12-04 08:00:00	DIA	ETF	99.19	99.24	99.05	99.06	7000.0
2003-12-04 09:00:00	DIA	ETF	99.03	99.09	98.86	99.02	192700.0
2003-12-04 10:00:00	DIA	ETF	99.07	99.36	99.07	99.31	1127100.0
2003-12-04 11:00:00	DIA	ETF	99.33	99.44	99.22	99.35	1011100.0
2003-12-04 12:00:00	DIA	ETF	99.36	99.42	99.212	99.26	617400.0
2003-12-04 13:00:00	DIA	ETF	99.25	99.33	98.86	98.91	947000.0
2003-12-04 14:00:00	DIA	ETF	98.91	99.18	98.89	99.18	809900.0
2003-12-04 15:00:00	DIA	ETF	99.17	99.51	99.1	99.45	749300.0
2003-12-04 16:00:00	DIA	ETF	99.49	99.52	99.16	99.25	214100.0
2003-12-04 17:00:00	DIA	ETF	99.25	99.25	99.25	99.25	200.0
2003-12-04 18:00:00	DIA	ETF	99.28	99.28	99.28	99.28	100.0
2003-12-04 09:00:00	TLT	ETF	84.26	84.36	84.19	84.3	21800.0
2003-12-04 10:00:00	TLT	ETF	84.32	84.48	84.29	84.29	144200.0
2003-12-04 11:00:00	TLT	ETF	84.38	84.51	84.34	84.38	78700.0
2003-12-04 12:00:00	TLT	ETF	84.38	84.44	84.32	84.43	30300.0
2003-12-04 13:00:00	TLT	ETF	84.39	84.55	84.39	84.48	22100.0

> showing 50 of 494 rows — these rows as CSV

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