PREVIEW / etf_1hour / 2003-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-13.parquet
  size:    18 KB
  rows:    463

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-13 08:00:00	SPY	ETF	104.93	105.03	104.9	104.93	103000.0
2003-10-13 09:00:00	SPY	ETF	104.89	104.89	104.7	104.82	3242000.0
2003-10-13 10:00:00	SPY	ETF	104.828	105.29	104.81	105.14	4691600.0
2003-10-13 11:00:00	SPY	ETF	105.15	105.18	104.97	105.1	2539500.0
2003-10-13 12:00:00	SPY	ETF	105.14	105.15	104.87	104.92	2061700.0
2003-10-13 13:00:00	SPY	ETF	104.97	104.99	104.51	104.77	4439500.0
2003-10-13 14:00:00	SPY	ETF	104.77	104.84	104.66	104.7	1654900.0
2003-10-13 15:00:00	SPY	ETF	104.7	104.94	104.53	104.86	2974200.0
2003-10-13 16:00:00	SPY	ETF	104.89	104.96	104.84	104.931	800400.0
2003-10-13 17:00:00	SPY	ETF	104.95	104.95	104.91	104.94	3400.0
2003-10-13 18:00:00	SPY	ETF	104.95	104.96	104.94	104.95	2500.0
2003-10-13 19:00:00	SPY	ETF	104.99	105.0	104.99	105.0	300.0
2003-10-13 08:00:00	QQQ	ETF	35.23	35.23	35.18	35.2	113400.0
2003-10-13 09:00:00	QQQ	ETF	35.19	35.22	35.09	35.18	8836000.0
2003-10-13 10:00:00	QQQ	ETF	35.17	35.37	35.16	35.284	11789200.0
2003-10-13 11:00:00	QQQ	ETF	35.28	35.29	35.15	35.255	4930200.0
2003-10-13 12:00:00	QQQ	ETF	35.26	35.27	35.1	35.14	5847800.0
2003-10-13 13:00:00	QQQ	ETF	35.13	35.18	34.92	35.09	9158500.0
2003-10-13 14:00:00	QQQ	ETF	35.1	35.12	34.98	35.04	5312100.0
2003-10-13 15:00:00	QQQ	ETF	35.04	35.17	34.96	35.15	7417200.0
2003-10-13 16:00:00	QQQ	ETF	35.155	35.25	35.12	35.23	2543600.0
2003-10-13 17:00:00	QQQ	ETF	35.23	35.23	35.18	35.2	51700.0
2003-10-13 18:00:00	QQQ	ETF	35.196	35.22	35.19	35.19	21900.0
2003-10-13 19:00:00	QQQ	ETF	35.2	35.22	35.18	35.22	12500.0
2003-10-13 08:00:00	IWM	ETF	51.935	51.935	51.935	51.935	4800.0
2003-10-13 09:00:00	IWM	ETF	52.06	52.45	51.95	52.45	381800.0
2003-10-13 10:00:00	IWM	ETF	52.45	52.845	52.405	52.665	1185400.0
2003-10-13 11:00:00	IWM	ETF	52.68	52.68	52.55	52.635	597800.0
2003-10-13 12:00:00	IWM	ETF	52.63	52.68	52.5	52.515	635200.0
2003-10-13 13:00:00	IWM	ETF	52.51	52.535	52.325	52.425	715800.0
2003-10-13 14:00:00	IWM	ETF	52.41	52.465	52.375	52.393	177800.0
2003-10-13 15:00:00	IWM	ETF	52.395	52.67	52.325	52.645	658600.0
2003-10-13 16:00:00	IWM	ETF	52.67	52.725	52.61	52.685	486600.0
2003-10-13 08:00:00	DIA	ETF	97.68	97.68	97.67	97.67	900.0
2003-10-13 09:00:00	DIA	ETF	97.6	97.66	97.458	97.58	630300.0
2003-10-13 10:00:00	DIA	ETF	97.609	98.02	97.6	97.93	1106200.0
2003-10-13 11:00:00	DIA	ETF	97.93	97.98	97.77	97.89	458900.0
2003-10-13 12:00:00	DIA	ETF	97.9	97.92	97.8	97.81	187800.0
2003-10-13 13:00:00	DIA	ETF	97.81	97.84	97.47	97.66	946300.0
2003-10-13 14:00:00	DIA	ETF	97.63	97.73	97.55	97.6	128100.0
2003-10-13 15:00:00	DIA	ETF	97.64	97.87	97.5	97.858	403400.0
2003-10-13 16:00:00	DIA	ETF	97.86	97.95	97.83	97.91	103700.0
2003-10-13 17:00:00	DIA	ETF	97.95	97.95	97.95	97.95	100.0
2003-10-13 18:00:00	DIA	ETF	97.95	97.95	97.92	97.92	3100.0
2003-10-13 19:00:00	DIA	ETF	98.0	98.15	98.0	98.08	3100.0
2003-10-13 09:00:00	TLT	ETF	84.35	84.48	84.35	84.45	19100.0
2003-10-13 10:00:00	TLT	ETF	84.42	84.45	84.25	84.3	21000.0
2003-10-13 11:00:00	TLT	ETF	84.25	84.32	84.25	84.31	8900.0
2003-10-13 12:00:00	TLT	ETF	84.26	84.32	84.25	84.32	4000.0
2003-10-13 13:00:00	TLT	ETF	84.29	84.32	84.26	84.32	30600.0

> showing 50 of 463 rows — these rows as CSV

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