PREVIEW / etf_1hour / 2003-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-29.parquet
  size:    17 KB
  rows:    399

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-07-29 08:00:00	SPY	ETF	100.2	100.28	100.09	100.2	19900.0
2003-07-29 09:00:00	SPY	ETF	100.17	100.27	99.72	99.75	5068400.0
2003-07-29 10:00:00	SPY	ETF	99.76	99.76	98.68	99.1	14358900.0
2003-07-29 11:00:00	SPY	ETF	99.07	100.14	98.97	99.99	6959500.0
2003-07-29 12:00:00	SPY	ETF	99.975	100.0	99.65	99.86	8008800.0
2003-07-29 13:00:00	SPY	ETF	99.85	100.26	99.73	99.87	3081100.0
2003-07-29 14:00:00	SPY	ETF	99.86	100.09	99.23	99.27	5250100.0
2003-07-29 15:00:00	SPY	ETF	99.27	99.47	99.09	99.319	4287000.0
2003-07-29 16:00:00	SPY	ETF	99.329	99.46	99.26	99.44	1683500.0
2003-07-29 17:00:00	SPY	ETF	99.44	99.44	99.35	99.36	18400.0
2003-07-29 18:00:00	SPY	ETF	99.36	99.37	99.27	99.37	97000.0
2003-07-29 19:00:00	SPY	ETF	99.35	99.4	99.35	99.4	700.0
2003-07-29 08:00:00	QQQ	ETF	31.96	31.98	31.93	31.96	54000.0
2003-07-29 09:00:00	QQQ	ETF	31.97	32.02	31.72	31.81	6145400.0
2003-07-29 10:00:00	QQQ	ETF	31.81	31.82	31.23	31.41	20945300.0
2003-07-29 11:00:00	QQQ	ETF	31.38	31.88	31.36	31.77	15371100.0
2003-07-29 12:00:00	QQQ	ETF	31.76	31.81	31.65	31.75	7369000.0
2003-07-29 13:00:00	QQQ	ETF	31.76	31.97	31.7	31.763	6236100.0
2003-07-29 14:00:00	QQQ	ETF	31.78	31.88	31.62	31.63	6310600.0
2003-07-29 15:00:00	QQQ	ETF	31.63	31.74	31.54	31.66	9924900.0
2003-07-29 16:00:00	QQQ	ETF	31.654	31.7	31.61	31.66	3430700.0
2003-07-29 17:00:00	QQQ	ETF	31.65	31.65	31.63	31.64	59300.0
2003-07-29 18:00:00	QQQ	ETF	31.628	31.65	31.621	31.65	36000.0
2003-07-29 19:00:00	QQQ	ETF	31.65	31.67	31.64	31.65	21400.0
2003-07-29 09:00:00	IWM	ETF	47.475	47.625	47.175	47.2	530000.0
2003-07-29 10:00:00	IWM	ETF	47.2	47.2	46.8	46.945	970600.0
2003-07-29 11:00:00	IWM	ETF	46.93	47.26	46.895	47.235	286000.0
2003-07-29 12:00:00	IWM	ETF	47.215	47.22	47.025	47.175	1124200.0
2003-07-29 13:00:00	IWM	ETF	47.18	47.365	47.105	47.315	306200.0
2003-07-29 14:00:00	IWM	ETF	47.311	47.375	47.165	47.205	596200.0
2003-07-29 15:00:00	IWM	ETF	47.17	47.32	47.095	47.3	774000.0
2003-07-29 16:00:00	IWM	ETF	47.35	47.425	47.35	47.425	75000.0
2003-07-29 08:00:00	DIA	ETF	92.88	92.92	92.87	92.87	14400.0
2003-07-29 09:00:00	DIA	ETF	93.0	93.03	92.57	92.6	407400.0
2003-07-29 10:00:00	DIA	ETF	92.6	92.6	91.74	92.01	1822900.0
2003-07-29 11:00:00	DIA	ETF	92.0	92.78	91.913	92.67	739900.0
2003-07-29 12:00:00	DIA	ETF	92.68	92.69	92.38	92.6	495300.0
2003-07-29 13:00:00	DIA	ETF	92.6	92.97	92.52	92.67	586200.0
2003-07-29 14:00:00	DIA	ETF	92.65	92.83	92.133	92.19	672100.0
2003-07-29 15:00:00	DIA	ETF	92.17	92.34	92.02	92.17	729800.0
2003-07-29 16:00:00	DIA	ETF	92.15	92.3	92.14	92.29	119800.0
2003-07-29 17:00:00	DIA	ETF	92.28	92.28	92.28	92.28	100.0
2003-07-29 09:00:00	TLT	ETF	84.18	84.68	84.15	84.68	200600.0
2003-07-29 10:00:00	TLT	ETF	84.71	85.35	84.52	84.59	548400.0
2003-07-29 11:00:00	TLT	ETF	84.55	84.6	84.3	84.3	178600.0
2003-07-29 12:00:00	TLT	ETF	84.35	84.35	83.85	83.85	246100.0
2003-07-29 13:00:00	TLT	ETF	83.95	83.99	83.75	83.93	257800.0
2003-07-29 14:00:00	TLT	ETF	83.85	83.87	83.52	83.63	255800.0
2003-07-29 15:00:00	TLT	ETF	83.63	83.75	83.35	83.36	319000.0
2003-07-29 16:00:00	TLT	ETF	83.36	85.28	83.26	83.26	71700.0

> showing 50 of 399 rows — these rows as CSV

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