PREVIEW / stock_1hour / 2007-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-01.parquet
  size:    660 KB
  rows:    31,462
  symbols: 2,504

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
2007-02-01 06:00:00	AAPL	Stock	3.0679	3.0679	3.0679	3.0679	2800.0
2007-02-01 07:00:00	AAPL	Stock	3.0836	3.0836	3.0679	3.0714	103600.0
2007-02-01 08:00:00	AAPL	Stock	3.0796	3.0796	3.0618	3.0771	2423960.0
2007-02-01 09:00:00	AAPL	Stock	3.0768	3.0811	3.0614	3.0704	116100516.0
2007-02-01 10:00:00	AAPL	Stock	3.0704	3.0714	3.0507	3.0554	125342000.0
2007-02-01 11:00:00	AAPL	Stock	3.0546	3.0561	3.0289	3.0457	116078704.0
2007-02-01 12:00:00	AAPL	Stock	3.0457	3.0471	3.0332	3.035	43488480.0
2007-02-01 13:00:00	AAPL	Stock	3.0353	3.0471	3.0268	3.0414	72127888.0
2007-02-01 14:00:00	AAPL	Stock	3.0418	3.0475	3.0321	3.0389	61739972.0
2007-02-01 15:00:00	AAPL	Stock	3.0389	3.0468	3.0264	3.0264	111998628.0
2007-02-01 16:00:00	AAPL	Stock	3.0261	3.0311	3.0243	3.0293	3985800.0
2007-02-01 17:00:00	AAPL	Stock	3.0293	3.0307	3.0268	3.0268	335524.0
2007-02-01 18:00:00	AAPL	Stock	3.0268	3.0307	3.0268	3.0307	258244.0
2007-02-01 19:00:00	AAPL	Stock	3.0286	3.0314	3.0264	3.0314	423864.0
2007-02-01 08:00:00	MSFT	Stock	30.84	30.85	30.79	30.85	27360.0
2007-02-01 09:00:00	MSFT	Stock	30.86	30.94	30.74	30.82	7652957.0
2007-02-01 10:00:00	MSFT	Stock	30.82	30.82	30.61	30.63	8082857.0
2007-02-01 11:00:00	MSFT	Stock	30.63	30.836	30.38	30.51	8258171.0
2007-02-01 12:00:00	MSFT	Stock	30.51	30.836	30.45	30.46	3404233.0
2007-02-01 13:00:00	MSFT	Stock	30.47	30.64	30.41	30.45	4126044.0
2007-02-01 14:00:00	MSFT	Stock	30.449	30.48	30.37	30.44	4913078.0
2007-02-01 15:00:00	MSFT	Stock	30.43	30.6	30.38	30.55	13986035.0
2007-02-01 16:00:00	MSFT	Stock	30.56	30.563	30.44	30.55	307549.0
2007-02-01 17:00:00	MSFT	Stock	30.56	30.56	30.51	30.51	1408.0
2007-02-01 18:00:00	MSFT	Stock	30.56	30.57	30.53	30.57	6483.0
2007-02-01 19:00:00	MSFT	Stock	30.559	30.559	30.559	30.559	4681.0
2007-02-01 07:00:00	NVDA	Stock	0.4988	0.4992	0.4988	0.4992	42000.0
2007-02-01 08:00:00	NVDA	Stock	0.5017	0.5042	0.4942	0.5035	1521300.0
2007-02-01 09:00:00	NVDA	Stock	0.505	0.52	0.5037	0.5183	113319900.0
2007-02-01 10:00:00	NVDA	Stock	0.5183	0.5192	0.5137	0.5147	150260340.0
2007-02-01 11:00:00	NVDA	Stock	0.5145	0.5148	0.5077	0.5127	77195040.0
2007-02-01 12:00:00	NVDA	Stock	0.5127	0.5158	0.5125	0.5137	42317280.0
2007-02-01 13:00:00	NVDA	Stock	0.5137	0.5148	0.5125	0.5145	41793660.0
2007-02-01 14:00:00	NVDA	Stock	0.5145	0.515	0.5125	0.5138	60176820.0
2007-02-01 15:00:00	NVDA	Stock	0.5138	0.5187	0.5135	0.517	124530300.0
2007-02-01 16:00:00	NVDA	Stock	0.5173	0.5183	0.516	0.516	1551360.0
2007-02-01 17:00:00	NVDA	Stock	0.516	0.5167	0.5153	0.5153	288300.0
2007-02-01 18:00:00	NVDA	Stock	0.5143	0.5202	0.5143	0.5202	347640.0
2007-02-01 19:00:00	NVDA	Stock	0.5173	0.5187	0.5173	0.5187	114780.0
2007-02-01 08:00:00	AMZN	Stock	1.8835	1.8985	1.8835	1.8935	779800.0
2007-02-01 09:00:00	AMZN	Stock	1.8965	1.9555	1.8835	1.9435	44307260.0
2007-02-01 10:00:00	AMZN	Stock	1.944	1.965	1.9365	1.952	54064400.0
2007-02-01 11:00:00	AMZN	Stock	1.952	1.9525	1.9255	1.9305	38741380.0
2007-02-01 12:00:00	AMZN	Stock	1.9305	1.934	1.925	1.9255	15738160.0
2007-02-01 13:00:00	AMZN	Stock	1.9255	1.9335	1.9155	1.916	27078860.0
2007-02-01 14:00:00	AMZN	Stock	1.916	1.942	1.913	1.941	27572700.0
2007-02-01 15:00:00	AMZN	Stock	1.941	1.945	1.927	1.935	74464200.0
2007-02-01 16:00:00	AMZN	Stock	1.935	2.0655	1.894	1.9775	172759100.0
2007-02-01 17:00:00	AMZN	Stock	1.974	1.9775	1.9025	1.919	51437060.0
2007-02-01 18:00:00	AMZN	Stock	1.919	1.9375	1.909	1.9375	6450860.0

> showing 50 of 31,462 rows — these rows as CSV

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