PREVIEW / etf_1hour / 2003-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-20.parquet
  size:    18 KB
  rows:    463

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-10-20 08:00:00	SPY	ETF	104.46	104.52	104.33	104.5	27200.0
2003-10-20 09:00:00	SPY	ETF	104.49	104.66	104.278	104.59	3722900.0
2003-10-20 10:00:00	SPY	ETF	104.63	104.68	103.94	104.22	7092900.0
2003-10-20 11:00:00	SPY	ETF	104.21	104.44	104.1	104.38	2280700.0
2003-10-20 12:00:00	SPY	ETF	104.39	104.54	104.34	104.47	1386700.0
2003-10-20 13:00:00	SPY	ETF	104.44	104.62	104.22	104.3	1816800.0
2003-10-20 14:00:00	SPY	ETF	104.32	104.43	104.14	104.378	3356000.0
2003-10-20 15:00:00	SPY	ETF	104.37	104.825	104.37	104.8	4676500.0
2003-10-20 16:00:00	SPY	ETF	104.78	105.38	104.73	105.32	2114500.0
2003-10-20 17:00:00	SPY	ETF	105.3	105.43	105.21	105.35	345500.0
2003-10-20 18:00:00	SPY	ETF	105.33	105.374	105.32	105.33	14600.0
2003-10-20 19:00:00	SPY	ETF	105.3	105.33	105.25	105.26	2800.0
2003-10-20 08:00:00	QQQ	ETF	34.73	34.73	34.6	34.68	336300.0
2003-10-20 09:00:00	QQQ	ETF	34.66	34.84	34.64	34.81	10102800.0
2003-10-20 10:00:00	QQQ	ETF	34.82	34.86	34.5	34.67	14463800.0
2003-10-20 11:00:00	QQQ	ETF	34.68	34.81	34.61	34.79	6706000.0
2003-10-20 12:00:00	QQQ	ETF	34.78	34.98	34.75	34.94	8825900.0
2003-10-20 13:00:00	QQQ	ETF	34.936	35.0	34.71	34.8	7177100.0
2003-10-20 14:00:00	QQQ	ETF	34.8	34.9	34.73	34.83	5350600.0
2003-10-20 15:00:00	QQQ	ETF	34.82	35.02	34.82	34.987	11259200.0
2003-10-20 16:00:00	QQQ	ETF	34.98	35.31	34.96	35.31	8578500.0
2003-10-20 17:00:00	QQQ	ETF	35.31	35.384	35.28	35.31	1549700.0
2003-10-20 18:00:00	QQQ	ETF	35.32	35.35	35.3	35.33	86600.0
2003-10-20 19:00:00	QQQ	ETF	35.3	35.33	35.28	35.28	25200.0
2003-10-20 08:00:00	IWM	ETF	51.89	51.89	51.89	51.89	800.0
2003-10-20 09:00:00	IWM	ETF	51.97	52.275	51.92	52.25	977400.0
2003-10-20 10:00:00	IWM	ETF	52.23	52.255	51.765	51.895	1008800.0
2003-10-20 11:00:00	IWM	ETF	51.9	51.98	51.755	51.98	1109000.0
2003-10-20 12:00:00	IWM	ETF	51.98	52.065	51.925	52.005	560200.0
2003-10-20 13:00:00	IWM	ETF	51.9875	52.025	51.8265	51.885	463600.0
2003-10-20 14:00:00	IWM	ETF	51.89	51.95	51.775	51.89	554400.0
2003-10-20 15:00:00	IWM	ETF	51.91	52.065	51.865	52.015	533800.0
2003-10-20 16:00:00	IWM	ETF	52.04	52.2705	51.918	52.27	504600.0
2003-10-20 18:00:00	IWM	ETF	52.34	52.34	52.34	52.34	4000.0
2003-10-20 08:00:00	DIA	ETF	97.52	97.52	97.49	97.52	2000.0
2003-10-20 09:00:00	DIA	ETF	97.59	97.78	97.48	97.75	501300.0
2003-10-20 10:00:00	DIA	ETF	97.74	97.76	97.19	97.41	1140000.0
2003-10-20 11:00:00	DIA	ETF	97.42	97.63	97.31	97.55	598000.0
2003-10-20 12:00:00	DIA	ETF	97.57	97.66	97.5	97.56	285000.0
2003-10-20 13:00:00	DIA	ETF	97.57	97.72	97.36	97.44	271200.0
2003-10-20 14:00:00	DIA	ETF	97.43	97.58	97.32	97.52	315800.0
2003-10-20 15:00:00	DIA	ETF	97.52	97.85	97.51	97.83	700800.0
2003-10-20 16:00:00	DIA	ETF	97.83	98.23	97.76	98.2	343400.0
2003-10-20 17:00:00	DIA	ETF	98.29	98.43	98.25	98.3	8300.0
2003-10-20 18:00:00	DIA	ETF	98.3	98.3	98.21	98.28	2000.0
2003-10-20 19:00:00	DIA	ETF	98.2	98.2	98.2	98.2	300.0
2003-10-20 09:00:00	TLT	ETF	83.45	83.55	83.42	83.45	22600.0
2003-10-20 10:00:00	TLT	ETF	83.5	84.01	83.5	83.93	76800.0
2003-10-20 11:00:00	TLT	ETF	83.95	84.11	83.8	84.0	66600.0
2003-10-20 12:00:00	TLT	ETF	84.02	84.08	83.75	83.83	39700.0

> showing 50 of 463 rows — these rows as CSV

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