PREVIEW / stock_1hour / 2007-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-23.parquet
  size:    671 KB
  rows:    31,789
  symbols: 2,550

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-03-23 07:00:00	AAPL	Stock	3.3536	3.3536	3.3536	3.3536	2800.0
2007-03-23 08:00:00	AAPL	Stock	3.3496	3.35	3.3125	3.3268	5081916.0
2007-03-23 09:00:00	AAPL	Stock	3.3268	3.3482	3.3268	3.3432	54146008.0
2007-03-23 10:00:00	AAPL	Stock	3.3436	3.3596	3.3346	3.3368	117529664.0
2007-03-23 11:00:00	AAPL	Stock	3.3364	3.3557	3.3361	3.3511	74614652.0
2007-03-23 12:00:00	AAPL	Stock	3.3514	3.3532	3.3446	3.3471	38596852.0
2007-03-23 13:00:00	AAPL	Stock	3.3475	3.3489	3.3382	3.3468	41118364.0
2007-03-23 14:00:00	AAPL	Stock	3.3468	3.3479	3.3414	3.3439	37374624.0
2007-03-23 15:00:00	AAPL	Stock	3.3443	3.3518	3.34	3.34	71526700.0
2007-03-23 16:00:00	AAPL	Stock	3.3411	3.3418	3.3386	3.3386	5933732.0
2007-03-23 17:00:00	AAPL	Stock	3.3393	3.3396	3.3386	3.3396	290556.0
2007-03-23 18:00:00	AAPL	Stock	3.3396	3.3414	3.339	3.3414	172872.0
2007-03-23 19:00:00	AAPL	Stock	3.3418	3.3418	3.3393	3.3414	80724.0
2007-03-23 07:00:00	MSFT	Stock	28.26	28.26	28.26	28.26	500.0
2007-03-23 08:00:00	MSFT	Stock	28.27	28.28	28.16	28.25	9869.0
2007-03-23 09:00:00	MSFT	Stock	28.2	28.27	27.8	27.928	6450427.0
2007-03-23 10:00:00	MSFT	Stock	27.93	28.16	27.93	28.1	10105152.0
2007-03-23 11:00:00	MSFT	Stock	28.091	28.18	28.05	28.12	3851641.0
2007-03-23 12:00:00	MSFT	Stock	28.13	28.2	27.95	28.06	6463454.0
2007-03-23 13:00:00	MSFT	Stock	28.05	28.1	28.01	28.06	2497459.0
2007-03-23 14:00:00	MSFT	Stock	28.06	28.1	27.95	28.07	4462250.0
2007-03-23 15:00:00	MSFT	Stock	28.07	28.15	27.97	27.99	13820384.0
2007-03-23 16:00:00	MSFT	Stock	28.01	28.03	27.97	27.97	1586718.0
2007-03-23 17:00:00	MSFT	Stock	27.98	27.98	27.97	27.98	2350.0
2007-03-23 18:00:00	MSFT	Stock	27.98	28.001	27.98	28.0	8223.0
2007-03-23 19:00:00	MSFT	Stock	28.0	28.0	27.98	27.98	244.0
2007-03-23 07:00:00	NVDA	Stock	0.5108	0.5108	0.5108	0.5108	12000.0
2007-03-23 08:00:00	NVDA	Stock	0.511	0.511	0.511	0.511	90000.0
2007-03-23 09:00:00	NVDA	Stock	0.5108	0.5157	0.5063	0.5105	65111340.0
2007-03-23 10:00:00	NVDA	Stock	0.5107	0.5127	0.5067	0.5077	99506340.0
2007-03-23 11:00:00	NVDA	Stock	0.5077	0.5078	0.5054	0.5067	77043060.0
2007-03-23 12:00:00	NVDA	Stock	0.5068	0.5093	0.5062	0.5062	46355400.0
2007-03-23 13:00:00	NVDA	Stock	0.5062	0.5067	0.5023	0.5035	54322500.0
2007-03-23 14:00:00	NVDA	Stock	0.5035	0.5062	0.5012	0.506	76754040.0
2007-03-23 15:00:00	NVDA	Stock	0.506	0.507	0.5045	0.5045	76707960.0
2007-03-23 16:00:00	NVDA	Stock	0.5045	0.5048	0.5038	0.5042	6376560.0
2007-03-23 18:00:00	NVDA	Stock	0.5043	0.5045	0.5043	0.5045	144480.0
2007-03-23 19:00:00	NVDA	Stock	0.5045	0.5045	0.5045	0.5045	30000.0
2007-03-23 09:00:00	AMZN	Stock	1.9755	1.98	1.9555	1.96	8826680.0
2007-03-23 10:00:00	AMZN	Stock	1.9595	1.972	1.9595	1.9695	7525400.0
2007-03-23 11:00:00	AMZN	Stock	1.9685	1.971	1.9645	1.9695	4898340.0
2007-03-23 12:00:00	AMZN	Stock	1.9695	1.972	1.9651	1.967	3951680.0
2007-03-23 13:00:00	AMZN	Stock	1.9675	1.97	1.955	1.9575	6332280.0
2007-03-23 14:00:00	AMZN	Stock	1.9575	1.958	1.9495	1.9545	8058500.0
2007-03-23 15:00:00	AMZN	Stock	1.954	1.958	1.949	1.949	15246720.0
2007-03-23 16:00:00	AMZN	Stock	1.951	1.951	1.949	1.949	290300.0
2007-03-23 18:00:00	AMZN	Stock	1.949	1.949	1.949	1.949	7360.0
2007-03-23 09:00:00	CL	Stock	33.5	33.51	33.415	33.455	213200.0
2007-03-23 10:00:00	CL	Stock	33.46	33.575	33.38	33.41	506200.0
2007-03-23 11:00:00	CL	Stock	33.405	33.51	33.375	33.465	358200.0

> showing 50 of 31,789 rows — these rows as CSV

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