PREVIEW / etf_1hour / 2005-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-24.parquet
  size:    29 KB
  rows:    858

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-24 08:00:00	SPY	ETF	117.54	117.62	117.45	117.58	311800.0
2005-03-24 09:00:00	SPY	ETF	117.57	117.72	117.34	117.68	6802100.0
2005-03-24 10:00:00	SPY	ETF	117.68	117.82	117.53	117.63	6911000.0
2005-03-24 11:00:00	SPY	ETF	117.63	117.67	117.35	117.53	4893800.0
2005-03-24 12:00:00	SPY	ETF	117.53	117.99	117.52	117.8	4209700.0
2005-03-24 13:00:00	SPY	ETF	117.79	117.93	117.52	117.61	4290400.0
2005-03-24 14:00:00	SPY	ETF	117.6	117.86	117.55	117.68	4391800.0
2005-03-24 15:00:00	SPY	ETF	117.69	117.82	117.11	117.14	15337500.0
2005-03-24 16:00:00	SPY	ETF	117.14	117.26	117.06	117.17	1015200.0
2005-03-24 17:00:00	SPY	ETF	117.16	117.2	117.1	117.2	25500.0
2005-03-24 18:00:00	SPY	ETF	117.16	117.21	117.12	117.12	3600.0
2005-03-24 19:00:00	SPY	ETF	117.13	117.13	117.12	117.13	500.0
2005-03-24 09:00:00	QQQ	ETF	36.4	36.46	36.29	36.46	12283900.0
2005-03-24 10:00:00	QQQ	ETF	36.46	36.61	36.39	36.51	16260800.0
2005-03-24 11:00:00	QQQ	ETF	36.51	36.52	36.35	36.46	10316600.0
2005-03-24 12:00:00	QQQ	ETF	36.46	38.62	36.46	36.57	9009600.0
2005-03-24 13:00:00	QQQ	ETF	36.57	36.57	36.5	36.52	4831800.0
2005-03-24 14:00:00	QQQ	ETF	36.52	36.58	36.47	36.51	5533800.0
2005-03-24 15:00:00	QQQ	ETF	36.52	36.54	36.28	36.28	13823700.0
2005-03-24 08:00:00	IWM	ETF	61.1	61.16	61.09	61.15	32600.0
2005-03-24 09:00:00	IWM	ETF	61.175	61.4	61.005	61.375	2646400.0
2005-03-24 10:00:00	IWM	ETF	61.38	61.495	61.33	61.38	2450400.0
2005-03-24 11:00:00	IWM	ETF	61.375	61.38	61.2	61.36	2081000.0
2005-03-24 12:00:00	IWM	ETF	61.365	61.625	61.35	61.5	1330400.0
2005-03-24 13:00:00	IWM	ETF	61.505	61.505	61.35	61.425	850400.0
2005-03-24 14:00:00	IWM	ETF	61.42	61.535	61.4	61.46	1262400.0
2005-03-24 15:00:00	IWM	ETF	61.46	61.465	61.06	61.13	3031200.0
2005-03-24 16:00:00	IWM	ETF	61.13	61.375	61.06	61.375	320000.0
2005-03-24 17:00:00	IWM	ETF	61.055	61.055	61.055	61.055	2131000.0
2005-03-24 08:00:00	DIA	ETF	104.82	104.84	104.75	104.8	9800.0
2005-03-24 09:00:00	DIA	ETF	104.81	104.9	104.66	104.89	797700.0
2005-03-24 10:00:00	DIA	ETF	104.89	104.97	104.76	104.87	919700.0
2005-03-24 11:00:00	DIA	ETF	104.87	104.87	104.64	104.78	427100.0
2005-03-24 12:00:00	DIA	ETF	104.77	105.15	104.77	104.99	1070900.0
2005-03-24 13:00:00	DIA	ETF	104.98	105.01	104.78	104.86	356900.0
2005-03-24 14:00:00	DIA	ETF	104.85	105.05	104.77	104.87	456700.0
2005-03-24 15:00:00	DIA	ETF	104.87	104.88	104.38	104.39	919300.0
2005-03-24 16:00:00	DIA	ETF	104.38	104.48	104.34	104.42	25600.0
2005-03-24 08:00:00	GLD	ETF	42.5	42.52	42.42	42.49	17200.0
2005-03-24 09:00:00	GLD	ETF	42.55	42.55	42.45	42.49	134600.0
2005-03-24 10:00:00	GLD	ETF	42.5	42.51	42.38	42.39	697700.0
2005-03-24 11:00:00	GLD	ETF	42.41	42.45	42.38	42.45	188500.0
2005-03-24 12:00:00	GLD	ETF	42.44	42.54	42.39	42.49	88700.0
2005-03-24 13:00:00	GLD	ETF	42.48	42.5	42.38	42.38	155300.0
2005-03-24 14:00:00	GLD	ETF	42.38	42.43	42.37	42.39	61600.0
2005-03-24 15:00:00	GLD	ETF	42.4	42.44	42.38	42.42	115500.0
2005-03-24 19:00:00	GLD	ETF	42.67	42.67	42.67	42.67	100.0
2005-03-24 09:00:00	TLT	ETF	88.3	88.46	88.3	88.33	232800.0
2005-03-24 10:00:00	TLT	ETF	88.33	88.41	88.24	88.24	280900.0
2005-03-24 11:00:00	TLT	ETF	88.24	88.39	88.23	88.25	26600.0

> showing 50 of 858 rows — these rows as CSV

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