PREVIEW / stock_1hour / 2006-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-07.parquet
  size:    616 KB
  rows:    28,993
  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-07 04:00:00	AAPL	Stock	2.3975	2.3975	2.3971	2.3971	11200.0
2006-02-07 05:00:00	AAPL	Stock	2.3821	2.3821	2.3679	2.3679	159600.0
2006-02-07 06:00:00	AAPL	Stock	2.3714	2.3839	2.3714	2.375	151200.0
2006-02-07 07:00:00	AAPL	Stock	2.3843	2.4018	2.3821	2.3964	637364.0
2006-02-07 08:00:00	AAPL	Stock	2.3954	2.46	2.3671	2.46	47722808.0
2006-02-07 09:00:00	AAPL	Stock	2.4596	2.4693	2.4171	2.46	291950232.0
2006-02-07 10:00:00	AAPL	Stock	2.4596	2.4814	2.4229	2.4521	301814604.0
2006-02-07 11:00:00	AAPL	Stock	2.4521	2.4607	2.4254	2.4293	149053100.0
2006-02-07 12:00:00	AAPL	Stock	2.4286	2.4293	2.3814	2.4064	195589520.0
2006-02-07 13:00:00	AAPL	Stock	2.4049	2.4214	2.3871	2.4139	133734160.0
2006-02-07 14:00:00	AAPL	Stock	2.4136	2.4761	2.4043	2.4131	115228456.0
2006-02-07 15:00:00	AAPL	Stock	2.4132	2.4275	2.4004	2.4139	137651416.0
2006-02-07 16:00:00	AAPL	Stock	2.4143	2.4243	2.4082	2.4221	3999184.0
2006-02-07 17:00:00	AAPL	Stock	2.4229	2.4279	2.4182	2.4232	913248.0
2006-02-07 18:00:00	AAPL	Stock	2.4239	2.4257	2.4142	2.4257	350056.0
2006-02-07 06:00:00	MSFT	Stock	26.73	26.73	26.14	26.14	2280.0
2006-02-07 07:00:00	MSFT	Stock	26.97	27.05	26.97	27.05	1290.0
2006-02-07 08:00:00	MSFT	Stock	26.98	27.04	26.91	26.94	179795.0
2006-02-07 09:00:00	MSFT	Stock	26.95	27.17	26.9	26.98	9104811.0
2006-02-07 10:00:00	MSFT	Stock	26.98	27.15	26.95	27.02	9306824.0
2006-02-07 11:00:00	MSFT	Stock	27.02	27.1	26.96	26.98	6558912.0
2006-02-07 12:00:00	MSFT	Stock	26.99	27.05	26.9	26.94	7847450.0
2006-02-07 13:00:00	MSFT	Stock	26.942	26.97	26.86	26.92	6517787.0
2006-02-07 14:00:00	MSFT	Stock	26.92	26.93	26.81	26.89	8496007.0
2006-02-07 15:00:00	MSFT	Stock	26.89	26.98	26.87	26.94	12457550.0
2006-02-07 16:00:00	MSFT	Stock	26.95	27.08	26.94	27.05	6937459.0
2006-02-07 17:00:00	MSFT	Stock	27.08	27.08	27.02	27.03	42550.0
2006-02-07 18:00:00	MSFT	Stock	27.01	27.03	26.94	27.03	8260.0
2006-02-07 08:00:00	NVDA	Stock	0.3783	0.3783	0.3783	0.3783	12000.0
2006-02-07 09:00:00	NVDA	Stock	0.3777	0.3779	0.3729	0.375	43317240.0
2006-02-07 10:00:00	NVDA	Stock	0.3748	0.3761	0.3657	0.3669	95994720.0
2006-02-07 11:00:00	NVDA	Stock	0.3671	0.37	0.3666	0.367	56383560.0
2006-02-07 12:00:00	NVDA	Stock	0.3672	0.3672	0.364	0.3658	35520720.0
2006-02-07 13:00:00	NVDA	Stock	0.3657	0.3663	0.364	0.3661	29370600.0
2006-02-07 14:00:00	NVDA	Stock	0.3661	0.3667	0.3643	0.3647	35839560.0
2006-02-07 15:00:00	NVDA	Stock	0.3647	0.366	0.3636	0.3642	72109920.0
2006-02-07 16:00:00	NVDA	Stock	0.3637	0.3653	0.3632	0.3646	1552680.0
2006-02-07 17:00:00	NVDA	Stock	0.3652	0.3652	0.3652	0.3652	60000.0
2006-02-07 18:00:00	NVDA	Stock	0.3637	0.3637	0.3637	0.3637	12600.0
2006-02-07 08:00:00	AMZN	Stock	1.9	1.9	1.9	1.9	2000.0
2006-02-07 09:00:00	AMZN	Stock	1.8995	1.91	1.8925	1.8955	23258980.0
2006-02-07 10:00:00	AMZN	Stock	1.895	1.905	1.8835	1.891	26536080.0
2006-02-07 11:00:00	AMZN	Stock	1.8915	1.8985	1.88	1.883	13442080.0
2006-02-07 12:00:00	AMZN	Stock	1.8825	1.885	1.8685	1.8715	18855680.0
2006-02-07 13:00:00	AMZN	Stock	1.8715	1.8735	1.86	1.87	17772200.0
2006-02-07 14:00:00	AMZN	Stock	1.87	1.878	1.864	1.8715	13925380.0
2006-02-07 15:00:00	AMZN	Stock	1.8715	1.8865	1.863	1.877	30612120.0
2006-02-07 16:00:00	AMZN	Stock	1.878	1.8855	1.875	1.882	615600.0
2006-02-07 17:00:00	AMZN	Stock	1.8845	1.8845	1.8815	1.8845	36000.0
2006-02-07 18:00:00	AMZN	Stock	1.876	1.8855	1.876	1.8855	7800.0

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

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