PREVIEW / stock_1hour / 2007-04-11

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-11.parquet
  size:    685 KB
  rows:    32,487
  symbols: 2,574

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-11 08:00:00	AAPL	Stock	3.3711	3.3711	3.3514	3.3536	942172.0
2007-04-11 09:00:00	AAPL	Stock	3.3543	3.3593	3.3321	3.3364	69296444.0
2007-04-11 10:00:00	AAPL	Stock	3.3364	3.3439	3.305	3.3106	134377740.0
2007-04-11 11:00:00	AAPL	Stock	3.3104	3.32	3.3082	3.3193	78694364.0
2007-04-11 12:00:00	AAPL	Stock	3.3193	3.3304	3.3179	3.32	50740228.0
2007-04-11 13:00:00	AAPL	Stock	3.3204	3.3286	3.315	3.3157	44547188.0
2007-04-11 14:00:00	AAPL	Stock	3.3161	3.3161	3.2975	3.3068	87695160.0
2007-04-11 15:00:00	AAPL	Stock	3.3064	3.3186	3.3021	3.3046	72381092.0
2007-04-11 16:00:00	AAPL	Stock	3.3071	3.3071	3.2929	3.2986	4923212.0
2007-04-11 17:00:00	AAPL	Stock	3.2982	3.2982	3.2932	3.2932	799568.0
2007-04-11 18:00:00	AAPL	Stock	3.2946	3.2964	3.2932	3.2943	373772.0
2007-04-11 19:00:00	AAPL	Stock	3.2982	3.3029	3.2943	3.3	129612.0
2007-04-11 07:00:00	MSFT	Stock	28.33	28.33	28.33	28.33	500.0
2007-04-11 08:00:00	MSFT	Stock	28.33	28.33	28.31	28.33	900.0
2007-04-11 09:00:00	MSFT	Stock	28.33	28.55	28.25	28.52	4842886.0
2007-04-11 10:00:00	MSFT	Stock	28.53	28.57	28.2	28.26	6319550.0
2007-04-11 11:00:00	MSFT	Stock	28.25	28.29	28.18	28.22	3764554.0
2007-04-11 12:00:00	MSFT	Stock	28.22	28.26	28.1	28.19	4604726.0
2007-04-11 13:00:00	MSFT	Stock	28.185	28.26	28.16	28.17	3561179.0
2007-04-11 14:00:00	MSFT	Stock	28.18	28.18	27.99	28.012	9343867.0
2007-04-11 15:00:00	MSFT	Stock	28.01	28.16	27.99	28.09	9381364.0
2007-04-11 16:00:00	MSFT	Stock	28.12	28.123	28.09	28.12	517734.0
2007-04-11 17:00:00	MSFT	Stock	28.12	28.12	28.01	28.02	100100.0
2007-04-11 18:00:00	MSFT	Stock	28.01	28.12	28.01	28.04	2870.0
2007-04-11 19:00:00	MSFT	Stock	28.02	28.03	28.01	28.03	1035.0
2007-04-11 08:00:00	NVDA	Stock	0.5008	0.5008	0.5008	0.5008	42000.0
2007-04-11 09:00:00	NVDA	Stock	0.5032	0.5032	0.4983	0.5005	61344660.0
2007-04-11 10:00:00	NVDA	Stock	0.5007	0.5065	0.4983	0.4987	156258000.0
2007-04-11 11:00:00	NVDA	Stock	0.4985	0.4988	0.4942	0.4946	134609700.0
2007-04-11 12:00:00	NVDA	Stock	0.4947	0.4958	0.492	0.4935	66144120.0
2007-04-11 13:00:00	NVDA	Stock	0.4935	0.4958	0.4928	0.4947	79724460.0
2007-04-11 14:00:00	NVDA	Stock	0.4947	0.4947	0.4898	0.4933	102795480.0
2007-04-11 15:00:00	NVDA	Stock	0.4933	0.4942	0.491	0.4913	110925420.0
2007-04-11 16:00:00	NVDA	Stock	0.4915	0.4915	0.4897	0.4897	945000.0
2007-04-11 17:00:00	NVDA	Stock	0.4897	0.49	0.4897	0.49	61500.0
2007-04-11 18:00:00	NVDA	Stock	0.49	0.4915	0.4883	0.4883	7567920.0
2007-04-11 08:00:00	AMZN	Stock	2.0945	2.095	2.0925	2.095	16600.0
2007-04-11 09:00:00	AMZN	Stock	2.0925	2.0925	2.069	2.073	6510660.0
2007-04-11 10:00:00	AMZN	Stock	2.0735	2.0815	2.062	2.068	15689940.0
2007-04-11 11:00:00	AMZN	Stock	2.0685	2.082	2.0649	2.0815	15527020.0
2007-04-11 12:00:00	AMZN	Stock	2.082	2.0875	2.0815	2.082	11797200.0
2007-04-11 13:00:00	AMZN	Stock	2.082	2.0935	2.08	2.09	10544380.0
2007-04-11 14:00:00	AMZN	Stock	2.09	2.09	2.074	2.078	20323780.0
2007-04-11 15:00:00	AMZN	Stock	2.078	2.088	2.0765	2.084	13675780.0
2007-04-11 16:00:00	AMZN	Stock	2.085	2.0855	2.0845	2.0845	77540.0
2007-04-11 17:00:00	AMZN	Stock	2.081	2.084	2.0745	2.082	1442000.0
2007-04-11 18:00:00	AMZN	Stock	2.08	2.08	2.08	2.08	20000.0
2007-04-11 09:00:00	CL	Stock	32.9	32.95	32.705	32.78	293400.0
2007-04-11 10:00:00	CL	Stock	32.775	32.87	32.76	32.8	460200.0
2007-04-11 11:00:00	CL	Stock	32.8	32.9	32.8	32.85	651200.0

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

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