PREVIEW / stock_1hour / 2006-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-01.parquet
  size:    598 KB
  rows:    28,105
  symbols: 2,188

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-02-01 07:00:00	AAPL	Stock	2.6643	2.675	2.6639	2.6743	203560.0
2006-02-01 08:00:00	AAPL	Stock	2.675	2.6864	2.6704	2.6821	2089920.0
2006-02-01 09:00:00	AAPL	Stock	2.6839	2.6961	2.6657	2.6821	72726276.0
2006-02-01 10:00:00	AAPL	Stock	2.6818	2.7307	2.6761	2.7079	133603232.0
2006-02-01 11:00:00	AAPL	Stock	2.7082	2.7211	2.6893	2.7021	75825008.0
2006-02-01 12:00:00	AAPL	Stock	2.7025	2.7054	2.6921	2.6947	44037280.0
2006-02-01 13:00:00	AAPL	Stock	2.6946	2.6971	2.6814	2.6904	55821108.0
2006-02-01 14:00:00	AAPL	Stock	2.6904	2.7089	2.69	2.6982	57131900.0
2006-02-01 15:00:00	AAPL	Stock	2.6986	2.7057	2.6875	2.6929	66873688.0
2006-02-01 16:00:00	AAPL	Stock	2.6943	2.6964	2.6868	2.6875	1906688.0
2006-02-01 17:00:00	AAPL	Stock	2.6886	2.6927	2.6879	2.6927	114436.0
2006-02-01 18:00:00	AAPL	Stock	2.69	2.6932	2.69	2.6932	156576.0
2006-02-01 06:00:00	MSFT	Stock	27.78	27.81	27.78	27.81	220.0
2006-02-01 07:00:00	MSFT	Stock	27.92	27.92	27.92	27.92	290.0
2006-02-01 08:00:00	MSFT	Stock	27.95	28.15	27.92	28.05	102810.0
2006-02-01 09:00:00	MSFT	Stock	28.09	28.15	27.9	28.0	6959839.0
2006-02-01 10:00:00	MSFT	Stock	28.001	28.07	27.95	27.98	8632558.0
2006-02-01 11:00:00	MSFT	Stock	27.98	28.0	27.82	27.84	11671251.0
2006-02-01 12:00:00	MSFT	Stock	27.83	27.96	27.82	27.9	7861617.0
2006-02-01 13:00:00	MSFT	Stock	27.9	27.93	27.819	27.85	8527762.0
2006-02-01 14:00:00	MSFT	Stock	27.85	27.9	27.76	27.8	8177100.0
2006-02-01 15:00:00	MSFT	Stock	27.8	28.04	27.77	28.04	14205716.0
2006-02-01 16:00:00	MSFT	Stock	28.03	28.05	27.8	28.04	430236.0
2006-02-01 17:00:00	MSFT	Stock	28.04	28.05	28.016	28.016	11005.0
2006-02-01 18:00:00	MSFT	Stock	28.04	28.04	28.04	28.04	1400.0
2006-02-01 07:00:00	NVDA	Stock	0.3684	0.3684	0.3684	0.3684	120000.0
2006-02-01 08:00:00	NVDA	Stock	0.3678	0.3687	0.3646	0.3683	877200.0
2006-02-01 09:00:00	NVDA	Stock	0.3691	0.3724	0.3665	0.3673	71865120.0
2006-02-01 10:00:00	NVDA	Stock	0.3673	0.372	0.3669	0.3695	58558800.0
2006-02-01 11:00:00	NVDA	Stock	0.3695	0.3715	0.3681	0.3698	46776240.0
2006-02-01 12:00:00	NVDA	Stock	0.37	0.3737	0.37	0.3722	40356240.0
2006-02-01 13:00:00	NVDA	Stock	0.3722	0.3727	0.3692	0.3716	40938120.0
2006-02-01 14:00:00	NVDA	Stock	0.3717	0.3742	0.37	0.3728	61556400.0
2006-02-01 15:00:00	NVDA	Stock	0.3728	0.3764	0.3725	0.3748	86117640.0
2006-02-01 16:00:00	NVDA	Stock	0.3749	0.375	0.3749	0.375	372000.0
2006-02-01 17:00:00	NVDA	Stock	0.375	0.3751	0.375	0.3751	24000.0
2006-02-01 08:00:00	AMZN	Stock	2.195	2.207	2.176	2.2035	147360.0
2006-02-01 09:00:00	AMZN	Stock	2.2075	2.241	2.195	2.201	15376280.0
2006-02-01 10:00:00	AMZN	Stock	2.201	2.2345	2.1935	2.2095	25145460.0
2006-02-01 11:00:00	AMZN	Stock	2.2105	2.219	2.186	2.1865	19390200.0
2006-02-01 12:00:00	AMZN	Stock	2.1865	2.202	2.185	2.1925	21907280.0
2006-02-01 13:00:00	AMZN	Stock	2.1925	2.193	2.175	2.1915	15572020.0
2006-02-01 14:00:00	AMZN	Stock	2.1915	2.206	2.1865	2.1905	20374540.0
2006-02-01 15:00:00	AMZN	Stock	2.1905	2.205	2.186	2.198	27613180.0
2006-02-01 16:00:00	AMZN	Stock	2.199	2.205	2.197	2.199	1810900.0
2006-02-01 17:00:00	AMZN	Stock	2.1975	2.1975	2.1975	2.1975	13660.0
2006-02-01 18:00:00	AMZN	Stock	2.205	2.205	2.205	2.205	2000.0
2006-02-01 09:00:00	CL	Stock	27.4	27.61	27.4	27.525	516000.0
2006-02-01 10:00:00	CL	Stock	27.535	27.71	27.5	27.625	659800.0
2006-02-01 11:00:00	CL	Stock	27.625	27.7	27.5	27.515	693200.0

> showing 50 of 28,105 rows — these rows as CSV

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