PREVIEW / stock_1hour / 2007-08-06

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-06.parquet
  size:    789 KB
  rows:    38,417
  symbols: 3,108

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-08-06 09:00:00	AAPL	Stock	4.7464	4.7679	4.5821	4.6625	171756312.0
2007-08-06 10:00:00	AAPL	Stock	4.6632	4.7446	4.6225	4.6739	174603100.0
2007-08-06 11:00:00	AAPL	Stock	4.6744	4.7393	4.6357	4.7096	126215320.0
2007-08-06 12:00:00	AAPL	Stock	4.7096	4.7704	4.6839	4.755	98787948.0
2007-08-06 13:00:00	AAPL	Stock	4.7543	4.7646	4.7232	4.7318	80811864.0
2007-08-06 14:00:00	AAPL	Stock	4.7318	4.8139	4.7246	4.7968	119018480.0
2007-08-06 15:00:00	AAPL	Stock	4.7968	4.8311	4.7864	4.8311	117679072.0
2007-08-06 16:00:00	AAPL	Stock	4.8282	4.8304	4.825	4.8304	10071376.0
2007-08-06 09:00:00	MSFT	Stock	29.05	29.18	29.018	29.18	5648893.0
2007-08-06 10:00:00	MSFT	Stock	29.18	29.22	28.97	28.99	10981821.0
2007-08-06 11:00:00	MSFT	Stock	28.98	29.22	28.75	29.18	8912931.0
2007-08-06 12:00:00	MSFT	Stock	29.18	29.38	29.13	29.3	6037548.0
2007-08-06 13:00:00	MSFT	Stock	29.3	29.32	29.05	29.065	4566481.0
2007-08-06 14:00:00	MSFT	Stock	29.075	29.34	29.05	29.29	7031131.0
2007-08-06 15:00:00	MSFT	Stock	29.28	29.54	29.24	29.54	10882087.0
2007-08-06 16:00:00	MSFT	Stock	29.52	29.54	29.52	29.54	3034290.0
2007-08-06 08:00:00	NVDA	Stock	0.7162	0.7225	0.7147	0.7158	1298400.0
2007-08-06 09:00:00	NVDA	Stock	0.7167	0.7203	0.7033	0.717	71001480.0
2007-08-06 10:00:00	NVDA	Stock	0.7167	0.717	0.695	0.7045	90916020.0
2007-08-06 11:00:00	NVDA	Stock	0.7043	0.7107	0.6987	0.7075	72320760.0
2007-08-06 12:00:00	NVDA	Stock	0.7072	0.7147	0.6993	0.705	52205760.0
2007-08-06 13:00:00	NVDA	Stock	0.705	0.7098	0.7007	0.7017	46867800.0
2007-08-06 14:00:00	NVDA	Stock	0.7013	0.7137	0.701	0.7025	58697580.0
2007-08-06 15:00:00	NVDA	Stock	0.7027	0.715	0.7025	0.7148	113153940.0
2007-08-06 16:00:00	NVDA	Stock	0.7135	0.7148	0.7108	0.7148	1253580.0
2007-08-06 17:00:00	NVDA	Stock	0.7148	0.715	0.7142	0.7142	364800.0
2007-08-06 19:00:00	NVDA	Stock	0.715	0.715	0.715	0.715	27000.0
2007-08-06 08:00:00	AMZN	Stock	3.8505	3.8755	3.8505	3.86	134560.0
2007-08-06 09:00:00	AMZN	Stock	3.86	3.9	3.83	3.898	24202540.0
2007-08-06 10:00:00	AMZN	Stock	3.8995	3.9385	3.861	3.9175	37744820.0
2007-08-06 11:00:00	AMZN	Stock	3.9175	3.9465	3.8865	3.9305	22961300.0
2007-08-06 12:00:00	AMZN	Stock	3.9295	3.9405	3.9025	3.922	13544980.0
2007-08-06 13:00:00	AMZN	Stock	3.922	3.93	3.875	3.879	13292860.0
2007-08-06 14:00:00	AMZN	Stock	3.8785	3.931	3.8725	3.902	25497180.0
2007-08-06 15:00:00	AMZN	Stock	3.902	3.95	3.898	3.95	30794820.0
2007-08-06 16:00:00	AMZN	Stock	3.947	3.95	3.945	3.945	350640.0
2007-08-06 17:00:00	AMZN	Stock	3.9455	3.95	3.945	3.945	3731060.0
2007-08-06 18:00:00	AMZN	Stock	3.945	3.95	3.945	3.9475	651900.0
2007-08-06 19:00:00	AMZN	Stock	3.945	3.95	3.945	3.95	39000.0
2007-08-06 09:00:00	TLT	Stock	87.7	87.7	87.53	87.55	163700.0
2007-08-06 10:00:00	TLT	Stock	87.52	87.72	87.52	87.55	102100.0
2007-08-06 11:00:00	TLT	Stock	87.58	87.65	87.54	87.57	102600.0
2007-08-06 12:00:00	TLT	Stock	87.59	87.64	87.45	87.47	125600.0
2007-08-06 13:00:00	TLT	Stock	87.48	87.5	87.36	87.39	145200.0
2007-08-06 14:00:00	TLT	Stock	87.37	87.4	87.27	87.36	40000.0
2007-08-06 15:00:00	TLT	Stock	87.35	87.4	87.17	87.24	592300.0
2007-08-06 16:00:00	TLT	Stock	87.26	87.29	87.26	87.29	11000.0
2007-08-06 09:00:00	CL	Stock	33.235	33.535	33.205	33.535	429790.0
2007-08-06 10:00:00	CL	Stock	33.52	33.73	33.48	33.565	827804.0
2007-08-06 11:00:00	CL	Stock	33.57	33.78	33.56	33.675	642578.0

> showing 50 of 38,417 rows — these rows as CSV

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