PREVIEW / etf_1hour / 2005-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-01.parquet
  size:    32 KB
  rows:    960

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-09-01 06:00:00	SPY	ETF	122.37	122.37	122.37	122.37	2500.0
2005-09-01 07:00:00	SPY	ETF	122.36	122.49	122.36	122.49	225800.0
2005-09-01 08:00:00	SPY	ETF	122.48	122.62	122.36	122.59	1087900.0
2005-09-01 09:00:00	SPY	ETF	122.59	122.78	122.37	122.6	6875700.0
2005-09-01 10:00:00	SPY	ETF	122.6	122.61	121.93	122.23	15911400.0
2005-09-01 11:00:00	SPY	ETF	122.23	123.15	122.16	122.95	15563700.0
2005-09-01 12:00:00	SPY	ETF	122.95	123.0	122.51	122.56	6141300.0
2005-09-01 13:00:00	SPY	ETF	122.56	122.8	122.34	122.41	5184900.0
2005-09-01 14:00:00	SPY	ETF	122.41	122.76	122.16	122.53	9602900.0
2005-09-01 15:00:00	SPY	ETF	122.53	122.95	122.47	122.56	7969600.0
2005-09-01 16:00:00	SPY	ETF	122.55	123.1	122.4	122.43	4361300.0
2005-09-01 17:00:00	SPY	ETF	122.4	122.49	122.4	122.45	130100.0
2005-09-01 18:00:00	SPY	ETF	122.5	122.5	122.43	122.43	3900.0
2005-09-01 19:00:00	SPY	ETF	122.46	122.46	122.46	122.46	600.0
2005-09-01 09:00:00	QQQ	ETF	38.98	39.07	38.95	39.03	8038500.0
2005-09-01 10:00:00	QQQ	ETF	39.03	39.03	38.78	38.87	15261900.0
2005-09-01 11:00:00	QQQ	ETF	38.87	39.15	38.86	39.04	16386700.0
2005-09-01 12:00:00	QQQ	ETF	39.04	39.05	38.93	38.93	7581700.0
2005-09-01 13:00:00	QQQ	ETF	38.94	39.03	38.86	38.88	5976700.0
2005-09-01 14:00:00	QQQ	ETF	38.88	39.0	38.82	38.92	9143100.0
2005-09-01 15:00:00	QQQ	ETF	38.92	39.9	38.89	38.91	7648700.0
2005-09-01 08:00:00	IWM	ETF	66.43	66.53	66.42	66.47	13000.0
2005-09-01 09:00:00	IWM	ETF	66.43	66.75	66.42	66.7	3366100.0
2005-09-01 10:00:00	IWM	ETF	66.7	66.7	66.21	66.42	4992300.0
2005-09-01 11:00:00	IWM	ETF	66.43	66.88	66.33	66.76	4570100.0
2005-09-01 12:00:00	IWM	ETF	66.76	66.8	66.46	66.52	1511500.0
2005-09-01 13:00:00	IWM	ETF	66.52	66.63	66.3	66.35	1397500.0
2005-09-01 14:00:00	IWM	ETF	66.35	66.64	66.22	66.46	2117400.0
2005-09-01 15:00:00	IWM	ETF	66.45	66.63	66.43	66.57	2797900.0
2005-09-01 16:00:00	IWM	ETF	66.58	66.6	66.49	66.5	142400.0
2005-09-01 18:00:00	IWM	ETF	66.54	66.54	66.54	66.54	7200.0
2005-09-01 08:00:00	DIA	ETF	104.74	104.87	104.74	104.85	4800.0
2005-09-01 09:00:00	DIA	ETF	104.78	104.98	104.65	104.8	723500.0
2005-09-01 10:00:00	DIA	ETF	104.8	104.8	104.22	104.38	2168400.0
2005-09-01 11:00:00	DIA	ETF	104.37	105.19	104.34	104.93	1068000.0
2005-09-01 12:00:00	DIA	ETF	104.95	104.97	104.61	104.67	348400.0
2005-09-01 13:00:00	DIA	ETF	104.66	104.89	104.45	104.56	1425800.0
2005-09-01 14:00:00	DIA	ETF	104.54	104.82	104.34	104.56	750200.0
2005-09-01 15:00:00	DIA	ETF	104.56	104.79	104.55	104.62	875700.0
2005-09-01 16:00:00	DIA	ETF	104.61	104.61	104.5	104.5	7800.0
2005-09-01 08:00:00	GLD	ETF	43.58	43.79	43.58	43.79	1300.0
2005-09-01 09:00:00	GLD	ETF	43.78	43.95	43.78	43.88	202100.0
2005-09-01 10:00:00	GLD	ETF	43.87	44.4	43.85	44.4	1060900.0
2005-09-01 11:00:00	GLD	ETF	44.38	44.39	44.21	44.22	307000.0
2005-09-01 12:00:00	GLD	ETF	44.25	44.27	44.16	44.18	497200.0
2005-09-01 13:00:00	GLD	ETF	44.18	44.2	44.09	44.11	144300.0
2005-09-01 14:00:00	GLD	ETF	44.11	44.25	44.1	44.25	90200.0
2005-09-01 15:00:00	GLD	ETF	44.25	44.25	44.18	44.22	188700.0
2005-09-01 08:00:00	TLT	ETF	95.76	95.76	95.24	95.28	76100.0
2005-09-01 09:00:00	TLT	ETF	95.43	95.43	95.22	95.33	249900.0

> showing 50 of 960 rows — these rows as CSV

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