PREVIEW / etf_1hour / 2003-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-07.parquet
  size:    16 KB
  rows:    383

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-07 08:00:00	SPY	ETF	92.84	92.85	92.6	92.85	21700.0
2003-01-07 09:00:00	SPY	ETF	92.85	92.98	92.57	92.86	3097100.0
2003-01-07 10:00:00	SPY	ETF	92.85	93.13	92.2	92.3	9057400.0
2003-01-07 11:00:00	SPY	ETF	92.33	93.03	92.27	92.9	4745300.0
2003-01-07 12:00:00	SPY	ETF	92.9	93.0	92.61	92.66	2139600.0
2003-01-07 13:00:00	SPY	ETF	92.67	93.14	92.45	93.12	4723900.0
2003-01-07 14:00:00	SPY	ETF	93.12	93.37	92.67	92.75	4773900.0
2003-01-07 15:00:00	SPY	ETF	92.79	93.07	92.29	92.56	5233800.0
2003-01-07 16:00:00	SPY	ETF	92.57	92.8	92.46	92.67	1425700.0
2003-01-07 17:00:00	SPY	ETF	92.67	92.72	92.65	92.66	8600.0
2003-01-07 18:00:00	SPY	ETF	92.69	92.69	92.59	92.59	7000.0
2003-01-07 19:00:00	SPY	ETF	92.65	92.66	92.6	92.6	1100.0
2003-01-07 08:00:00	QQQ	ETF	26.38	26.4	26.26	26.34	51200.0
2003-01-07 09:00:00	QQQ	ETF	26.38	26.53	26.3	26.49	9521900.0
2003-01-07 10:00:00	QQQ	ETF	26.52	26.8	26.25	26.32	23467800.0
2003-01-07 11:00:00	QQQ	ETF	26.32	26.69	26.3	26.64	8324900.0
2003-01-07 12:00:00	QQQ	ETF	26.63	26.66	26.51	26.55	5559900.0
2003-01-07 13:00:00	QQQ	ETF	26.56	26.83	26.45	26.83	10211700.0
2003-01-07 14:00:00	QQQ	ETF	26.8	26.93	26.57	26.65	10490500.0
2003-01-07 15:00:00	QQQ	ETF	26.65	26.81	26.45	26.64	11564400.0
2003-01-07 16:00:00	QQQ	ETF	26.61	26.69	26.51	26.62	1868700.0
2003-01-07 17:00:00	QQQ	ETF	26.65	26.67	26.6	26.62	62400.0
2003-01-07 18:00:00	QQQ	ETF	26.63	26.65	26.6	26.62	31500.0
2003-01-07 19:00:00	QQQ	ETF	26.62	26.65	26.6	26.6	5500.0
2003-01-07 09:00:00	IWM	ETF	39.35	39.44	39.25	39.35	314200.0
2003-01-07 10:00:00	IWM	ETF	39.405	39.45	38.82	38.82	927000.0
2003-01-07 11:00:00	IWM	ETF	38.82	39.155	38.82	39.125	307800.0
2003-01-07 12:00:00	IWM	ETF	39.12	39.175	39.065	39.105	276800.0
2003-01-07 13:00:00	IWM	ETF	39.105	39.305	39.005	39.3	347600.0
2003-01-07 14:00:00	IWM	ETF	39.3	39.38	39.185	39.215	268600.0
2003-01-07 15:00:00	IWM	ETF	39.235	39.295	39.065	39.13	382800.0
2003-01-07 16:00:00	IWM	ETF	39.125	39.135	39.09	39.09	16400.0
2003-01-07 17:00:00	IWM	ETF	39.195	39.195	39.195	39.195	25200.0
2003-01-07 08:00:00	DIA	ETF	87.6	87.65	87.4	87.65	1600.0
2003-01-07 09:00:00	DIA	ETF	87.68	87.78	87.46	87.72	563700.0
2003-01-07 10:00:00	DIA	ETF	87.7	88.05	87.2	87.33	1559900.0
2003-01-07 11:00:00	DIA	ETF	87.34	87.98	87.3	87.9	848300.0
2003-01-07 12:00:00	DIA	ETF	87.89	87.95	87.6	87.65	513200.0
2003-01-07 13:00:00	DIA	ETF	87.64	88.0	87.45	87.98	751900.0
2003-01-07 14:00:00	DIA	ETF	87.98	88.19	87.62	87.66	906100.0
2003-01-07 15:00:00	DIA	ETF	87.69	87.9	87.3	87.53	796700.0
2003-01-07 16:00:00	DIA	ETF	87.52	87.79	87.45	87.67	147500.0
2003-01-07 17:00:00	DIA	ETF	87.65	87.73	87.58	87.68	5900.0
2003-01-07 18:00:00	DIA	ETF	87.68	87.75	87.68	87.75	2400.0
2003-01-07 09:00:00	TLT	ETF	86.19	86.23	86.17	86.23	1500.0
2003-01-07 10:00:00	TLT	ETF	86.33	86.68	86.28	86.62	8500.0
2003-01-07 11:00:00	TLT	ETF	86.75	86.75	86.54	86.55	3600.0
2003-01-07 12:00:00	TLT	ETF	86.56	86.74	86.56	86.66	5200.0
2003-01-07 13:00:00	TLT	ETF	86.64	86.64	86.5	86.53	6400.0
2003-01-07 14:00:00	TLT	ETF	86.52	86.55	86.37	86.52	20900.0

> showing 50 of 383 rows — these rows as CSV

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