PREVIEW / etf_1hour / 2002-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-03-19.parquet
  size:    14 KB
  rows:    317

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
2002-03-19 09:00:00	SPY	ETF	117.3	117.39	117.01	117.2	1691600.0
2002-03-19 10:00:00	SPY	ETF	117.15	117.3	116.93	117.12	1819600.0
2002-03-19 11:00:00	SPY	ETF	117.13	117.43	116.96	117.41	1760200.0
2002-03-19 12:00:00	SPY	ETF	117.43	117.6	117.33	117.43	1231700.0
2002-03-19 13:00:00	SPY	ETF	117.4	117.73	117.34	117.61	1452100.0
2002-03-19 14:00:00	SPY	ETF	117.62	117.74	116.9	117.4	4951200.0
2002-03-19 15:00:00	SPY	ETF	117.39	117.48	116.82	117.25	2857300.0
2002-03-19 16:00:00	SPY	ETF	117.34	117.6	117.19	117.36	862300.0
2002-03-19 18:00:00	SPY	ETF	117.49	117.54	117.42	117.54	1600.0
2002-03-19 09:00:00	QQQ	ETF	37.6	37.65	37.33	37.52	6156600.0
2002-03-19 10:00:00	QQQ	ETF	37.52	37.72	37.48	37.6	9841800.0
2002-03-19 11:00:00	QQQ	ETF	37.59	37.73	37.52	37.71	4221300.0
2002-03-19 12:00:00	QQQ	ETF	37.72	37.78	37.6	37.62	3578600.0
2002-03-19 13:00:00	QQQ	ETF	37.62	37.77	37.6	37.72	2028100.0
2002-03-19 14:00:00	QQQ	ETF	37.72	37.88	37.34	37.51	18166100.0
2002-03-19 15:00:00	QQQ	ETF	37.52	37.59	37.22	37.45	11572100.0
2002-03-19 16:00:00	QQQ	ETF	37.44	37.47	37.37	37.45	1110400.0
2002-03-19 17:00:00	QQQ	ETF	37.42	37.52	37.42	37.45	45900.0
2002-03-19 18:00:00	QQQ	ETF	37.45	37.52	37.44	37.5	13100.0
2002-03-19 09:00:00	IWM	ETF	50.15	50.215	49.95	50.02	39800.0
2002-03-19 10:00:00	IWM	ETF	50.05	50.13	50.025	50.1	49200.0
2002-03-19 11:00:00	IWM	ETF	50.115	50.17	50.04	50.155	24400.0
2002-03-19 12:00:00	IWM	ETF	50.17	50.27	50.075	50.24	77200.0
2002-03-19 13:00:00	IWM	ETF	50.225	50.29	50.165	50.21	65400.0
2002-03-19 14:00:00	IWM	ETF	50.28	50.325	50.005	50.25	56400.0
2002-03-19 15:00:00	IWM	ETF	50.29	50.29	50.045	50.235	254200.0
2002-03-19 16:00:00	IWM	ETF	50.225	50.255	50.225	50.255	7600.0
2002-03-19 17:00:00	IWM	ETF	50.255	50.255	50.255	50.255	1000.0
2002-03-19 09:00:00	DIA	ETF	106.4	106.5	106.15	106.36	693700.0
2002-03-19 10:00:00	DIA	ETF	106.36	106.47	106.17	106.33	2324800.0
2002-03-19 11:00:00	DIA	ETF	106.35	106.55	106.17	106.54	687400.0
2002-03-19 12:00:00	DIA	ETF	106.55	106.77	106.51	106.6	1025800.0
2002-03-19 13:00:00	DIA	ETF	106.68	106.85	106.54	106.78	837300.0
2002-03-19 14:00:00	DIA	ETF	106.74	106.8	106.0	106.48	2433800.0
2002-03-19 15:00:00	DIA	ETF	106.44	106.5	106.0	106.37	961000.0
2002-03-19 16:00:00	DIA	ETF	106.36	106.7	106.36	106.7	92800.0
2002-03-19 17:00:00	DIA	ETF	106.7	106.7	106.7	106.7	100.0

> showing 37 of 317 rows — these rows as CSV

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