PREVIEW / stock_1hour / 2007-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-26.parquet
  size:    804 KB
  rows:    39,855
  symbols: 3,152

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-26 05:00:00	AAPL	Stock	6.6071	6.6071	6.6071	6.6071	5600.0
2007-10-26 06:00:00	AAPL	Stock	6.6018	6.6061	6.6018	6.6061	45472.0
2007-10-26 07:00:00	AAPL	Stock	6.6071	6.6146	6.5714	6.5714	1325436.0
2007-10-26 08:00:00	AAPL	Stock	6.5786	6.5996	6.5443	6.5893	4700612.0
2007-10-26 09:00:00	AAPL	Stock	6.5925	6.6204	6.5314	6.5504	115712072.0
2007-10-26 10:00:00	AAPL	Stock	6.5482	6.5975	6.5357	6.5868	126467096.0
2007-10-26 11:00:00	AAPL	Stock	6.5868	6.6036	6.5575	6.5689	94078796.0
2007-10-26 12:00:00	AAPL	Stock	6.5679	6.6	6.5589	6.5939	73492132.0
2007-10-26 13:00:00	AAPL	Stock	6.5932	6.6157	6.5861	6.6061	83502160.0
2007-10-26 14:00:00	AAPL	Stock	6.6057	6.6139	6.5882	6.5918	93569980.0
2007-10-26 15:00:00	AAPL	Stock	6.5918	6.6071	6.5768	6.5964	104618024.0
2007-10-26 16:00:00	AAPL	Stock	6.5964	6.6017	6.576	6.5864	8424220.0
2007-10-26 17:00:00	AAPL	Stock	6.5864	6.5925	6.5839	6.5857	382704.0
2007-10-26 18:00:00	AAPL	Stock	6.5821	6.5857	6.5811	6.5857	344484.0
2007-10-26 19:00:00	AAPL	Stock	6.5857	6.5911	6.5839	6.5904	320012.0
2007-10-26 04:00:00	MSFT	Stock	35.14	35.14	35.05	35.05	25000.0
2007-10-26 05:00:00	MSFT	Stock	35.11	35.11	35.11	35.11	1000.0
2007-10-26 06:00:00	MSFT	Stock	35.25	35.37	35.25	35.3	15140.0
2007-10-26 07:00:00	MSFT	Stock	35.37	39.95	35.37	36.05	1332489.0
2007-10-26 08:00:00	MSFT	Stock	36.05	36.55	35.75	36.08	11631669.0
2007-10-26 09:00:00	MSFT	Stock	36.07	36.28	35.0	35.3	79675899.0
2007-10-26 10:00:00	MSFT	Stock	35.3	36.0	35.28	35.372	48968664.0
2007-10-26 11:00:00	MSFT	Stock	35.37	35.6	35.08	35.09	31296400.0
2007-10-26 12:00:00	MSFT	Stock	35.11	35.29	34.9	35.08	29399535.0
2007-10-26 13:00:00	MSFT	Stock	35.07	35.08	34.62	34.78	23559565.0
2007-10-26 14:00:00	MSFT	Stock	34.78	35.04	34.56	34.83	24383010.0
2007-10-26 15:00:00	MSFT	Stock	34.82	35.13	34.58	35.07	35986024.0
2007-10-26 16:00:00	MSFT	Stock	35.07	35.72	34.892	35.09	4172322.0
2007-10-26 17:00:00	MSFT	Stock	35.03	35.542	35.011	35.03	924824.0
2007-10-26 18:00:00	MSFT	Stock	35.04	35.09	35.03	35.03	23339.0
2007-10-26 19:00:00	MSFT	Stock	35.03	35.06	35.03	35.03	11512.0
2007-10-26 06:00:00	NVDA	Stock	0.8825	0.8825	0.8825	0.8825	8000.0
2007-10-26 07:00:00	NVDA	Stock	0.89	0.89	0.89	0.89	20000.0
2007-10-26 08:00:00	NVDA	Stock	0.8888	0.8982	0.8675	0.8888	1260760.0
2007-10-26 09:00:00	NVDA	Stock	0.8938	0.901	0.8695	0.877	100081560.0
2007-10-26 10:00:00	NVDA	Stock	0.8768	0.8963	0.8695	0.8855	68482160.0
2007-10-26 11:00:00	NVDA	Stock	0.8855	0.9	0.8652	0.867	53462440.0
2007-10-26 12:00:00	NVDA	Stock	0.8668	0.8678	0.8555	0.8588	75071480.0
2007-10-26 13:00:00	NVDA	Stock	0.8588	0.8605	0.852	0.8525	88194600.0
2007-10-26 14:00:00	NVDA	Stock	0.8525	0.8565	0.8498	0.8523	100005160.0
2007-10-26 15:00:00	NVDA	Stock	0.8515	0.86	0.8475	0.86	117230280.0
2007-10-26 16:00:00	NVDA	Stock	0.86	0.8673	0.8544	0.8575	5144080.0
2007-10-26 17:00:00	NVDA	Stock	0.8595	0.8626	0.8575	0.8595	211600.0
2007-10-26 18:00:00	NVDA	Stock	0.8578	0.8592	0.8578	0.8592	15000.0
2007-10-26 19:00:00	NVDA	Stock	0.8575	0.8575	0.8562	0.8562	47400.0
2007-10-26 07:00:00	AMZN	Stock	4.425	4.425	4.425	4.425	6000.0
2007-10-26 08:00:00	AMZN	Stock	4.432	4.4375	4.425	4.4335	261100.0
2007-10-26 09:00:00	AMZN	Stock	4.4365	4.485	4.394	4.4085	24640580.0
2007-10-26 10:00:00	AMZN	Stock	4.4085	4.446	4.39	4.406	24879020.0
2007-10-26 11:00:00	AMZN	Stock	4.406	4.4845	4.3875	4.3935	18777240.0

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

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