PREVIEW / etf_1hour / 2003-11-11

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-11.parquet
  size:    18 KB
  rows:    465

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-11 08:00:00	SPY	ETF	104.97	105.04	104.92	105.04	56600.0
2003-11-11 09:00:00	SPY	ETF	105.01	105.29	104.885	104.94	6677100.0
2003-11-11 10:00:00	SPY	ETF	104.94	105.16	104.8	105.07	6709400.0
2003-11-11 11:00:00	SPY	ETF	105.05	105.33	105.02	105.1	3511900.0
2003-11-11 12:00:00	SPY	ETF	105.1	105.22	104.94	105.16	1225900.0
2003-11-11 13:00:00	SPY	ETF	105.17	105.25	105.03	105.11	1085100.0
2003-11-11 14:00:00	SPY	ETF	105.1	105.13	104.94	105.01	1528600.0
2003-11-11 15:00:00	SPY	ETF	105.02	105.15	104.86	105.08	2835600.0
2003-11-11 16:00:00	SPY	ETF	105.08	105.23	105.05	105.09	986900.0
2003-11-11 17:00:00	SPY	ETF	105.06	105.15	105.06	105.15	249600.0
2003-11-11 18:00:00	SPY	ETF	105.15	105.16	105.14	105.14	1300.0
2003-11-11 19:00:00	SPY	ETF	105.14	105.19	105.14	105.19	400.0
2003-11-11 08:00:00	QQQ	ETF	35.09	35.13	35.07	35.13	93600.0
2003-11-11 09:00:00	QQQ	ETF	35.13	35.3	34.97	35.0	15008100.0
2003-11-11 10:00:00	QQQ	ETF	35.02	35.06	34.88	35.02	16039500.0
2003-11-11 11:00:00	QQQ	ETF	35.019	35.15	34.92	34.99	10560900.0
2003-11-11 12:00:00	QQQ	ETF	34.98	35.06	34.9	35.02	3618100.0
2003-11-11 13:00:00	QQQ	ETF	35.02	35.08	34.97	35.01	3547200.0
2003-11-11 14:00:00	QQQ	ETF	35.01	35.05	34.917	34.96	5357900.0
2003-11-11 15:00:00	QQQ	ETF	34.93	35.03	34.85	35.01	9461600.0
2003-11-11 16:00:00	QQQ	ETF	35.01	35.1827	34.9325	35.065	4307200.0
2003-11-11 17:00:00	QQQ	ETF	35.06	35.09	35.04	35.09	325400.0
2003-11-11 18:00:00	QQQ	ETF	35.08	35.09	35.08	35.09	5600.0
2003-11-11 19:00:00	QQQ	ETF	35.07	35.1	35.06	35.1	17400.0
2003-11-11 09:00:00	IWM	ETF	53.015	53.245	52.662	52.705	1222000.0
2003-11-11 10:00:00	IWM	ETF	52.6875	52.74	52.5	52.74	1502400.0
2003-11-11 11:00:00	IWM	ETF	52.735	52.95	52.67	52.675	967600.0
2003-11-11 12:00:00	IWM	ETF	52.7	52.84	52.595	52.795	975600.0
2003-11-11 13:00:00	IWM	ETF	52.785	52.885	52.74	52.755	261600.0
2003-11-11 14:00:00	IWM	ETF	52.73	52.8	52.69	52.725	162400.0
2003-11-11 15:00:00	IWM	ETF	52.7	52.76	52.612	52.651	923600.0
2003-11-11 16:00:00	IWM	ETF	52.665	52.77	52.65	52.6887	171800.0
2003-11-11 18:00:00	IWM	ETF	52.8	52.8	52.8	52.8	200.0
2003-11-11 08:00:00	DIA	ETF	97.55	97.55	97.55	97.55	900.0
2003-11-11 09:00:00	DIA	ETF	97.7	97.85	97.55	97.56	1044000.0
2003-11-11 10:00:00	DIA	ETF	97.57	97.8	97.5	97.75	646600.0
2003-11-11 11:00:00	DIA	ETF	97.781	97.93	97.6	97.658	239700.0
2003-11-11 12:00:00	DIA	ETF	97.66	97.76	97.55	97.74	225900.0
2003-11-11 13:00:00	DIA	ETF	97.711	97.77	97.6	97.64	131900.0
2003-11-11 14:00:00	DIA	ETF	97.62	97.69	97.51	97.56	230900.0
2003-11-11 15:00:00	DIA	ETF	97.6	97.68	97.45	97.63	500300.0
2003-11-11 16:00:00	DIA	ETF	97.63	97.72	97.57	97.61	71600.0
2003-11-11 17:00:00	DIA	ETF	97.61	97.61	97.61	97.61	400.0
2003-11-11 18:00:00	DIA	ETF	97.6	97.6	97.6	97.6	300.0
2003-11-11 09:00:00	TLT	ETF	83.45	83.5	83.41	83.41	8300.0
2003-11-11 10:00:00	TLT	ETF	83.5	83.5	83.45	83.47	10800.0
2003-11-11 11:00:00	TLT	ETF	83.47	83.47	83.36	83.4	4200.0
2003-11-11 12:00:00	TLT	ETF	83.4	83.48	83.4	83.48	17000.0
2003-11-11 13:00:00	TLT	ETF	83.46	83.5	83.46	83.48	18600.0
2003-11-11 14:00:00	TLT	ETF	83.4	83.48	83.36	83.48	8400.0

> showing 50 of 465 rows — these rows as CSV

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