PREVIEW / etf_1hour / 2003-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-10.parquet
  size:    16 KB
  rows:    385

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-01-10 08:00:00	SPY	ETF	93.2	93.39	92.0	92.03	309100.0
2003-01-10 09:00:00	SPY	ETF	92.0	92.68	91.8	92.62	7013200.0
2003-01-10 10:00:00	SPY	ETF	92.63	93.5	92.53	93.43	9079700.0
2003-01-10 11:00:00	SPY	ETF	93.44	93.64	92.97	93.28	4423600.0
2003-01-10 12:00:00	SPY	ETF	93.21	93.25	92.48	92.66	2822000.0
2003-01-10 13:00:00	SPY	ETF	92.65	93.04	92.57	92.81	2517100.0
2003-01-10 14:00:00	SPY	ETF	92.82	93.24	92.69	93.13	2812100.0
2003-01-10 15:00:00	SPY	ETF	93.15	93.3	92.65	93.03	3822900.0
2003-01-10 16:00:00	SPY	ETF	92.97	93.3	92.84	93.3	1652900.0
2003-01-10 17:00:00	SPY	ETF	93.23	93.24	93.19	93.19	1200.0
2003-01-10 18:00:00	SPY	ETF	93.17	93.25	93.16	93.25	1500.0
2003-01-10 19:00:00	SPY	ETF	93.28	93.28	93.28	93.28	600.0
2003-01-10 08:00:00	QQQ	ETF	26.9	27.02	26.28	26.32	531800.0
2003-01-10 09:00:00	QQQ	ETF	26.33	26.72	26.22	26.7	14517500.0
2003-01-10 10:00:00	QQQ	ETF	26.7	27.19	26.65	27.18	17532100.0
2003-01-10 11:00:00	QQQ	ETF	27.18	27.26	26.92	27.05	8995700.0
2003-01-10 12:00:00	QQQ	ETF	27.05	27.08	26.7	26.8	9561500.0
2003-01-10 13:00:00	QQQ	ETF	26.8	26.99	26.77	26.91	6487600.0
2003-01-10 14:00:00	QQQ	ETF	26.92	27.13	26.88	27.06	5951600.0
2003-01-10 15:00:00	QQQ	ETF	27.05	27.13	26.85	27.04	9137100.0
2003-01-10 16:00:00	QQQ	ETF	27.04	27.2	27.01	27.15	1828400.0
2003-01-10 17:00:00	QQQ	ETF	27.1	27.17	27.1	27.14	159200.0
2003-01-10 18:00:00	QQQ	ETF	27.13	27.16	27.13	27.14	20100.0
2003-01-10 19:00:00	QQQ	ETF	27.16	27.17	27.13	27.17	13600.0
2003-01-10 09:00:00	IWM	ETF	38.915	39.31	38.85	39.29	281400.0
2003-01-10 10:00:00	IWM	ETF	39.335	39.59	39.29	39.56	707000.0
2003-01-10 11:00:00	IWM	ETF	39.625	39.625	39.425	39.48	660800.0
2003-01-10 12:00:00	IWM	ETF	39.455	39.48	39.175	39.21	222400.0
2003-01-10 13:00:00	IWM	ETF	39.2	39.37	39.175	39.305	129000.0
2003-01-10 14:00:00	IWM	ETF	39.325	39.505	39.325	39.505	222400.0
2003-01-10 15:00:00	IWM	ETF	39.48	39.56	39.375	39.395	310600.0
2003-01-10 16:00:00	IWM	ETF	39.445	39.445	39.35	39.4	36600.0
2003-01-10 08:00:00	DIA	ETF	88.03	88.03	86.93	86.97	15600.0
2003-01-10 09:00:00	DIA	ETF	86.96	87.62	86.73	87.56	1218000.0
2003-01-10 10:00:00	DIA	ETF	87.54	88.25	87.41	88.22	1906000.0
2003-01-10 11:00:00	DIA	ETF	88.24	88.38	87.7	88.06	1345200.0
2003-01-10 12:00:00	DIA	ETF	88.07	88.07	87.3	87.53	513300.0
2003-01-10 13:00:00	DIA	ETF	87.54	87.92	87.45	87.7	348500.0
2003-01-10 14:00:00	DIA	ETF	87.72	88.09	87.57	88.04	474800.0
2003-01-10 15:00:00	DIA	ETF	88.04	88.15	87.59	87.92	871600.0
2003-01-10 16:00:00	DIA	ETF	87.87	88.1	87.84	88.05	130800.0
2003-01-10 17:00:00	DIA	ETF	88.01	88.05	88.0	88.05	1100.0
2003-01-10 18:00:00	DIA	ETF	88.05	88.05	88.05	88.05	600.0
2003-01-10 19:00:00	DIA	ETF	88.1	88.1	88.1	88.1	1000.0
2003-01-10 09:00:00	TLT	ETF	85.92	85.92	85.5	85.5	79200.0
2003-01-10 10:00:00	TLT	ETF	85.5	85.57	85.12	85.22	18900.0
2003-01-10 11:00:00	TLT	ETF	85.25	85.5	85.2	85.49	19800.0
2003-01-10 12:00:00	TLT	ETF	85.37	85.6	85.3	85.6	11800.0
2003-01-10 13:00:00	TLT	ETF	85.54	85.65	85.45	85.63	800.0
2003-01-10 14:00:00	TLT	ETF	85.41	85.41	85.41	85.41	1000.0

> showing 50 of 385 rows — these rows as CSV

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