PREVIEW / etf_1hour / 2005-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-01.parquet
  size:    31 KB
  rows:    886

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-06-01 07:00:00	SPY	ETF	119.59	119.59	119.55	119.55	12900.0
2005-06-01 08:00:00	SPY	ETF	119.6	119.62	119.48	119.5	110700.0
2005-06-01 09:00:00	SPY	ETF	119.49	119.7	119.45	119.7	4681100.0
2005-06-01 10:00:00	SPY	ETF	119.7	120.74	119.68	120.51	20692700.0
2005-06-01 11:00:00	SPY	ETF	120.51	120.92	120.45	120.82	7445600.0
2005-06-01 12:00:00	SPY	ETF	120.83	120.88	120.55	120.75	7746000.0
2005-06-01 13:00:00	SPY	ETF	120.76	120.89	120.67	120.84	5321400.0
2005-06-01 14:00:00	SPY	ETF	120.84	120.92	120.0	120.13	10201200.0
2005-06-01 15:00:00	SPY	ETF	120.13	120.58	120.06	120.54	9022900.0
2005-06-01 16:00:00	SPY	ETF	120.38	120.55	120.33	120.45	1435600.0
2005-06-01 17:00:00	SPY	ETF	120.46	120.48	120.4	120.4	124600.0
2005-06-01 18:00:00	SPY	ETF	120.4	120.55	120.4	120.55	110500.0
2005-06-01 19:00:00	SPY	ETF	120.5	120.53	120.5	120.52	1800.0
2005-06-01 09:00:00	QQQ	ETF	38.04	38.17	38.02	38.15	7738000.0
2005-06-01 10:00:00	QQQ	ETF	38.15	38.6	38.15	38.47	33219500.0
2005-06-01 11:00:00	QQQ	ETF	38.47	38.68	38.46	38.6	15491100.0
2005-06-01 12:00:00	QQQ	ETF	38.6	38.61	38.51	38.58	6890300.0
2005-06-01 13:00:00	QQQ	ETF	38.58	38.64	38.55	38.6	7790800.0
2005-06-01 14:00:00	QQQ	ETF	38.61	38.63	38.31	38.33	17686800.0
2005-06-01 15:00:00	QQQ	ETF	38.33	38.49	38.31	38.43	12653400.0
2005-06-01 07:00:00	IWM	ETF	61.34	61.34	61.34	61.34	400.0
2005-06-01 08:00:00	IWM	ETF	61.345	61.38	61.3	61.3	8800.0
2005-06-01 09:00:00	IWM	ETF	61.3	61.665	61.3	61.665	1857800.0
2005-06-01 10:00:00	IWM	ETF	61.665	62.195	61.62	62.04	8169600.0
2005-06-01 11:00:00	IWM	ETF	62.05	62.25	61.565	62.175	4027000.0
2005-06-01 12:00:00	IWM	ETF	62.175	62.19	62.015	62.12	1874600.0
2005-06-01 13:00:00	IWM	ETF	62.12	62.225	62.08	62.205	1225200.0
2005-06-01 14:00:00	IWM	ETF	62.205	62.25	61.52	61.655	3869600.0
2005-06-01 15:00:00	IWM	ETF	61.66	62.045	61.63	62.025	2671800.0
2005-06-01 16:00:00	IWM	ETF	62.025	62.09	61.985	62.025	1614800.0
2005-06-01 17:00:00	IWM	ETF	62.025	62.085	62.025	62.085	5200.0
2005-06-01 18:00:00	IWM	ETF	62.075	62.095	62.075	62.095	1600.0
2005-06-01 08:00:00	DIA	ETF	104.74	104.75	104.72	104.72	3200.0
2005-06-01 09:00:00	DIA	ETF	104.66	104.77	104.61	104.74	276000.0
2005-06-01 10:00:00	DIA	ETF	104.74	105.68	104.73	105.47	3129000.0
2005-06-01 11:00:00	DIA	ETF	105.46	105.83	105.45	105.75	1276000.0
2005-06-01 12:00:00	DIA	ETF	105.73	105.76	105.51	105.65	426100.0
2005-06-01 13:00:00	DIA	ETF	105.65	105.75	105.61	105.74	271300.0
2005-06-01 14:00:00	DIA	ETF	105.75	105.78	104.99	105.06	1366600.0
2005-06-01 15:00:00	DIA	ETF	105.08	105.44	105.01	105.43	733700.0
2005-06-01 16:00:00	DIA	ETF	105.38	105.44	104.76	105.44	312000.0
2005-06-01 17:00:00	DIA	ETF	105.34	105.42	105.34	105.42	1700.0
2005-06-01 18:00:00	DIA	ETF	105.3	105.4	105.3	105.4	1000.0
2005-06-01 09:00:00	GLD	ETF	41.45	41.48	41.4	41.48	234900.0
2005-06-01 10:00:00	GLD	ETF	41.48	41.54	41.43	41.52	551400.0
2005-06-01 11:00:00	GLD	ETF	41.51	41.64	41.51	41.61	288200.0
2005-06-01 12:00:00	GLD	ETF	41.59	41.65	41.5	41.57	138000.0
2005-06-01 13:00:00	GLD	ETF	41.58	41.58	41.46	41.5	154000.0
2005-06-01 14:00:00	GLD	ETF	41.48	41.56	41.47	41.52	158300.0
2005-06-01 15:00:00	GLD	ETF	41.5	41.53	41.47	41.51	261900.0

> showing 50 of 886 rows — these rows as CSV

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