PREVIEW / etf_1hour / 2004-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-18.parquet
  size:    26 KB
  rows:    718

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
2004-10-18 08:00:00	SPY	ETF	110.89	110.93	110.82	110.88	82800.0
2004-10-18 09:00:00	SPY	ETF	110.89	111.15	110.81	111.15	3933600.0
2004-10-18 10:00:00	SPY	ETF	111.16	111.25	110.75	110.77	6677800.0
2004-10-18 11:00:00	SPY	ETF	110.78	111.21	110.7	111.15	3846600.0
2004-10-18 12:00:00	SPY	ETF	111.14	111.8	111.14	111.59	8828700.0
2004-10-18 13:00:00	SPY	ETF	111.58	111.86	111.41	111.54	3624100.0
2004-10-18 14:00:00	SPY	ETF	111.54	111.81	111.41	111.74	2942100.0
2004-10-18 15:00:00	SPY	ETF	111.75	111.86	111.53	111.8	4522200.0
2004-10-18 16:00:00	SPY	ETF	111.8	111.9	111.4	111.87	1862900.0
2004-10-18 17:00:00	SPY	ETF	111.87	111.95	111.83	111.92	250500.0
2004-10-18 18:00:00	SPY	ETF	111.92	111.92	111.83	111.86	151700.0
2004-10-18 19:00:00	SPY	ETF	111.86	111.92	111.86	111.9	6900.0
2004-10-18 08:00:00	QQQ	ETF	35.5	35.54	35.45	35.49	124900.0
2004-10-18 09:00:00	QQQ	ETF	35.49	35.622	35.45	35.62	12615900.0
2004-10-18 10:00:00	QQQ	ETF	35.618	35.7	35.43	35.49	16114100.0
2004-10-18 11:00:00	QQQ	ETF	35.48	35.747	35.41	35.73	12029200.0
2004-10-18 12:00:00	QQQ	ETF	35.734	36.1	35.71	35.99	19476000.0
2004-10-18 13:00:00	QQQ	ETF	35.983	36.11	35.908	35.97	14055200.0
2004-10-18 14:00:00	QQQ	ETF	35.97	36.16	35.91	36.12	12358400.0
2004-10-18 15:00:00	QQQ	ETF	36.12	36.2	36.01	36.188	13730100.0
2004-10-18 16:00:00	QQQ	ETF	36.18	36.29	36.12	36.29	6543500.0
2004-10-18 17:00:00	QQQ	ETF	36.29	36.39	36.26	36.37	729700.0
2004-10-18 18:00:00	QQQ	ETF	36.37	36.38	36.33	36.34	119400.0
2004-10-18 19:00:00	QQQ	ETF	36.35	36.35	36.34	36.35	22000.0
2004-10-18 08:00:00	IWM	ETF	56.64	56.64	56.6	56.6	3000.0
2004-10-18 09:00:00	IWM	ETF	56.645	56.7	56.43	56.595	1220800.0
2004-10-18 10:00:00	IWM	ETF	56.58	56.695	56.36	56.425	2586800.0
2004-10-18 11:00:00	IWM	ETF	56.43	56.67	56.365	56.6	1163600.0
2004-10-18 12:00:00	IWM	ETF	56.605	57.225	56.575	57.065	3038800.0
2004-10-18 13:00:00	IWM	ETF	57.065	57.155	56.885	56.93	991200.0
2004-10-18 14:00:00	IWM	ETF	56.92	57.145	56.85	57.025	1168400.0
2004-10-18 15:00:00	IWM	ETF	57.035	57.12	56.91	57.05	1375200.0
2004-10-18 16:00:00	IWM	ETF	57.075	57.135	56.955	57.135	289600.0
2004-10-18 17:00:00	IWM	ETF	57.135	57.135	57.135	57.135	4000.0
2004-10-18 18:00:00	IWM	ETF	57.135	57.135	57.135	57.135	200.0
2004-10-18 19:00:00	IWM	ETF	57.135	57.135	57.115	57.115	9000.0
2004-10-18 08:00:00	DIA	ETF	99.22	99.23	99.05	99.07	15300.0
2004-10-18 09:00:00	DIA	ETF	99.07	99.15	98.93	99.12	784400.0
2004-10-18 10:00:00	DIA	ETF	99.12	99.2	98.79	98.79	1217400.0
2004-10-18 11:00:00	DIA	ETF	98.79	99.16	98.75	99.13	1378000.0
2004-10-18 12:00:00	DIA	ETF	99.13	99.65	99.11	99.46	2152700.0
2004-10-18 13:00:00	DIA	ETF	99.46	99.72	99.3	99.37	1617300.0
2004-10-18 14:00:00	DIA	ETF	99.39	99.61	99.24	99.54	1094500.0
2004-10-18 15:00:00	DIA	ETF	99.54	99.75	99.39	99.67	1068900.0
2004-10-18 16:00:00	DIA	ETF	99.66	99.8	99.46	99.78	145000.0
2004-10-18 17:00:00	DIA	ETF	99.77	99.85	99.77	99.85	2800.0
2004-10-18 18:00:00	DIA	ETF	99.84	99.88	99.84	99.88	1400.0
2004-10-18 09:00:00	TLT	ETF	88.65	88.66	88.57	88.59	23500.0
2004-10-18 10:00:00	TLT	ETF	88.58	88.62	88.49	88.6	29700.0
2004-10-18 11:00:00	TLT	ETF	88.59	88.59	88.5	88.5	83400.0

> showing 50 of 718 rows — these rows as CSV

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