PREVIEW / stock_1hour / 2006-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-31.parquet
  size:    604 KB
  rows:    29,182
  symbols: 2,318

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-07-31 06:00:00	AAPL	Stock	2.3821	2.3821	2.3821	2.3821	33600.0
2006-07-31 07:00:00	AAPL	Stock	2.3793	2.3829	2.3732	2.3829	129836.0
2006-07-31 08:00:00	AAPL	Stock	2.3821	2.4018	2.3796	2.3914	10035452.0
2006-07-31 09:00:00	AAPL	Stock	2.3889	2.3964	2.3671	2.3896	150316684.0
2006-07-31 10:00:00	AAPL	Stock	2.3896	2.4511	2.3875	2.4343	278137664.0
2006-07-31 11:00:00	AAPL	Stock	2.4343	2.4393	2.4204	2.4268	97356056.0
2006-07-31 12:00:00	AAPL	Stock	2.4268	2.4354	2.4211	2.4214	66265052.0
2006-07-31 13:00:00	AAPL	Stock	2.4218	2.4389	2.4214	2.4289	74639572.0
2006-07-31 14:00:00	AAPL	Stock	2.4289	2.4314	2.4193	2.4268	61879552.0
2006-07-31 15:00:00	AAPL	Stock	2.4264	2.4371	2.4161	2.4246	124241796.0
2006-07-31 16:00:00	AAPL	Stock	2.425	2.4271	2.4221	2.4268	1945132.0
2006-07-31 17:00:00	AAPL	Stock	2.425	2.4271	2.4232	2.4264	3005632.0
2006-07-31 18:00:00	AAPL	Stock	2.4268	2.4271	2.4246	2.4268	51548.0
2006-07-31 08:00:00	MSFT	Stock	24.23	24.24	24.21	24.22	2690.0
2006-07-31 09:00:00	MSFT	Stock	24.16	24.34	24.07	24.34	5254274.0
2006-07-31 10:00:00	MSFT	Stock	24.34	24.42	24.27	24.3	5002482.0
2006-07-31 11:00:00	MSFT	Stock	24.3	24.33	24.11	24.11	4864767.0
2006-07-31 12:00:00	MSFT	Stock	24.11	24.24	24.08	24.17	3919310.0
2006-07-31 13:00:00	MSFT	Stock	24.17	24.28	24.11	24.188	3788474.0
2006-07-31 14:00:00	MSFT	Stock	24.18	24.22	24.11	24.13	3534054.0
2006-07-31 15:00:00	MSFT	Stock	24.13	24.17	24.01	24.07	9107313.0
2006-07-31 16:00:00	MSFT	Stock	24.07	24.17	24.03	24.14	1631416.0
2006-07-31 17:00:00	MSFT	Stock	24.13	24.15	24.03	24.03	13033.0
2006-07-31 18:00:00	MSFT	Stock	24.03	24.12	24.03	24.12	1438.0
2006-07-31 08:00:00	NVDA	Stock	0.3778	0.3788	0.3778	0.3778	194700.0
2006-07-31 09:00:00	NVDA	Stock	0.3773	0.3775	0.3703	0.3727	59274780.0
2006-07-31 10:00:00	NVDA	Stock	0.3727	0.3763	0.3687	0.3762	96559860.0
2006-07-31 11:00:00	NVDA	Stock	0.3762	0.3777	0.3708	0.3723	77782440.0
2006-07-31 12:00:00	NVDA	Stock	0.3723	0.3727	0.3692	0.3692	42154680.0
2006-07-31 13:00:00	NVDA	Stock	0.3693	0.3705	0.368	0.37	64989360.0
2006-07-31 14:00:00	NVDA	Stock	0.37	0.3718	0.3693	0.3702	74932860.0
2006-07-31 15:00:00	NVDA	Stock	0.3703	0.3707	0.3687	0.369	87852720.0
2006-07-31 16:00:00	NVDA	Stock	0.3688	0.37	0.3682	0.3682	2192760.0
2006-07-31 17:00:00	NVDA	Stock	0.369	0.37	0.3667	0.37	173280.0
2006-07-31 07:00:00	AMZN	Stock	1.3585	1.3585	1.3585	1.3585	8000.0
2006-07-31 08:00:00	AMZN	Stock	1.355	1.359	1.3425	1.3425	263000.0
2006-07-31 09:00:00	AMZN	Stock	1.3425	1.356	1.337	1.3495	22081200.0
2006-07-31 10:00:00	AMZN	Stock	1.3495	1.3645	1.347	1.352	18406360.0
2006-07-31 11:00:00	AMZN	Stock	1.352	1.358	1.3515	1.3525	13493160.0
2006-07-31 12:00:00	AMZN	Stock	1.352	1.354	1.3445	1.3465	30715300.0
2006-07-31 13:00:00	AMZN	Stock	1.3465	1.35	1.3445	1.3471	18354800.0
2006-07-31 14:00:00	AMZN	Stock	1.3475	1.348	1.344	1.3445	17789340.0
2006-07-31 15:00:00	AMZN	Stock	1.344	1.3455	1.3395	1.3425	25671200.0
2006-07-31 16:00:00	AMZN	Stock	1.3435	1.347	1.3395	1.3415	431380.0
2006-07-31 17:00:00	AMZN	Stock	1.3415	1.3415	1.341	1.341	12000.0
2006-07-31 18:00:00	AMZN	Stock	1.344	1.3485	1.3175	1.335	730160.0
2006-07-31 09:00:00	CL	Stock	29.71	29.76	29.61	29.705	307400.0
2006-07-31 10:00:00	CL	Stock	29.715	29.93	29.7	29.77	545200.0
2006-07-31 11:00:00	CL	Stock	29.755	29.805	29.74	29.775	369000.0
2006-07-31 12:00:00	CL	Stock	29.785	29.96	29.775	29.935	489600.0

> showing 50 of 29,182 rows — these rows as CSV

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