PREVIEW / stock_1hour / 2007-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-24.parquet
  size:    794 KB
  rows:    39,221
  symbols: 3,164

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-10-24 05:00:00	AAPL	Stock	6.5821	6.5982	6.5821	6.5982	56000.0
2007-10-24 06:00:00	AAPL	Stock	6.5982	6.5982	6.5825	6.5854	170240.0
2007-10-24 07:00:00	AAPL	Stock	6.6018	6.6018	6.5721	6.5857	392392.0
2007-10-24 08:00:00	AAPL	Stock	6.5893	6.6486	6.5714	6.6125	4838064.0
2007-10-24 09:00:00	AAPL	Stock	6.6129	6.6861	6.5914	6.6575	159321876.0
2007-10-24 10:00:00	AAPL	Stock	6.6575	6.6589	6.5014	6.5425	234044468.0
2007-10-24 11:00:00	AAPL	Stock	6.5429	6.5436	6.4014	6.5304	247572248.0
2007-10-24 12:00:00	AAPL	Stock	6.5307	6.5779	6.5093	6.5314	121408392.0
2007-10-24 13:00:00	AAPL	Stock	6.5314	6.5371	6.4718	6.4939	92459920.0
2007-10-24 14:00:00	AAPL	Stock	6.4929	6.5664	6.4396	6.5589	171527104.0
2007-10-24 15:00:00	AAPL	Stock	6.5586	6.6511	6.5468	6.6393	236533948.0
2007-10-24 16:00:00	AAPL	Stock	6.6393	6.6571	6.5023	6.6568	16728908.0
2007-10-24 17:00:00	AAPL	Stock	6.6554	6.6571	6.6404	6.6461	1971172.0
2007-10-24 18:00:00	AAPL	Stock	6.6464	6.6482	6.6286	6.6393	947044.0
2007-10-24 19:00:00	AAPL	Stock	6.6386	6.6393	6.625	6.6254	533120.0
2007-10-24 07:00:00	MSFT	Stock	30.75	30.82	30.75	30.82	4000.0
2007-10-24 08:00:00	MSFT	Stock	30.85	30.92	30.81	30.83	53605.0
2007-10-24 09:00:00	MSFT	Stock	30.83	31.15	30.81	31.15	6853074.0
2007-10-24 10:00:00	MSFT	Stock	31.15	31.2	30.82	30.9	11822386.0
2007-10-24 11:00:00	MSFT	Stock	30.899	30.93	30.5	30.72	12209405.0
2007-10-24 12:00:00	MSFT	Stock	30.725	30.9	30.64	30.83	7232818.0
2007-10-24 13:00:00	MSFT	Stock	30.82	30.9	30.75	30.79	5453119.0
2007-10-24 14:00:00	MSFT	Stock	30.78	30.95	30.69	30.93	11115332.0
2007-10-24 15:00:00	MSFT	Stock	30.92	31.3	30.86	31.28	18446333.0
2007-10-24 16:00:00	MSFT	Stock	31.28	31.55	30.744	31.45	4682352.0
2007-10-24 17:00:00	MSFT	Stock	31.44	31.5	30.9	31.5	295944.0
2007-10-24 18:00:00	MSFT	Stock	31.51	31.57	31.5	31.55	66595.0
2007-10-24 19:00:00	MSFT	Stock	31.57	31.6	31.51	31.6	24522.0
2007-10-24 08:00:00	NVDA	Stock	0.9738	0.9738	0.96	0.9613	476120.0
2007-10-24 09:00:00	NVDA	Stock	0.9613	0.9645	0.9475	0.9505	83426160.0
2007-10-24 10:00:00	NVDA	Stock	0.9502	0.9502	0.9225	0.9258	114422520.0
2007-10-24 11:00:00	NVDA	Stock	0.9257	0.926	0.9038	0.9215	92333640.0
2007-10-24 12:00:00	NVDA	Stock	0.9215	0.9305	0.9125	0.9165	62799920.0
2007-10-24 13:00:00	NVDA	Stock	0.9165	0.92	0.914	0.9152	34633800.0
2007-10-24 14:00:00	NVDA	Stock	0.9152	0.9293	0.9088	0.9283	67326040.0
2007-10-24 15:00:00	NVDA	Stock	0.928	0.9505	0.927	0.9505	102146960.0
2007-10-24 16:00:00	NVDA	Stock	0.9505	0.9525	0.9309	0.9505	7395480.0
2007-10-24 17:00:00	NVDA	Stock	0.9505	0.9535	0.9505	0.9525	532400.0
2007-10-24 18:00:00	NVDA	Stock	0.9525	0.9545	0.9525	0.9545	143200.0
2007-10-24 19:00:00	NVDA	Stock	0.9538	0.9538	0.95	0.95	54400.0
2007-10-24 06:00:00	AMZN	Stock	4.5425	4.545	4.5425	4.5445	44000.0
2007-10-24 07:00:00	AMZN	Stock	4.5055	4.6245	4.5055	4.5655	1193660.0
2007-10-24 08:00:00	AMZN	Stock	4.54	4.612	4.508	4.5555	19083520.0
2007-10-24 09:00:00	AMZN	Stock	4.5565	4.5935	4.385	4.4585	179486920.0
2007-10-24 10:00:00	AMZN	Stock	4.4575	4.458	4.2265	4.2485	183585980.0
2007-10-24 11:00:00	AMZN	Stock	4.2485	4.3321	4.1635	4.2385	124199100.0
2007-10-24 12:00:00	AMZN	Stock	4.24	4.323	4.238	4.313	73260000.0
2007-10-24 13:00:00	AMZN	Stock	4.3125	4.4	4.225	4.257	50743040.0
2007-10-24 14:00:00	AMZN	Stock	4.257	4.3855	4.243	4.376	82110500.0
2007-10-24 15:00:00	AMZN	Stock	4.376	4.4865	4.3545	4.435	110613320.0

> showing 50 of 39,221 rows — these rows as CSV

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