PREVIEW / etf_1hour / 2005-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-18.parquet
  size:    31 KB
  rows:    892

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-05-18 05:00:00	SPY	ETF	117.51	117.51	117.51	117.51	1500.0
2005-05-18 07:00:00	SPY	ETF	117.48	117.55	117.48	117.54	64100.0
2005-05-18 08:00:00	SPY	ETF	117.56	118.13	117.53	118.08	1104600.0
2005-05-18 09:00:00	SPY	ETF	118.09	118.35	118.01	118.1	12544900.0
2005-05-18 10:00:00	SPY	ETF	118.1	118.57	118.08	118.45	15988200.0
2005-05-18 11:00:00	SPY	ETF	118.44	118.58	118.34	118.47	7019500.0
2005-05-18 12:00:00	SPY	ETF	118.49	119.04	118.49	118.99	10311200.0
2005-05-18 13:00:00	SPY	ETF	118.99	119.08	118.66	118.68	10354300.0
2005-05-18 14:00:00	SPY	ETF	118.68	119.05	118.65	118.93	6379800.0
2005-05-18 15:00:00	SPY	ETF	118.92	119.0	118.66	118.79	9356400.0
2005-05-18 16:00:00	SPY	ETF	118.79	118.9	118.76	118.78	1518400.0
2005-05-18 17:00:00	SPY	ETF	118.77	118.8	118.74	118.75	110800.0
2005-05-18 18:00:00	SPY	ETF	118.74	118.79	118.74	118.79	10900.0
2005-05-18 19:00:00	SPY	ETF	118.76	118.77	118.76	118.77	1100.0
2005-05-18 09:00:00	QQQ	ETF	36.8	36.88	36.71	36.76	20636900.0
2005-05-18 10:00:00	QQQ	ETF	36.76	36.98	36.75	36.94	17697500.0
2005-05-18 11:00:00	QQQ	ETF	36.95	37.07	36.93	37.05	15623000.0
2005-05-18 12:00:00	QQQ	ETF	37.05	37.4	37.05	37.31	20504100.0
2005-05-18 13:00:00	QQQ	ETF	37.32	37.36	37.19	37.22	17842700.0
2005-05-18 14:00:00	QQQ	ETF	37.22	37.33	37.2	37.31	10722300.0
2005-05-18 15:00:00	QQQ	ETF	37.3	37.34	37.18	37.19	17971500.0
2005-05-18 08:00:00	IWM	ETF	59.5	59.67	59.5	59.66	4800.0
2005-05-18 09:00:00	IWM	ETF	59.67	59.875	59.605	59.655	4740000.0
2005-05-18 10:00:00	IWM	ETF	59.655	60.105	59.62	60.055	8470200.0
2005-05-18 11:00:00	IWM	ETF	60.05	60.15	59.925	60.115	4769400.0
2005-05-18 12:00:00	IWM	ETF	60.1105	60.56	60.11	60.505	5378600.0
2005-05-18 13:00:00	IWM	ETF	60.5	60.55	60.255	60.31	3962800.0
2005-05-18 14:00:00	IWM	ETF	60.305	60.525	60.28	60.425	3990800.0
2005-05-18 15:00:00	IWM	ETF	60.425	60.55	60.225	60.38	4205600.0
2005-05-18 16:00:00	IWM	ETF	60.38	60.525	60.375	60.525	771400.0
2005-05-18 17:00:00	IWM	ETF	60.48	60.48	60.48	60.48	9000.0
2005-05-18 08:00:00	DIA	ETF	103.62	103.95	103.62	103.9	129900.0
2005-05-18 09:00:00	DIA	ETF	103.95	104.12	103.86	104.0	1326000.0
2005-05-18 10:00:00	DIA	ETF	104.01	104.45	104.0	104.38	2024800.0
2005-05-18 11:00:00	DIA	ETF	104.38	104.59	104.29	104.51	808800.0
2005-05-18 12:00:00	DIA	ETF	104.52	105.0	104.52	104.92	1014800.0
2005-05-18 13:00:00	DIA	ETF	104.92	104.99	104.69	104.69	1225500.0
2005-05-18 14:00:00	DIA	ETF	104.69	105.06	104.63	104.97	755000.0
2005-05-18 15:00:00	DIA	ETF	104.95	105.03	104.78	104.84	1118300.0
2005-05-18 16:00:00	DIA	ETF	104.84	104.9	104.84	104.85	35200.0
2005-05-18 17:00:00	DIA	ETF	104.9	104.91	104.81	104.81	2100.0
2005-05-18 19:00:00	DIA	ETF	104.85	104.85	104.85	104.85	400.0
2005-05-18 08:00:00	GLD	ETF	42.05	42.05	42.05	42.05	10000.0
2005-05-18 09:00:00	GLD	ETF	42.05	42.05	41.93	41.94	191700.0
2005-05-18 10:00:00	GLD	ETF	41.94	41.98	41.83	41.96	166000.0
2005-05-18 11:00:00	GLD	ETF	41.943	42.06	41.93	41.99	46700.0
2005-05-18 12:00:00	GLD	ETF	41.99	42.05	41.93	42.034	132300.0
2005-05-18 13:00:00	GLD	ETF	42.05	42.11	42.03	42.05	144600.0
2005-05-18 14:00:00	GLD	ETF	42.06	42.09	42.04	42.05	1392000.0
2005-05-18 15:00:00	GLD	ETF	42.05	42.08	42.04	42.05	123800.0

> showing 50 of 892 rows — these rows as CSV

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