PREVIEW / stock_1hour / 2007-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-03.parquet
  size:    685 KB
  rows:    32,053
  symbols: 2,573

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-04-03 07:00:00	AAPL	Stock	3.3461	3.3607	3.3461	3.3554	307888.0
2007-04-03 08:00:00	AAPL	Stock	3.3554	3.3571	3.35	3.3554	1936340.0
2007-04-03 09:00:00	AAPL	Stock	3.3554	3.3793	3.3486	3.3741	118728904.0
2007-04-03 10:00:00	AAPL	Stock	3.3739	3.3929	3.3664	3.3918	138029052.0
2007-04-03 11:00:00	AAPL	Stock	3.3918	3.3954	3.3818	3.3925	72710484.0
2007-04-03 12:00:00	AAPL	Stock	3.3921	3.4011	3.3846	3.3882	50251572.0
2007-04-03 13:00:00	AAPL	Stock	3.3879	3.3968	3.385	3.3886	45761324.0
2007-04-03 14:00:00	AAPL	Stock	3.3886	3.3968	3.3864	3.3925	48686764.0
2007-04-03 15:00:00	AAPL	Stock	3.3921	3.3964	3.3689	3.3739	95693080.0
2007-04-03 16:00:00	AAPL	Stock	3.3739	3.3764	3.3707	3.3743	4183620.0
2007-04-03 17:00:00	AAPL	Stock	3.3743	3.3761	3.3736	3.3761	166152.0
2007-04-03 18:00:00	AAPL	Stock	3.3757	3.3757	3.375	3.375	42252.0
2007-04-03 19:00:00	AAPL	Stock	3.375	3.38	3.375	3.38	320740.0
2007-04-03 07:00:00	MSFT	Stock	27.87	27.87	27.87	27.87	1500.0
2007-04-03 08:00:00	MSFT	Stock	27.75	27.83	27.75	27.81	6704.0
2007-04-03 09:00:00	MSFT	Stock	27.81	27.92	27.75	27.86	4061964.0
2007-04-03 10:00:00	MSFT	Stock	27.852	28.02	27.79	27.97	8126590.0
2007-04-03 11:00:00	MSFT	Stock	27.97	28.06	27.93	28.05	3394362.0
2007-04-03 12:00:00	MSFT	Stock	28.05	28.06	27.91	27.91	3421181.0
2007-04-03 13:00:00	MSFT	Stock	27.91	28.05	27.91	28.0	3798912.0
2007-04-03 14:00:00	MSFT	Stock	28.0	28.0	27.85	27.86	5165015.0
2007-04-03 15:00:00	MSFT	Stock	27.86	27.91	27.82	27.87	10182303.0
2007-04-03 16:00:00	MSFT	Stock	27.86	27.87	27.816	27.84	563914.0
2007-04-03 17:00:00	MSFT	Stock	27.85	27.87	27.85	27.85	10300.0
2007-04-03 18:00:00	MSFT	Stock	27.87	27.87	27.84	27.84	2814300.0
2007-04-03 19:00:00	MSFT	Stock	27.83	27.86	27.83	27.86	1862.0
2007-04-03 08:00:00	NVDA	Stock	0.4887	0.4887	0.48	0.4857	196500.0
2007-04-03 09:00:00	NVDA	Stock	0.4842	0.4842	0.4728	0.4778	51265500.0
2007-04-03 10:00:00	NVDA	Stock	0.4775	0.4832	0.4775	0.4825	68180160.0
2007-04-03 11:00:00	NVDA	Stock	0.4823	0.4845	0.4813	0.4827	69463980.0
2007-04-03 12:00:00	NVDA	Stock	0.4827	0.483	0.48	0.4803	56987340.0
2007-04-03 13:00:00	NVDA	Stock	0.4802	0.4803	0.4787	0.479	54102120.0
2007-04-03 14:00:00	NVDA	Stock	0.479	0.4798	0.477	0.478	59834880.0
2007-04-03 15:00:00	NVDA	Stock	0.478	0.4785	0.476	0.4772	91893360.0
2007-04-03 16:00:00	NVDA	Stock	0.477	0.4782	0.4762	0.4773	8503860.0
2007-04-03 08:00:00	AMZN	Stock	2.0225	2.0245	2.0175	2.0245	66000.0
2007-04-03 09:00:00	AMZN	Stock	2.0185	2.046	2.0185	2.0435	11405820.0
2007-04-03 10:00:00	AMZN	Stock	2.044	2.069	2.044	2.0631	34563860.0
2007-04-03 11:00:00	AMZN	Stock	2.063	2.066	2.057	2.0645	12305920.0
2007-04-03 12:00:00	AMZN	Stock	2.0645	2.066	2.0565	2.0595	8369380.0
2007-04-03 13:00:00	AMZN	Stock	2.059	2.062	2.054	2.061	16757040.0
2007-04-03 14:00:00	AMZN	Stock	2.061	2.063	2.053	2.061	10445480.0
2007-04-03 15:00:00	AMZN	Stock	2.061	2.062	2.0545	2.0595	19610280.0
2007-04-03 16:00:00	AMZN	Stock	2.059	2.06	2.057	2.0585	675840.0
2007-04-03 18:00:00	AMZN	Stock	2.053	2.053	2.053	2.053	6500.0
2007-04-03 09:00:00	CL	Stock	33.225	33.25	33.075	33.185	489800.0
2007-04-03 10:00:00	CL	Stock	33.195	33.285	33.08	33.125	460600.0
2007-04-03 11:00:00	CL	Stock	33.125	33.1505	33.08	33.105	317600.0
2007-04-03 12:00:00	CL	Stock	33.105	33.11	33.03	33.055	246000.0
2007-04-03 13:00:00	CL	Stock	33.055	33.09	33.01	33.015	427200.0

> showing 50 of 32,053 rows — these rows as CSV

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