PREVIEW / etf_1hour / 2003-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-31.parquet
  size:    18 KB
  rows:    461

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-31 08:00:00	SPY	ETF	105.3	105.55	105.3	105.43	56800.0
2003-10-31 09:00:00	SPY	ETF	105.4	105.71	105.38	105.58	3793200.0
2003-10-31 10:00:00	SPY	ETF	105.59	105.74	105.22	105.54	6726400.0
2003-10-31 11:00:00	SPY	ETF	105.54	105.57	105.37	105.53	1977400.0
2003-10-31 12:00:00	SPY	ETF	105.52	105.65	105.41	105.48	869500.0
2003-10-31 13:00:00	SPY	ETF	105.5	105.57	105.26	105.33	1141200.0
2003-10-31 14:00:00	SPY	ETF	105.34	105.7	105.34	105.39	1629400.0
2003-10-31 15:00:00	SPY	ETF	105.41	105.69	105.37	105.42	3466800.0
2003-10-31 16:00:00	SPY	ETF	105.42	105.5	105.25	105.3	2100700.0
2003-10-31 17:00:00	SPY	ETF	105.25	105.3	105.25	105.3	7500.0
2003-10-31 18:00:00	SPY	ETF	105.33	105.33	105.33	105.33	400.0
2003-10-31 19:00:00	SPY	ETF	105.35	105.35	105.35	105.35	600.0
2003-10-31 08:00:00	QQQ	ETF	35.36	35.53	35.36	35.46	173400.0
2003-10-31 09:00:00	QQQ	ETF	35.46	35.5	35.27	35.392	6607500.0
2003-10-31 10:00:00	QQQ	ETF	35.38	35.47	35.06	35.27	12403000.0
2003-10-31 11:00:00	QQQ	ETF	35.261	35.28	35.16	35.27	4190600.0
2003-10-31 12:00:00	QQQ	ETF	35.27	35.33	35.13	35.21	4001000.0
2003-10-31 13:00:00	QQQ	ETF	35.21	35.25	35.1	35.1	3969200.0
2003-10-31 14:00:00	QQQ	ETF	35.12	35.32	35.1	35.2	6609000.0
2003-10-31 15:00:00	QQQ	ETF	35.208	35.37	35.15	35.18	9285700.0
2003-10-31 16:00:00	QQQ	ETF	35.16	35.26	35.14	35.18	2875200.0
2003-10-31 17:00:00	QQQ	ETF	35.16	35.2	35.114	35.2	32000.0
2003-10-31 18:00:00	QQQ	ETF	35.2	35.21	35.18	35.21	13500.0
2003-10-31 19:00:00	QQQ	ETF	35.2	35.2	35.16	35.2	4500.0
2003-10-31 09:00:00	IWM	ETF	53.135	53.28	53.07	53.135	822400.0
2003-10-31 10:00:00	IWM	ETF	53.138	53.253	52.825	52.98	691000.0
2003-10-31 11:00:00	IWM	ETF	52.99	53.0	52.875	52.985	294800.0
2003-10-31 12:00:00	IWM	ETF	52.985	53.125	52.76	52.825	442600.0
2003-10-31 13:00:00	IWM	ETF	52.84	52.915	52.775	52.79	312800.0
2003-10-31 14:00:00	IWM	ETF	52.8	52.945	52.795	52.855	267400.0
2003-10-31 15:00:00	IWM	ETF	52.82	52.985	52.718	52.727	1349800.0
2003-10-31 16:00:00	IWM	ETF	52.72	52.765	52.66	52.66	88800.0
2003-10-31 17:00:00	IWM	ETF	52.765	52.765	52.765	52.765	400.0
2003-10-31 08:00:00	DIA	ETF	98.39	98.39	98.17	98.27	3900.0
2003-10-31 09:00:00	DIA	ETF	98.24	98.53	98.23	98.45	767300.0
2003-10-31 10:00:00	DIA	ETF	98.46	98.55	98.09	98.35	515800.0
2003-10-31 11:00:00	DIA	ETF	98.35	98.37	98.18	98.28	534100.0
2003-10-31 12:00:00	DIA	ETF	98.32	98.4	98.18	98.32	260300.0
2003-10-31 13:00:00	DIA	ETF	98.29	98.34	98.11	98.17	130800.0
2003-10-31 14:00:00	DIA	ETF	98.203	98.4	98.13	98.15	480300.0
2003-10-31 15:00:00	DIA	ETF	98.14	98.38	98.14	98.22	682100.0
2003-10-31 16:00:00	DIA	ETF	98.17	98.21	97.97	98.05	265600.0
2003-10-31 17:00:00	DIA	ETF	98.02	98.02	98.0	98.0	3700.0
2003-10-31 09:00:00	TLT	ETF	84.73	84.88	84.58	84.88	26400.0
2003-10-31 10:00:00	TLT	ETF	84.88	85.1	84.75	85.05	167900.0
2003-10-31 11:00:00	TLT	ETF	85.09	85.22	85.06	85.061	37500.0
2003-10-31 12:00:00	TLT	ETF	85.09	85.09	84.89	85.03	356200.0
2003-10-31 13:00:00	TLT	ETF	84.91	85.01	84.79	84.98	20600.0
2003-10-31 14:00:00	TLT	ETF	84.98	85.14	84.92	85.13	65700.0
2003-10-31 15:00:00	TLT	ETF	85.1	85.2	85.04	85.11	163700.0

> showing 50 of 461 rows — these rows as CSV

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