PREVIEW / etf_1hour / 2003-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-19.parquet
  size:    19 KB
  rows:    483

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-11-19 08:00:00	SPY	ETF	104.05	104.2	104.05	104.08	124000.0
2003-11-19 09:00:00	SPY	ETF	104.07	104.27	103.92	104.0	4673400.0
2003-11-19 10:00:00	SPY	ETF	104.01	104.49	103.95	104.38	4875300.0
2003-11-19 11:00:00	SPY	ETF	104.38	104.58	104.27	104.31	2873700.0
2003-11-19 12:00:00	SPY	ETF	104.31	104.51	104.23	104.48	1355900.0
2003-11-19 13:00:00	SPY	ETF	104.48	104.62	104.25	104.47	2061800.0
2003-11-19 14:00:00	SPY	ETF	104.48	104.97	104.48	104.89	4784800.0
2003-11-19 15:00:00	SPY	ETF	104.89	105.01	104.69	104.85	3093100.0
2003-11-19 16:00:00	SPY	ETF	104.86	104.96	104.72	104.8	2170100.0
2003-11-19 17:00:00	SPY	ETF	104.8	104.89	104.8	104.86	17500.0
2003-11-19 18:00:00	SPY	ETF	104.84	104.89	104.8	104.89	9800.0
2003-11-19 19:00:00	SPY	ETF	104.87	104.89	104.83	104.89	3800.0
2003-11-19 08:00:00	QQQ	ETF	33.95	34.05	33.92	34.01	208200.0
2003-11-19 09:00:00	QQQ	ETF	34.01	34.16	33.88	33.94	13087700.0
2003-11-19 10:00:00	QQQ	ETF	33.92	34.23	33.886	34.12	17061600.0
2003-11-19 11:00:00	QQQ	ETF	34.121	34.23	34.06	34.08	7132900.0
2003-11-19 12:00:00	QQQ	ETF	34.07	34.19	34.03	34.14	5840800.0
2003-11-19 13:00:00	QQQ	ETF	34.147	34.27	34.04	34.15	8305600.0
2003-11-19 14:00:00	QQQ	ETF	34.15	34.4	34.13	34.33	9948200.0
2003-11-19 15:00:00	QQQ	ETF	34.33	34.39	34.21	34.3	12486300.0
2003-11-19 16:00:00	QQQ	ETF	34.3	34.37	34.17	34.25	2539600.0
2003-11-19 17:00:00	QQQ	ETF	34.24	34.26	34.223	34.24	52500.0
2003-11-19 18:00:00	QQQ	ETF	34.26	34.27	34.24	34.25	69600.0
2003-11-19 19:00:00	QQQ	ETF	34.25	34.27	34.22	34.24	138700.0
2003-11-19 08:00:00	IWM	ETF	52.0	52.12	52.0	52.115	50000.0
2003-11-19 09:00:00	IWM	ETF	52.02	52.25	51.785	51.85	436800.0
2003-11-19 10:00:00	IWM	ETF	51.825	52.175	51.825	52.175	1618600.0
2003-11-19 11:00:00	IWM	ETF	52.165	52.485	52.15	52.345	1239400.0
2003-11-19 12:00:00	IWM	ETF	52.255	52.375	52.225	52.36	503400.0
2003-11-19 13:00:00	IWM	ETF	52.343	52.365	52.19	52.265	308200.0
2003-11-19 14:00:00	IWM	ETF	52.265	52.65	52.26	52.5	792400.0
2003-11-19 15:00:00	IWM	ETF	52.495	52.562	52.365	52.513	1185000.0
2003-11-19 16:00:00	IWM	ETF	52.525	52.525	52.385	52.425	144600.0
2003-11-19 17:00:00	IWM	ETF	52.46	52.46	52.46	52.46	38000.0
2003-11-19 08:00:00	DIA	ETF	96.83	96.9	96.83	96.83	1300.0
2003-11-19 09:00:00	DIA	ETF	96.82	96.89	96.6	96.75	834100.0
2003-11-19 10:00:00	DIA	ETF	96.74	97.18	96.7	97.11	483400.0
2003-11-19 11:00:00	DIA	ETF	97.11	97.23	96.92	96.931	444500.0
2003-11-19 12:00:00	DIA	ETF	96.931	97.12	96.86	97.09	345500.0
2003-11-19 13:00:00	DIA	ETF	97.07	97.19	96.9	97.03	367100.0
2003-11-19 14:00:00	DIA	ETF	97.08	97.53	97.08	97.43	412000.0
2003-11-19 15:00:00	DIA	ETF	97.44	97.49	97.24	97.39	484800.0
2003-11-19 16:00:00	DIA	ETF	97.32	97.45	97.32	97.36	129600.0
2003-11-19 17:00:00	DIA	ETF	97.3	97.42	97.28	97.42	900.0
2003-11-19 09:00:00	TLT	ETF	86.42	86.62	86.42	86.57	83700.0
2003-11-19 10:00:00	TLT	ETF	86.6	86.6	86.14	86.21	64500.0
2003-11-19 11:00:00	TLT	ETF	86.15	86.25	86.06	86.06	27500.0
2003-11-19 12:00:00	TLT	ETF	86.09	86.09	85.75	85.95	125600.0
2003-11-19 13:00:00	TLT	ETF	85.89	86.01	85.87	85.87	11900.0
2003-11-19 14:00:00	TLT	ETF	85.89	85.89	85.57	85.7	164000.0

> showing 50 of 483 rows — these rows as CSV

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