PREVIEW / etf_1hour / 2005-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-01.parquet
  size:    29 KB
  rows:    843

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-01 08:00:00	SPY	ETF	120.86	120.91	120.82	120.82	110100.0
2005-03-01 09:00:00	SPY	ETF	120.83	121.21	120.78	121.12	6266100.0
2005-03-01 10:00:00	SPY	ETF	121.12	121.48	121.03	121.27	11541500.0
2005-03-01 11:00:00	SPY	ETF	121.27	121.4	121.0	121.38	4523000.0
2005-03-01 12:00:00	SPY	ETF	121.34	121.36	121.05	121.16	5429100.0
2005-03-01 13:00:00	SPY	ETF	121.17	121.25	120.91	121.16	4183500.0
2005-03-01 14:00:00	SPY	ETF	121.17	121.33	121.1	121.26	3564800.0
2005-03-01 15:00:00	SPY	ETF	121.26	121.52	121.25	121.29	7895800.0
2005-03-01 16:00:00	SPY	ETF	121.29	121.35	120.6205	121.03	2309100.0
2005-03-01 17:00:00	SPY	ETF	121.03	121.24	121.01	121.24	36000.0
2005-03-01 18:00:00	SPY	ETF	121.05	121.05	121.03	121.03	1000.0
2005-03-01 19:00:00	SPY	ETF	121.03	121.03	121.0	121.0	2700.0
2005-03-01 09:00:00	QQQ	ETF	37.36	37.55	37.36	37.5	12677100.0
2005-03-01 10:00:00	QQQ	ETF	37.49	37.66	37.44	37.6	16290600.0
2005-03-01 11:00:00	QQQ	ETF	37.6	37.6	37.36	37.53	9513700.0
2005-03-01 12:00:00	QQQ	ETF	37.53	37.53	37.38	37.46	10000200.0
2005-03-01 13:00:00	QQQ	ETF	37.46	37.55	37.33	37.5	6888900.0
2005-03-01 14:00:00	QQQ	ETF	37.51	37.58	37.5	37.57	6739300.0
2005-03-01 15:00:00	QQQ	ETF	37.57	37.7	37.54	37.63	11006100.0
2005-03-01 09:00:00	IWM	ETF	63.315	63.52	63.24	63.44	3326400.0
2005-03-01 10:00:00	IWM	ETF	63.44	63.665	63.24	63.4	2103400.0
2005-03-01 11:00:00	IWM	ETF	63.39	63.6	63.14	63.515	2073600.0
2005-03-01 12:00:00	IWM	ETF	63.515	63.54	63.28	63.46	2376200.0
2005-03-01 13:00:00	IWM	ETF	63.46	63.55	63.295	63.485	1626000.0
2005-03-01 14:00:00	IWM	ETF	63.49	63.69	63.46	63.56	1749400.0
2005-03-01 15:00:00	IWM	ETF	63.56	63.79	63.505	63.64	4468200.0
2005-03-01 16:00:00	IWM	ETF	63.62	63.695	63.5	63.5	1416000.0
2005-03-01 17:00:00	IWM	ETF	63.63	63.63	63.63	63.63	33600.0
2005-03-01 08:00:00	DIA	ETF	107.84	107.89	107.83	107.83	13100.0
2005-03-01 09:00:00	DIA	ETF	107.85	108.19	107.76	108.07	801700.0
2005-03-01 10:00:00	DIA	ETF	108.08	108.37	108.03	108.27	989300.0
2005-03-01 11:00:00	DIA	ETF	108.27	108.32	108.04	108.28	1124000.0
2005-03-01 12:00:00	DIA	ETF	108.29	108.29	108.07	108.11	330800.0
2005-03-01 13:00:00	DIA	ETF	108.11	108.17	107.9	108.08	547600.0
2005-03-01 14:00:00	DIA	ETF	108.07	108.2	108.01	108.18	185000.0
2005-03-01 15:00:00	DIA	ETF	108.19	108.49	108.16	108.263	1274900.0
2005-03-01 16:00:00	DIA	ETF	108.27	108.27	108.07	108.25	10200.0
2005-03-01 19:00:00	DIA	ETF	108.1	108.1	108.1	108.1	800.0
2005-03-01 09:00:00	GLD	ETF	43.3	43.34	43.26	43.34	836000.0
2005-03-01 10:00:00	GLD	ETF	43.34	43.37	43.1	43.17	1439200.0
2005-03-01 11:00:00	GLD	ETF	43.18	43.22	43.12	43.14	369700.0
2005-03-01 12:00:00	GLD	ETF	43.14	43.22	43.14	43.19	219600.0
2005-03-01 13:00:00	GLD	ETF	43.18	43.25	43.16	43.24	121500.0
2005-03-01 14:00:00	GLD	ETF	43.21	43.26	43.2	43.23	71300.0
2005-03-01 15:00:00	GLD	ETF	43.23	43.25	43.18	43.24	187700.0
2005-03-01 08:00:00	TLT	ETF	89.92	89.95	89.5	89.55	216100.0
2005-03-01 09:00:00	TLT	ETF	89.5	89.55	89.45	89.45	252000.0
2005-03-01 10:00:00	TLT	ETF	89.45	89.8	89.45	89.58	505400.0
2005-03-01 11:00:00	TLT	ETF	89.64	89.77	89.61	89.75	125100.0
2005-03-01 12:00:00	TLT	ETF	89.75	89.76	89.62	89.7	297500.0

> showing 50 of 843 rows — these rows as CSV

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