PREVIEW / stock_1hour / 2006-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-16.parquet
  size:    625 KB
  rows:    29,886
  symbols: 2,275

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-16 07:00:00	AAPL	Stock	2.1143	2.1161	2.1089	2.1089	98000.0
2006-06-16 08:00:00	AAPL	Stock	2.1232	2.1232	2.0936	2.1	2719052.0
2006-06-16 09:00:00	AAPL	Stock	2.1018	2.1139	2.0864	2.0925	198274048.0
2006-06-16 10:00:00	AAPL	Stock	2.0925	2.0975	2.0675	2.0761	168120008.0
2006-06-16 11:00:00	AAPL	Stock	2.0757	2.0825	2.0682	2.0743	82820500.0
2006-06-16 12:00:00	AAPL	Stock	2.0746	2.079	2.0554	2.0671	92576960.0
2006-06-16 13:00:00	AAPL	Stock	2.0671	2.0732	2.0589	2.0696	61774552.0
2006-06-16 14:00:00	AAPL	Stock	2.0689	2.1055	2.0614	2.0689	75523252.0
2006-06-16 15:00:00	AAPL	Stock	2.0693	2.0764	2.0543	2.0557	132268976.0
2006-06-16 16:00:00	AAPL	Stock	2.0554	2.0581	2.0518	2.0536	3704232.0
2006-06-16 17:00:00	AAPL	Stock	2.0546	2.0571	2.0543	2.0571	275324.0
2006-06-16 18:00:00	AAPL	Stock	2.0564	2.0571	2.0554	2.0554	196252.0
2006-06-16 07:00:00	MSFT	Stock	22.0	22.0	21.97	21.98	3100.0
2006-06-16 08:00:00	MSFT	Stock	21.97	22.0	21.88	21.9	254113.0
2006-06-16 09:00:00	MSFT	Stock	21.9	22.0	21.8	21.95	32316933.0
2006-06-16 10:00:00	MSFT	Stock	21.958	21.99	21.79	21.85	18446723.0
2006-06-16 11:00:00	MSFT	Stock	21.85	21.96	21.84	21.94	14944528.0
2006-06-16 12:00:00	MSFT	Stock	21.94	22.04	21.88	22.01	12607451.0
2006-06-16 13:00:00	MSFT	Stock	22.02	22.15	21.94	22.07	16189274.0
2006-06-16 14:00:00	MSFT	Stock	22.072	22.22	22.06	22.2	13495796.0
2006-06-16 15:00:00	MSFT	Stock	22.19	22.28	22.06	22.09	24363897.0
2006-06-16 16:00:00	MSFT	Stock	22.1	22.125	21.95	22.08	1518097.0
2006-06-16 17:00:00	MSFT	Stock	22.08	22.09	22.05	22.08	69300.0
2006-06-16 18:00:00	MSFT	Stock	22.08	22.1	22.06	22.08	14021.0
2006-06-16 08:00:00	NVDA	Stock	0.3717	0.3717	0.37	0.37	177000.0
2006-06-16 09:00:00	NVDA	Stock	0.37	0.37	0.3657	0.3667	107432940.0
2006-06-16 10:00:00	NVDA	Stock	0.3667	0.3673	0.3602	0.3605	77657400.0
2006-06-16 11:00:00	NVDA	Stock	0.3605	0.361	0.358	0.3602	60519660.0
2006-06-16 12:00:00	NVDA	Stock	0.3602	0.361	0.3575	0.3591	35293860.0
2006-06-16 13:00:00	NVDA	Stock	0.3592	0.3602	0.3587	0.3597	24497340.0
2006-06-16 14:00:00	NVDA	Stock	0.3597	0.36	0.3582	0.3593	38328120.0
2006-06-16 15:00:00	NVDA	Stock	0.3592	0.3667	0.3592	0.361	82065060.0
2006-06-16 16:00:00	NVDA	Stock	0.361	0.3618	0.3583	0.3598	6168960.0
2006-06-16 17:00:00	NVDA	Stock	0.3598	0.3598	0.3598	0.3598	384000.0
2006-06-16 18:00:00	NVDA	Stock	0.3598	0.361	0.3598	0.361	156900.0
2006-06-16 08:00:00	AMZN	Stock	1.748	1.748	1.748	1.748	22000.0
2006-06-16 09:00:00	AMZN	Stock	1.7455	1.759	1.735	1.757	23758060.0
2006-06-16 10:00:00	AMZN	Stock	1.7565	1.758	1.738	1.743	10857260.0
2006-06-16 11:00:00	AMZN	Stock	1.7425	1.7525	1.7375	1.748	8432420.0
2006-06-16 12:00:00	AMZN	Stock	1.748	1.752	1.7365	1.7455	8084280.0
2006-06-16 13:00:00	AMZN	Stock	1.7455	1.7555	1.7385	1.7455	11257140.0
2006-06-16 14:00:00	AMZN	Stock	1.746	1.763	1.7435	1.753	12933240.0
2006-06-16 15:00:00	AMZN	Stock	1.7525	1.758	1.745	1.7535	22517280.0
2006-06-16 16:00:00	AMZN	Stock	1.7525	1.7555	1.751	1.754	1022680.0
2006-06-16 17:00:00	AMZN	Stock	1.7545	1.7545	1.754	1.7545	22000.0
2006-06-16 18:00:00	AMZN	Stock	1.7545	1.7545	1.7545	1.7545	13780.0
2006-06-16 09:00:00	CL	Stock	30.2	30.605	30.17	30.58	1418400.0
2006-06-16 10:00:00	CL	Stock	30.595	30.615	30.395	30.57	1315400.0
2006-06-16 11:00:00	CL	Stock	30.57	30.635	30.455	30.555	589000.0
2006-06-16 12:00:00	CL	Stock	30.55	30.6	30.395	30.415	418200.0

> showing 50 of 29,886 rows — these rows as CSV

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