PREVIEW / etf_1hour / 2003-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-09.parquet
  size:    16 KB
  rows:    373

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-09 08:00:00	SPY	ETF	91.53	91.86	91.52	91.75	98900.0
2003-01-09 09:00:00	SPY	ETF	91.74	92.3	91.74	92.25	4224700.0
2003-01-09 10:00:00	SPY	ETF	92.3	92.98	92.26	92.94	7834800.0
2003-01-09 11:00:00	SPY	ETF	92.93	93.05	92.79	92.95	2843900.0
2003-01-09 12:00:00	SPY	ETF	92.94	93.01	92.67	92.76	2808800.0
2003-01-09 13:00:00	SPY	ETF	92.74	92.87	92.37	92.46	2866500.0
2003-01-09 14:00:00	SPY	ETF	92.48	92.9	92.4	92.76	2933500.0
2003-01-09 15:00:00	SPY	ETF	92.8	93.18	92.65	92.99	5642600.0
2003-01-09 16:00:00	SPY	ETF	93.0	93.04	92.72	92.89	2151300.0
2003-01-09 17:00:00	SPY	ETF	92.89	92.98	92.85	92.97	65600.0
2003-01-09 18:00:00	SPY	ETF	92.91	93.02	92.89	93.0	4700.0
2003-01-09 19:00:00	SPY	ETF	93.0	93.02	93.0	93.0	6100.0
2003-01-09 08:00:00	QQQ	ETF	26.03	26.28	26.03	26.2	169800.0
2003-01-09 09:00:00	QQQ	ETF	26.2	26.93	26.19	26.56	10419600.0
2003-01-09 10:00:00	QQQ	ETF	26.54	26.93	26.54	26.87	17524200.0
2003-01-09 11:00:00	QQQ	ETF	26.88	26.98	26.78	26.92	10778500.0
2003-01-09 12:00:00	QQQ	ETF	26.92	26.95	26.76	26.8	4689600.0
2003-01-09 13:00:00	QQQ	ETF	26.8	26.88	26.64	26.72	7680200.0
2003-01-09 14:00:00	QQQ	ETF	26.71	26.85	26.66	26.78	6325800.0
2003-01-09 15:00:00	QQQ	ETF	26.78	26.89	26.65	26.73	8579000.0
2003-01-09 16:00:00	QQQ	ETF	26.71	26.75	26.66	26.72	3285000.0
2003-01-09 17:00:00	QQQ	ETF	26.73	26.77	26.73	26.75	123000.0
2003-01-09 18:00:00	QQQ	ETF	26.77	26.79	26.73	26.75	24200.0
2003-01-09 19:00:00	QQQ	ETF	26.78	26.78	26.74	26.76	23000.0
2003-01-09 09:00:00	IWM	ETF	38.99	39.21	38.99	39.2	418800.0
2003-01-09 10:00:00	IWM	ETF	39.26	39.53	39.22	39.435	475400.0
2003-01-09 11:00:00	IWM	ETF	39.485	39.485	39.345	39.36	494800.0
2003-01-09 12:00:00	IWM	ETF	39.4	39.45	39.25	39.28	212800.0
2003-01-09 13:00:00	IWM	ETF	39.33	39.37	39.19	39.21	446200.0
2003-01-09 14:00:00	IWM	ETF	39.205	39.425	39.2	39.35	306200.0
2003-01-09 15:00:00	IWM	ETF	39.355	39.5	39.2	39.35	721600.0
2003-01-09 16:00:00	IWM	ETF	39.325	39.42	39.225	39.395	401600.0
2003-01-09 08:00:00	DIA	ETF	86.56	86.69	86.51	86.6	15300.0
2003-01-09 09:00:00	DIA	ETF	86.55	86.97	86.55	86.94	1043100.0
2003-01-09 10:00:00	DIA	ETF	86.86	87.65	86.86	87.57	2192800.0
2003-01-09 11:00:00	DIA	ETF	87.57	87.78	87.4	87.69	952800.0
2003-01-09 12:00:00	DIA	ETF	87.7	87.76	87.48	87.55	350800.0
2003-01-09 13:00:00	DIA	ETF	87.56	87.64	87.13	87.3	802300.0
2003-01-09 14:00:00	DIA	ETF	87.29	87.78	87.27	87.65	919300.0
2003-01-09 15:00:00	DIA	ETF	87.65	88.02	87.59	87.94	1545300.0
2003-01-09 16:00:00	DIA	ETF	87.91	87.96	87.7	87.8	151500.0
2003-01-09 17:00:00	DIA	ETF	87.82	87.82	87.82	87.82	600.0
2003-01-09 18:00:00	DIA	ETF	87.92	87.92	87.92	87.92	1000.0
2003-01-09 19:00:00	DIA	ETF	87.96	87.98	87.95	87.98	500.0
2003-01-09 09:00:00	TLT	ETF	86.17	86.17	85.9	86.0	30300.0
2003-01-09 10:00:00	TLT	ETF	85.9	85.92	85.43	85.55	75800.0
2003-01-09 11:00:00	TLT	ETF	85.45	85.52	85.02	85.19	23300.0
2003-01-09 12:00:00	TLT	ETF	85.17	85.47	85.17	85.45	52200.0
2003-01-09 13:00:00	TLT	ETF	85.42	85.55	85.4	85.53	33700.0
2003-01-09 14:00:00	TLT	ETF	85.53	85.53	85.3	85.44	12700.0

> showing 50 of 373 rows — these rows as CSV

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