PREVIEW / etf_1hour / 2004-03-29

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-29.parquet
  size:    25 KB
  rows:    692

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
2004-03-29 08:00:00	SPY	ETF	111.64	111.73	111.61	111.62	159500.0
2004-03-29 09:00:00	SPY	ETF	111.61	112.16	111.58	112.05	7392200.0
2004-03-29 10:00:00	SPY	ETF	112.04	112.58	112.04	112.53	7394900.0
2004-03-29 11:00:00	SPY	ETF	112.52	112.61	112.42	112.58	4733700.0
2004-03-29 12:00:00	SPY	ETF	112.59	112.64	112.43	112.5	2410800.0
2004-03-29 13:00:00	SPY	ETF	112.51	112.585	112.35	112.57	3293500.0
2004-03-29 14:00:00	SPY	ETF	112.59	112.74	112.36	112.59	3664400.0
2004-03-29 15:00:00	SPY	ETF	112.6	112.74	112.12	112.48	9725400.0
2004-03-29 16:00:00	SPY	ETF	112.47	112.65	112.45	112.5	2518700.0
2004-03-29 17:00:00	SPY	ETF	112.51	112.54	112.47	112.5	487100.0
2004-03-29 18:00:00	SPY	ETF	112.48	112.51	112.46	112.51	1000.0
2004-03-29 19:00:00	SPY	ETF	112.48	112.48	112.48	112.48	1400.0
2004-03-29 08:00:00	QQQ	ETF	35.53	35.57	35.5	35.51	170100.0
2004-03-29 09:00:00	QQQ	ETF	35.51	35.8	35.5	35.75	15612300.0
2004-03-29 10:00:00	QQQ	ETF	35.751	35.92	35.74	35.87	19981900.0
2004-03-29 11:00:00	QQQ	ETF	35.87	35.95	35.85	35.92	12301100.0
2004-03-29 12:00:00	QQQ	ETF	35.92	35.96	35.85	35.87	7250300.0
2004-03-29 13:00:00	QQQ	ETF	35.86	35.88	35.79	35.877	6422300.0
2004-03-29 14:00:00	QQQ	ETF	35.878	35.92	35.72	35.83	11126500.0
2004-03-29 15:00:00	QQQ	ETF	35.83	35.91	35.61	35.85	21610500.0
2004-03-29 16:00:00	QQQ	ETF	35.85	35.89	35.78	35.82	5004600.0
2004-03-29 17:00:00	QQQ	ETF	35.82	35.831	35.8	35.8	60300.0
2004-03-29 18:00:00	QQQ	ETF	35.81	35.831	35.81	35.81	40000.0
2004-03-29 19:00:00	QQQ	ETF	35.81	35.81	35.78	35.78	14500.0
2004-03-29 08:00:00	IWM	ETF	57.6	57.6	57.485	57.485	17200.0
2004-03-29 09:00:00	IWM	ETF	57.48	57.905	57.46	57.82	1487800.0
2004-03-29 10:00:00	IWM	ETF	57.825	58.21	57.825	58.165	2839200.0
2004-03-29 11:00:00	IWM	ETF	58.18	58.225	58.09	58.135	1356200.0
2004-03-29 12:00:00	IWM	ETF	58.14	58.185	58.03	58.07	522200.0
2004-03-29 13:00:00	IWM	ETF	58.075	58.115	58.0	58.07	643800.0
2004-03-29 14:00:00	IWM	ETF	58.07	58.15	57.9	58.075	1175400.0
2004-03-29 15:00:00	IWM	ETF	58.1	58.125	57.545	58.125	4293600.0
2004-03-29 16:00:00	IWM	ETF	58.125	58.25	58.015	58.14	2141400.0
2004-03-29 17:00:00	IWM	ETF	58.15	58.16	58.125	58.125	5200.0
2004-03-29 08:00:00	DIA	ETF	102.86	102.86	102.76	102.8	8300.0
2004-03-29 09:00:00	DIA	ETF	102.79	103.2	102.79	103.1	1098400.0
2004-03-29 10:00:00	DIA	ETF	103.13	103.54	103.08	103.47	1408900.0
2004-03-29 11:00:00	DIA	ETF	103.47	103.59	103.41	103.56	584900.0
2004-03-29 12:00:00	DIA	ETF	103.57	103.62	103.36	103.44	707100.0
2004-03-29 13:00:00	DIA	ETF	103.48	103.5	103.31	103.49	194300.0
2004-03-29 14:00:00	DIA	ETF	103.49	103.62	103.33	103.55	374200.0
2004-03-29 15:00:00	DIA	ETF	103.55	103.61	103.12	103.39	1529400.0
2004-03-29 16:00:00	DIA	ETF	103.37	103.55	103.36	103.46	90600.0
2004-03-29 17:00:00	DIA	ETF	103.5	103.5	103.5	103.5	100.0
2004-03-29 18:00:00	DIA	ETF	103.45	103.45	103.45	103.45	100.0
2004-03-29 09:00:00	TLT	ETF	89.23	89.32	89.05	89.13	531700.0
2004-03-29 10:00:00	TLT	ETF	89.12	89.23	89.05	89.05	875800.0
2004-03-29 11:00:00	TLT	ETF	89.04	89.11	88.9	89.11	364300.0
2004-03-29 12:00:00	TLT	ETF	89.12	89.22	89.03	89.06	145400.0
2004-03-29 13:00:00	TLT	ETF	89.06	89.17	89.02	89.03	23000.0

> showing 50 of 692 rows — these rows as CSV

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