PREVIEW / etf_1hour / 2005-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-02.parquet
  size:    29 KB
  rows:    827

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
2005-03-02 08:00:00	SPY	ETF	120.92	120.99	120.84	120.86	28600.0
2005-03-02 09:00:00	SPY	ETF	120.84	120.94	120.65	120.93	6570300.0
2005-03-02 10:00:00	SPY	ETF	120.92	121.32	120.81	121.29	9401200.0
2005-03-02 11:00:00	SPY	ETF	121.29	121.93	121.24	121.69	11120300.0
2005-03-02 12:00:00	SPY	ETF	121.7	121.79	121.57	121.67	4917100.0
2005-03-02 13:00:00	SPY	ETF	121.67	121.85	121.18	121.37	9515100.0
2005-03-02 14:00:00	SPY	ETF	121.38	121.48	120.92	121.08	11807000.0
2005-03-02 15:00:00	SPY	ETF	121.07	121.485	121.07	121.29	8081800.0
2005-03-02 16:00:00	SPY	ETF	121.29	121.37	121.11	121.2	1580600.0
2005-03-02 17:00:00	SPY	ETF	121.19	121.2	121.15	121.15	8800.0
2005-03-02 18:00:00	SPY	ETF	121.13	121.13	121.11	121.11	1500.0
2005-03-02 19:00:00	SPY	ETF	121.18	121.18	121.18	121.18	300.0
2005-03-02 09:00:00	QQQ	ETF	37.42	37.47	37.36	37.47	10822300.0
2005-03-02 10:00:00	QQQ	ETF	37.47	37.76	37.41	37.74	19517300.0
2005-03-02 11:00:00	QQQ	ETF	37.75	38.02	37.67	37.89	24710300.0
2005-03-02 12:00:00	QQQ	ETF	37.89	37.93	37.81	37.84	8164600.0
2005-03-02 13:00:00	QQQ	ETF	37.84	37.94	37.47	37.77	11500700.0
2005-03-02 14:00:00	QQQ	ETF	37.77	37.8	37.55	37.6	14108700.0
2005-03-02 15:00:00	QQQ	ETF	37.6	37.76	37.6	37.61	11961800.0
2005-03-02 08:00:00	IWM	ETF	63.425	63.425	63.425	63.425	1800.0
2005-03-02 09:00:00	IWM	ETF	63.405	63.485	63.25	63.44	1583400.0
2005-03-02 10:00:00	IWM	ETF	63.445	63.74	63.375	63.74	2729000.0
2005-03-02 11:00:00	IWM	ETF	63.75	64.13	63.705	63.91	5492600.0
2005-03-02 12:00:00	IWM	ETF	63.905	64.005	63.82	63.91	2158600.0
2005-03-02 13:00:00	IWM	ETF	63.905	64.025	63.61	63.72	2222800.0
2005-03-02 14:00:00	IWM	ETF	63.72	63.85	63.35	63.525	3733600.0
2005-03-02 15:00:00	IWM	ETF	63.515	63.755	63.515	63.545	2140600.0
2005-03-02 16:00:00	IWM	ETF	63.54	63.6	63.485	63.515	528800.0
2005-03-02 08:00:00	DIA	ETF	108.01	108.01	107.94	107.94	500.0
2005-03-02 09:00:00	DIA	ETF	107.9	107.9	107.74	107.87	645200.0
2005-03-02 10:00:00	DIA	ETF	107.91	108.17	107.76	108.16	999400.0
2005-03-02 11:00:00	DIA	ETF	108.18	108.69	108.12	108.54	1945400.0
2005-03-02 12:00:00	DIA	ETF	108.54	108.57	108.38	108.47	580400.0
2005-03-02 13:00:00	DIA	ETF	108.47	108.57	108.0	108.15	947700.0
2005-03-02 14:00:00	DIA	ETF	108.15	108.26	107.79	107.94	1246800.0
2005-03-02 15:00:00	DIA	ETF	107.96	108.26	107.94	108.08	818800.0
2005-03-02 16:00:00	DIA	ETF	108.12	108.12	108.03	108.03	6400.0
2005-03-02 08:00:00	GLD	ETF	42.98	42.98	42.98	42.98	2000.0
2005-03-02 09:00:00	GLD	ETF	43.16	43.22	43.12	43.14	299400.0
2005-03-02 10:00:00	GLD	ETF	43.15	43.22	43.08	43.15	329800.0
2005-03-02 11:00:00	GLD	ETF	43.15	43.22	43.14	43.21	83700.0
2005-03-02 12:00:00	GLD	ETF	43.21	43.35	43.19	43.32	99100.0
2005-03-02 13:00:00	GLD	ETF	43.32	43.33	43.2	43.26	100600.0
2005-03-02 14:00:00	GLD	ETF	43.26	43.29	43.21	43.26	42300.0
2005-03-02 15:00:00	GLD	ETF	43.27	43.32	43.24	43.24	211300.0
2005-03-02 08:00:00	TLT	ETF	89.53	89.53	89.34	89.34	130600.0
2005-03-02 09:00:00	TLT	ETF	89.4	89.52	89.4	89.43	245700.0
2005-03-02 10:00:00	TLT	ETF	89.47	89.72	89.47	89.5	335400.0
2005-03-02 11:00:00	TLT	ETF	89.53	89.63	89.5	89.56	151000.0
2005-03-02 12:00:00	TLT	ETF	89.58	89.7	89.56	89.56	38400.0

> showing 50 of 827 rows — these rows as CSV

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