PREVIEW / etf_1hour / 2006-05-30

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-30.parquet
  size:    44 KB
  rows:    1,362

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
2006-05-30 04:00:00	SPY	ETF	127.78	127.78	127.78	127.78	200.0
2006-05-30 06:00:00	SPY	ETF	127.73	127.78	127.7	127.71	125600.0
2006-05-30 07:00:00	SPY	ETF	127.75	128.1	127.75	127.89	313100.0
2006-05-30 08:00:00	SPY	ETF	127.55	128.09	127.55	127.89	1429900.0
2006-05-30 09:00:00	SPY	ETF	127.89	128.0	127.35	127.43	10773100.0
2006-05-30 10:00:00	SPY	ETF	127.42	127.51	127.17	127.4	10127000.0
2006-05-30 11:00:00	SPY	ETF	127.39	127.45	126.99	127.26	7744100.0
2006-05-30 12:00:00	SPY	ETF	127.26	127.35	126.96	127.01	4677200.0
2006-05-30 13:00:00	SPY	ETF	127.02	127.08	126.73	126.98	7931100.0
2006-05-30 14:00:00	SPY	ETF	126.98	127.12	126.86	126.92	4476000.0
2006-05-30 15:00:00	SPY	ETF	126.91	126.91	126.26	126.28	14297500.0
2006-05-30 16:00:00	SPY	ETF	126.3	126.3	126.07	126.12	2847700.0
2006-05-30 17:00:00	SPY	ETF	126.12	126.27	126.01	126.17	480900.0
2006-05-30 18:00:00	SPY	ETF	126.17	126.19	126.1	126.16	24600.0
2006-05-30 19:00:00	SPY	ETF	126.17	126.19	126.17	126.18	2400.0
2006-05-30 09:00:00	QQQ	ETF	39.31	39.33	39.06	39.06	15984100.0
2006-05-30 10:00:00	QQQ	ETF	39.07	39.13	38.97	39.02	17610400.0
2006-05-30 11:00:00	QQQ	ETF	39.02	39.04	38.87	38.99	20256200.0
2006-05-30 12:00:00	QQQ	ETF	38.99	39.03	38.88	38.91	6756600.0
2006-05-30 13:00:00	QQQ	ETF	38.91	38.94	38.83	38.92	7987000.0
2006-05-30 14:00:00	QQQ	ETF	38.92	38.96	38.87	38.92	7517000.0
2006-05-30 15:00:00	QQQ	ETF	38.92	38.93	38.61	38.62	22666900.0
2006-05-30 07:00:00	IWM	ETF	72.25	72.35	72.24	72.24	1800.0
2006-05-30 08:00:00	IWM	ETF	71.95	72.85	71.95	72.22	1276200.0
2006-05-30 09:00:00	IWM	ETF	72.18	72.35	71.54	71.77	4235400.0
2006-05-30 10:00:00	IWM	ETF	71.77	71.89	71.6	71.75	8499400.0
2006-05-30 11:00:00	IWM	ETF	71.75	71.76	71.27	71.5	5461900.0
2006-05-30 12:00:00	IWM	ETF	71.49	71.69	71.32	71.34	3556600.0
2006-05-30 13:00:00	IWM	ETF	71.34	71.43	71.03	71.19	5832100.0
2006-05-30 14:00:00	IWM	ETF	71.19	71.42	71.16	71.25	4024700.0
2006-05-30 15:00:00	IWM	ETF	71.25	71.29	70.57	70.58	8622400.0
2006-05-30 16:00:00	IWM	ETF	70.57	70.7	70.51	70.59	1615100.0
2006-05-30 17:00:00	IWM	ETF	70.64	70.64	70.5	70.5	4800.0
2006-05-30 18:00:00	IWM	ETF	70.51	70.62	70.51	70.62	2600.0
2006-05-30 19:00:00	IWM	ETF	70.65	70.65	70.65	70.65	500.0
2006-05-30 07:00:00	DIA	ETF	112.29	112.48	112.29	112.38	2300.0
2006-05-30 08:00:00	DIA	ETF	112.38	112.4	112.26	112.27	14600.0
2006-05-30 09:00:00	DIA	ETF	112.32	112.38	111.81	111.89	782200.0
2006-05-30 10:00:00	DIA	ETF	111.88	111.94	111.66	111.81	1169200.0
2006-05-30 11:00:00	DIA	ETF	111.81	111.81	111.4999	111.66	1135900.0
2006-05-30 12:00:00	DIA	ETF	111.67	111.75	111.47	111.53	423100.0
2006-05-30 13:00:00	DIA	ETF	111.51	111.55	111.24	111.47	1336300.0
2006-05-30 14:00:00	DIA	ETF	111.47	111.56	111.33	111.38	675900.0
2006-05-30 15:00:00	DIA	ETF	111.38	111.39	110.85	110.94	2035700.0
2006-05-30 16:00:00	DIA	ETF	110.95	110.95	110.78	110.88	116900.0
2006-05-30 17:00:00	DIA	ETF	110.83	110.87	110.81	110.83	465800.0
2006-05-30 18:00:00	DIA	ETF	110.8	110.8	110.8	110.8	500.0
2006-05-30 19:00:00	DIA	ETF	110.88	110.89	110.88	110.89	600.0
2006-05-30 07:00:00	GLD	ETF	65.15	65.2	65.1	65.1	17500.0
2006-05-30 08:00:00	GLD	ETF	65.11	65.17	64.86	65.12	110500.0

> showing 50 of 1,362 rows — these rows as CSV

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