PREVIEW / etf_1hour / 2005-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-21.parquet
  size:    29 KB
  rows:    879

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-21 07:00:00	SPY	ETF	121.37	121.38	121.32	121.32	25400.0
2005-06-21 08:00:00	SPY	ETF	121.37	121.41	121.37	121.41	20900.0
2005-06-21 09:00:00	SPY	ETF	121.44	121.64	121.14	121.2	5919100.0
2005-06-21 10:00:00	SPY	ETF	121.2	121.65	121.03	121.47	9202000.0
2005-06-21 11:00:00	SPY	ETF	121.49	121.57	121.23	121.34	2577800.0
2005-06-21 12:00:00	SPY	ETF	121.35	121.55	121.34	121.452	2133500.0
2005-06-21 13:00:00	SPY	ETF	121.46	121.6	121.29	121.48	3621900.0
2005-06-21 14:00:00	SPY	ETF	121.46	121.61	121.38	121.5	4674200.0
2005-06-21 15:00:00	SPY	ETF	121.5	121.54	121.15	121.3	8729300.0
2005-06-21 16:00:00	SPY	ETF	121.34	121.55	121.27	121.48	1203000.0
2005-06-21 17:00:00	SPY	ETF	121.51	121.51	121.47	121.49	21500.0
2005-06-21 18:00:00	SPY	ETF	121.48	121.49	121.48	121.48	1100.0
2005-06-21 19:00:00	SPY	ETF	121.47	121.47	121.45	121.45	1400.0
2005-06-21 09:00:00	QQQ	ETF	37.83	37.95	37.76	37.77	11531100.0
2005-06-21 10:00:00	QQQ	ETF	37.77	38.01	37.71	37.94	20060900.0
2005-06-21 11:00:00	QQQ	ETF	37.94	37.97	37.8	37.88	4999700.0
2005-06-21 12:00:00	QQQ	ETF	37.88	37.97	37.87	37.94	4008400.0
2005-06-21 13:00:00	QQQ	ETF	37.94	37.97	37.85	37.93	6794600.0
2005-06-21 14:00:00	QQQ	ETF	37.93	37.97	37.9	37.92	6878800.0
2005-06-21 15:00:00	QQQ	ETF	37.92	37.93	37.7	37.85	35768000.0
2005-06-21 09:00:00	IWM	ETF	63.82	63.99	63.6	63.65	1688900.0
2005-06-21 10:00:00	IWM	ETF	63.64	63.92	63.53	63.86	2175500.0
2005-06-21 11:00:00	IWM	ETF	63.85	63.89	63.69	63.8	591500.0
2005-06-21 12:00:00	IWM	ETF	63.8	63.97	63.8	63.93	2152100.0
2005-06-21 13:00:00	IWM	ETF	63.92	63.95	63.72	63.77	2130800.0
2005-06-21 14:00:00	IWM	ETF	63.77	63.92	63.65	63.82	1563900.0
2005-06-21 15:00:00	IWM	ETF	63.83	63.86	63.6	63.73	3190800.0
2005-06-21 16:00:00	IWM	ETF	63.73	63.89	63.7	63.86	149600.0
2005-06-21 17:00:00	IWM	ETF	63.85	63.85	63.85	63.85	1500.0
2005-06-21 09:00:00	DIA	ETF	105.94	106.12	105.77	105.82	463900.0
2005-06-21 10:00:00	DIA	ETF	105.81	106.2	105.69	106.09	665500.0
2005-06-21 11:00:00	DIA	ETF	106.1	106.14	105.87	106.0	423900.0
2005-06-21 12:00:00	DIA	ETF	105.98	106.13	105.97	106.03	177900.0
2005-06-21 13:00:00	DIA	ETF	106.04	106.17	105.89	106.04	589800.0
2005-06-21 14:00:00	DIA	ETF	106.04	106.12	105.97	106.01	287500.0
2005-06-21 15:00:00	DIA	ETF	106.03	106.05	105.74	105.93	892100.0
2005-06-21 16:00:00	DIA	ETF	105.91	106.09	105.91	106.05	60100.0
2005-06-21 17:00:00	DIA	ETF	106.05	106.11	106.0	106.1	2400.0
2005-06-21 18:00:00	DIA	ETF	106.1	106.1	106.1	106.1	200.0
2005-06-21 19:00:00	DIA	ETF	106.04	106.04	106.04	106.04	400.0
2005-06-21 08:00:00	GLD	ETF	43.52	43.52	43.38	43.43	3000.0
2005-06-21 09:00:00	GLD	ETF	43.51	43.58	43.51	43.52	208200.0
2005-06-21 10:00:00	GLD	ETF	43.52	43.53	43.42	43.5	80600.0
2005-06-21 11:00:00	GLD	ETF	43.5	43.65	43.5	43.612	64100.0
2005-06-21 12:00:00	GLD	ETF	43.61	43.71	43.58	43.68	88000.0
2005-06-21 13:00:00	GLD	ETF	43.69	43.82	43.68	43.79	60600.0
2005-06-21 14:00:00	GLD	ETF	43.77	43.82	43.76	43.78	69300.0
2005-06-21 15:00:00	GLD	ETF	43.78	43.81	43.74	43.81	98800.0
2005-06-21 08:00:00	TLT	ETF	94.07	94.19	94.07	94.19	5800.0
2005-06-21 09:00:00	TLT	ETF	94.25	94.62	94.25	94.59	91800.0

> showing 50 of 879 rows — these rows as CSV

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