PREVIEW / etf_1hour / 2003-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-17.parquet
  size:    18 KB
  rows:    456

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-17 08:00:00	SPY	ETF	105.28	105.45	105.24	105.41	10500.0
2003-10-17 09:00:00	SPY	ETF	105.4	105.63	105.03	105.09	3242700.0
2003-10-17 10:00:00	SPY	ETF	105.1	105.11	104.59	104.74	8131700.0
2003-10-17 11:00:00	SPY	ETF	104.73	104.77	104.47	104.73	4352700.0
2003-10-17 12:00:00	SPY	ETF	104.72	104.74	104.39	104.68	4004600.0
2003-10-17 13:00:00	SPY	ETF	104.7	104.7	104.36	104.55	2010200.0
2003-10-17 14:00:00	SPY	ETF	104.54	104.57	104.13	104.15	3205900.0
2003-10-17 15:00:00	SPY	ETF	104.16	104.3	103.98	104.23	4722700.0
2003-10-17 16:00:00	SPY	ETF	104.22	104.34	104.18	104.21	1071000.0
2003-10-17 17:00:00	SPY	ETF	104.21	104.21	104.15	104.15	15400.0
2003-10-17 18:00:00	SPY	ETF	104.13	104.26	104.13	104.26	9600.0
2003-10-17 19:00:00	SPY	ETF	104.24	104.24	104.24	104.24	1000.0
2003-10-17 08:00:00	QQQ	ETF	35.4	35.43	35.38	35.43	44100.0
2003-10-17 09:00:00	QQQ	ETF	35.42	35.49	35.08	35.11	11570400.0
2003-10-17 10:00:00	QQQ	ETF	35.108	35.18	34.79	34.889	26517900.0
2003-10-17 11:00:00	QQQ	ETF	34.889	35.0	34.73	34.903	11188700.0
2003-10-17 12:00:00	QQQ	ETF	34.9	34.92	34.75	34.87	8526000.0
2003-10-17 13:00:00	QQQ	ETF	34.88	34.88	34.69	34.83	6667300.0
2003-10-17 14:00:00	QQQ	ETF	34.83	34.85	34.66	34.661	7137700.0
2003-10-17 15:00:00	QQQ	ETF	34.67	34.77	34.61	34.66	13465300.0
2003-10-17 16:00:00	QQQ	ETF	34.65	35.4831	34.56	34.6	4825000.0
2003-10-17 17:00:00	QQQ	ETF	34.6	34.6	34.48	34.57	156500.0
2003-10-17 18:00:00	QQQ	ETF	34.57	34.57	34.45	34.52	115600.0
2003-10-17 19:00:00	QQQ	ETF	34.54	34.55	34.51	34.52	8700.0
2003-10-17 20:00:00	QQQ	ETF	34.52	34.52	34.52	34.52	400.0
2003-10-17 09:00:00	IWM	ETF	52.85	52.955	52.534	52.545	377800.0
2003-10-17 10:00:00	IWM	ETF	52.505	52.555	52.14	52.24	1356600.0
2003-10-17 11:00:00	IWM	ETF	52.24	52.325	52.1	52.295	1293600.0
2003-10-17 12:00:00	IWM	ETF	52.29	52.29	52.12	52.235	697600.0
2003-10-17 13:00:00	IWM	ETF	52.225	52.26	52.08	52.155	741800.0
2003-10-17 14:00:00	IWM	ETF	52.159	52.159	51.885	51.89	1416200.0
2003-10-17 15:00:00	IWM	ETF	51.885	52.3	51.845	51.87	1395400.0
2003-10-17 16:00:00	IWM	ETF	51.93	51.93	51.83	51.85	701600.0
2003-10-17 17:00:00	IWM	ETF	51.805	51.805	51.805	51.805	800.0
2003-10-17 08:00:00	DIA	ETF	97.97	98.11	97.97	98.11	4900.0
2003-10-17 09:00:00	DIA	ETF	98.11	98.37	97.83	97.88	551800.0
2003-10-17 10:00:00	DIA	ETF	97.88	97.92	97.427	97.62	1309900.0
2003-10-17 11:00:00	DIA	ETF	97.6	97.75	97.43	97.67	804600.0
2003-10-17 12:00:00	DIA	ETF	97.66	97.72	97.37	97.66	706100.0
2003-10-17 13:00:00	DIA	ETF	97.62	97.69	97.41	97.62	361300.0
2003-10-17 14:00:00	DIA	ETF	97.59	97.63	97.25	97.26	484600.0
2003-10-17 15:00:00	DIA	ETF	97.211	97.4	97.14	97.38	1362000.0
2003-10-17 16:00:00	DIA	ETF	97.36	97.41	97.16	97.3	345600.0
2003-10-17 17:00:00	DIA	ETF	97.35	97.35	97.25	97.25	2600.0
2003-10-17 09:00:00	TLT	ETF	83.08	83.29	83.01	83.29	26900.0
2003-10-17 10:00:00	TLT	ETF	83.24	83.5	83.17	83.39	118200.0
2003-10-17 11:00:00	TLT	ETF	83.4	83.54	83.31	83.54	44200.0
2003-10-17 12:00:00	TLT	ETF	83.5	83.62	83.37	83.45	41400.0
2003-10-17 13:00:00	TLT	ETF	83.45	83.67	83.45	83.55	20000.0
2003-10-17 14:00:00	TLT	ETF	83.6	83.69	83.51	83.65	38300.0

> showing 50 of 456 rows — these rows as CSV

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