PREVIEW / etf_1hour / 2003-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-16.parquet
  size:    18 KB
  rows:    445

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-16 08:00:00	SPY	ETF	104.98	105.1	104.74	104.74	241400.0
2003-10-16 09:00:00	SPY	ETF	104.76	105.08	104.65	104.9	3851100.0
2003-10-16 10:00:00	SPY	ETF	104.92	105.23	104.81	105.05	5255900.0
2003-10-16 11:00:00	SPY	ETF	105.06	105.17	104.85	105.13	2428500.0
2003-10-16 12:00:00	SPY	ETF	105.13	105.65	105.05	105.613	5461900.0
2003-10-16 13:00:00	SPY	ETF	105.6	105.73	105.31	105.37	2890800.0
2003-10-16 14:00:00	SPY	ETF	105.38	105.51	104.96	105.136	3025100.0
2003-10-16 15:00:00	SPY	ETF	105.1	105.44	104.85	105.33	7022000.0
2003-10-16 16:00:00	SPY	ETF	105.31	105.49	105.18	105.23	1035100.0
2003-10-16 17:00:00	SPY	ETF	105.28	105.32	105.25	105.28	50500.0
2003-10-16 18:00:00	SPY	ETF	105.26	105.26	105.26	105.26	200.0
2003-10-16 19:00:00	SPY	ETF	105.3	105.3	105.3	105.3	500.0
2003-10-16 08:00:00	QQQ	ETF	35.12	35.21	35.06	35.09	176900.0
2003-10-16 09:00:00	QQQ	ETF	35.09	35.23	35.06	35.154	9719800.0
2003-10-16 10:00:00	QQQ	ETF	35.16	35.37	35.12	35.23	10739100.0
2003-10-16 11:00:00	QQQ	ETF	35.23	35.25	35.11	35.23	5855200.0
2003-10-16 12:00:00	QQQ	ETF	35.23	35.5	35.19	35.48	10446700.0
2003-10-16 13:00:00	QQQ	ETF	35.48	35.52	35.3	35.344	7450500.0
2003-10-16 14:00:00	QQQ	ETF	35.343	35.43	35.23	35.33	6139200.0
2003-10-16 15:00:00	QQQ	ETF	35.32	35.48	35.2	35.448	10891700.0
2003-10-16 16:00:00	QQQ	ETF	35.448	35.5	35.26	35.32	6934000.0
2003-10-16 17:00:00	QQQ	ETF	35.32	35.38	35.31	35.34	818300.0
2003-10-16 18:00:00	QQQ	ETF	35.35	35.37	35.32	35.33	24100.0
2003-10-16 19:00:00	QQQ	ETF	35.34	35.35	35.33	35.35	26800.0
2003-10-16 08:00:00	IWM	ETF	52.395	52.395	52.395	52.395	200.0
2003-10-16 09:00:00	IWM	ETF	52.35	52.66	52.3	52.475	534200.0
2003-10-16 10:00:00	IWM	ETF	52.505	52.91	52.46	52.65	728800.0
2003-10-16 11:00:00	IWM	ETF	52.675	52.75	52.6	52.75	600600.0
2003-10-16 12:00:00	IWM	ETF	52.8	52.96	52.63	52.96	421200.0
2003-10-16 13:00:00	IWM	ETF	52.94	52.965	52.815	52.82	333600.0
2003-10-16 14:00:00	IWM	ETF	52.82	52.895	52.6	52.7	284800.0
2003-10-16 15:00:00	IWM	ETF	52.725	52.88	52.625	52.835	387200.0
2003-10-16 16:00:00	IWM	ETF	52.83	52.88	52.81	52.875	458800.0
2003-10-16 17:00:00	IWM	ETF	52.736	52.74	52.736	52.74	6000.0
2003-10-16 08:00:00	DIA	ETF	98.08	98.2	97.78	97.78	56000.0
2003-10-16 09:00:00	DIA	ETF	97.82	97.82	97.55	97.7	983300.0
2003-10-16 10:00:00	DIA	ETF	97.69	97.95	97.55	97.75	863200.0
2003-10-16 11:00:00	DIA	ETF	97.77	97.84	97.6	97.84	804400.0
2003-10-16 12:00:00	DIA	ETF	97.83	98.39	97.82	98.39	1092200.0
2003-10-16 13:00:00	DIA	ETF	98.4	98.5	98.05	98.11	1046500.0
2003-10-16 14:00:00	DIA	ETF	98.13	98.23	97.8	97.89	691300.0
2003-10-16 15:00:00	DIA	ETF	97.89	98.22	97.68	98.11	1294200.0
2003-10-16 16:00:00	DIA	ETF	98.07	98.29	98.02	98.03	111900.0
2003-10-16 17:00:00	DIA	ETF	98.15	98.15	98.15	98.15	400.0
2003-10-16 09:00:00	TLT	ETF	83.48	83.63	83.48	83.63	25100.0
2003-10-16 10:00:00	TLT	ETF	83.62	83.74	83.46	83.66	35400.0
2003-10-16 11:00:00	TLT	ETF	83.67	83.77	83.67	83.71	23300.0
2003-10-16 12:00:00	TLT	ETF	83.71	83.71	82.75	82.88	255200.0
2003-10-16 13:00:00	TLT	ETF	82.89	83.19	82.78	83.19	77800.0
2003-10-16 14:00:00	TLT	ETF	83.06	83.1	82.8	82.92	52700.0

> showing 50 of 445 rows — these rows as CSV

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