PREVIEW / etf_1hour / 2006-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-29.parquet
  size:    49 KB
  rows:    1,512

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-06-29 06:00:00	SPY	ETF	125.18	125.36	125.18	125.28	105100.0
2006-06-29 07:00:00	SPY	ETF	125.28	125.37	125.17	125.21	74200.0
2006-06-29 08:00:00	SPY	ETF	125.21	125.37	125.18	125.24	1868800.0
2006-06-29 09:00:00	SPY	ETF	125.24	125.59	125.17	125.55	8993600.0
2006-06-29 10:00:00	SPY	ETF	125.55	125.76	125.45	125.67	9475800.0
2006-06-29 11:00:00	SPY	ETF	125.68	125.92	125.45	125.5	8240800.0
2006-06-29 12:00:00	SPY	ETF	125.5	125.64	125.27	125.32	5407700.0
2006-06-29 13:00:00	SPY	ETF	125.32	125.55	125.27	125.44	3139700.0
2006-06-29 14:00:00	SPY	ETF	125.4312	127.0	125.43	126.78	38058900.0
2006-06-29 15:00:00	SPY	ETF	126.78	127.28	126.72	127.24	17883600.0
2006-06-29 16:00:00	SPY	ETF	127.25	127.35	126.53	127.27	9358400.0
2006-06-29 17:00:00	SPY	ETF	127.27	127.29	127.21	127.27	12500.0
2006-06-29 18:00:00	SPY	ETF	127.25	127.25	127.19	127.23	60900.0
2006-06-29 19:00:00	SPY	ETF	127.25	127.25	127.18	127.18	600.0
2006-06-29 09:00:00	QQQ	ETF	37.96	38.12	37.95	38.1	15140300.0
2006-06-29 10:00:00	QQQ	ETF	38.09	38.2	38.04	38.11	15524600.0
2006-06-29 11:00:00	QQQ	ETF	38.12	38.21	38.03	38.03	11988800.0
2006-06-29 12:00:00	QQQ	ETF	38.03	38.08	37.9	37.91	7304400.0
2006-06-29 13:00:00	QQQ	ETF	37.91	38.03	37.9	37.98	6398600.0
2006-06-29 14:00:00	QQQ	ETF	37.98	38.74	37.98	38.65	64949100.0
2006-06-29 15:00:00	QQQ	ETF	38.66	38.96	38.64	38.95	46635800.0
2006-06-29 07:00:00	IWM	ETF	68.9	68.9	68.9	68.9	10500.0
2006-06-29 08:00:00	IWM	ETF	68.9	69.0	68.84	68.91	308400.0
2006-06-29 09:00:00	IWM	ETF	68.92	69.51	68.81	69.45	11151900.0
2006-06-29 10:00:00	IWM	ETF	69.43	69.62	69.29	69.49	6953700.0
2006-06-29 11:00:00	IWM	ETF	69.5	69.64	69.28	69.29	6779900.0
2006-06-29 12:00:00	IWM	ETF	69.28	69.36	69.02	69.09	4631500.0
2006-06-29 13:00:00	IWM	ETF	69.08	69.24	69.02	69.21	4322700.0
2006-06-29 14:00:00	IWM	ETF	69.22	70.83	69.2	70.57	41629700.0
2006-06-29 15:00:00	IWM	ETF	70.58	71.09	70.51	71.08	17679600.0
2006-06-29 16:00:00	IWM	ETF	71.08	71.25	71.06	71.25	457800.0
2006-06-29 17:00:00	IWM	ETF	71.25	71.25	71.25	71.25	3300.0
2006-06-29 18:00:00	IWM	ETF	71.24	71.28	71.18	71.18	78700.0
2006-06-29 19:00:00	IWM	ETF	71.18	71.18	71.18	71.18	700.0
2006-06-29 07:00:00	DIA	ETF	110.2	110.26	110.2	110.26	200.0
2006-06-29 08:00:00	DIA	ETF	110.25	110.3	110.18	110.23	14800.0
2006-06-29 09:00:00	DIA	ETF	110.21	110.41	110.13	110.34	505100.0
2006-06-29 10:00:00	DIA	ETF	110.34	110.69	110.28	110.65	744600.0
2006-06-29 11:00:00	DIA	ETF	110.65	110.88	110.52	110.54	790800.0
2006-06-29 12:00:00	DIA	ETF	110.55	110.6	110.34	110.35	359200.0
2006-06-29 13:00:00	DIA	ETF	110.34	110.52	110.33	110.42	213500.0
2006-06-29 14:00:00	DIA	ETF	110.43	111.62	110.42	111.44	3488400.0
2006-06-29 15:00:00	DIA	ETF	111.44	111.87	111.39	111.81	1605600.0
2006-06-29 16:00:00	DIA	ETF	111.82	111.88	111.78	111.83	357200.0
2006-06-29 17:00:00	DIA	ETF	111.9	111.9	111.79	111.9	1500.0
2006-06-29 18:00:00	DIA	ETF	111.81	111.81	111.81	111.81	300.0
2006-06-29 19:00:00	DIA	ETF	111.81	111.81	111.81	111.81	200.0
2006-06-29 04:00:00	GLD	ETF	58.0	58.0	58.0	58.0	100.0
2006-06-29 08:00:00	GLD	ETF	57.86	58.16	57.83	58.13	105800.0
2006-06-29 09:00:00	GLD	ETF	58.1	58.38	57.95	58.35	549000.0

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

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