PREVIEW / etf_1hour / 2003-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-23.parquet
  size:    16 KB
  rows:    391

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-05-23 08:00:00	SPY	ETF	93.44	93.51	93.42	93.5	23100.0
2003-05-23 09:00:00	SPY	ETF	93.51	93.66	93.14	93.22	3038600.0
2003-05-23 10:00:00	SPY	ETF	93.22	93.77	93.15	93.65	4378500.0
2003-05-23 11:00:00	SPY	ETF	93.66	93.89	93.65	93.78	3353700.0
2003-05-23 12:00:00	SPY	ETF	93.77	93.98	93.71	93.8	2287300.0
2003-05-23 13:00:00	SPY	ETF	93.8	93.94	93.75	93.91	1119800.0
2003-05-23 14:00:00	SPY	ETF	93.9	93.98	93.72	93.87	2468300.0
2003-05-23 15:00:00	SPY	ETF	93.84	93.97	93.66	93.75	3427000.0
2003-05-23 16:00:00	SPY	ETF	93.72	93.8	93.66	93.76	854800.0
2003-05-23 17:00:00	SPY	ETF	93.76	93.77	93.75	93.75	2900.0
2003-05-23 18:00:00	SPY	ETF	93.76	93.76	93.76	93.76	600.0
2003-05-23 19:00:00	SPY	ETF	93.75	93.76	93.74	93.74	300.0
2003-05-23 08:00:00	QQQ	ETF	28.01	28.1	28.01	28.09	53200.0
2003-05-23 09:00:00	QQQ	ETF	28.09	28.18	27.95	28.0	6344500.0
2003-05-23 10:00:00	QQQ	ETF	27.99	28.17	27.98	28.13	7630200.0
2003-05-23 11:00:00	QQQ	ETF	28.14	28.22	28.12	28.17	4450400.0
2003-05-23 12:00:00	QQQ	ETF	28.16	28.25	28.13	28.15	3575800.0
2003-05-23 13:00:00	QQQ	ETF	28.15	28.19	28.12	28.17	2109400.0
2003-05-23 14:00:00	QQQ	ETF	28.17	28.2	28.06	28.11	2512300.0
2003-05-23 15:00:00	QQQ	ETF	28.13	28.17	28.06	28.08	4088800.0
2003-05-23 16:00:00	QQQ	ETF	28.08	28.14	28.06	28.14	1409200.0
2003-05-23 17:00:00	QQQ	ETF	28.11	28.13	28.07	28.09	26500.0
2003-05-23 18:00:00	QQQ	ETF	28.09	28.14	28.08	28.11	11200.0
2003-05-23 19:00:00	QQQ	ETF	28.11	28.11	28.09	28.09	1800.0
2003-05-23 09:00:00	IWM	ETF	41.385	41.39	41.195	41.31	259600.0
2003-05-23 10:00:00	IWM	ETF	41.315	41.62	41.285	41.525	262600.0
2003-05-23 11:00:00	IWM	ETF	41.565	41.68	41.565	41.655	125200.0
2003-05-23 12:00:00	IWM	ETF	41.67	41.685	41.635	41.65	51200.0
2003-05-23 13:00:00	IWM	ETF	41.645	41.715	41.645	41.69	129400.0
2003-05-23 14:00:00	IWM	ETF	41.695	41.825	41.675	41.75	126200.0
2003-05-23 15:00:00	IWM	ETF	41.755	41.785	41.705	41.725	203800.0
2003-05-23 16:00:00	IWM	ETF	41.71	41.77	41.685	41.7	20800.0
2003-05-23 08:00:00	DIA	ETF	85.95	86.0	85.9	85.98	9100.0
2003-05-23 09:00:00	DIA	ETF	85.97	86.08	85.61	85.66	1202500.0
2003-05-23 10:00:00	DIA	ETF	85.66	86.2	85.62	86.1	949900.0
2003-05-23 11:00:00	DIA	ETF	86.11	86.35	86.07	86.3	647200.0
2003-05-23 12:00:00	DIA	ETF	86.24	86.42	86.16	86.26	186500.0
2003-05-23 13:00:00	DIA	ETF	86.26	86.36	86.22	86.3	214500.0
2003-05-23 14:00:00	DIA	ETF	86.28	86.38	86.13	86.25	218300.0
2003-05-23 15:00:00	DIA	ETF	86.22	86.35	86.12	86.28	462900.0
2003-05-23 16:00:00	DIA	ETF	86.23	86.28	86.16	86.2	64000.0
2003-05-23 17:00:00	DIA	ETF	86.25	86.29	86.25	86.29	500.0
2003-05-23 18:00:00	DIA	ETF	86.25	86.25	86.21	86.21	800.0
2003-05-23 09:00:00	TLT	ETF	95.8	96.05	95.74	96.02	37600.0
2003-05-23 10:00:00	TLT	ETF	96.04	96.15	95.87	96.13	77000.0
2003-05-23 11:00:00	TLT	ETF	96.08	96.13	95.92	96.12	139300.0
2003-05-23 12:00:00	TLT	ETF	96.07	96.21	95.86	95.94	46300.0
2003-05-23 13:00:00	TLT	ETF	95.87	95.95	95.81	95.82	61900.0
2003-05-23 14:00:00	TLT	ETF	95.82	95.82	95.75	95.79	16400.0
2003-05-23 15:00:00	TLT	ETF	95.79	95.9	95.64	95.88	128600.0

> showing 50 of 391 rows — these rows as CSV

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