PREVIEW / stock_1hour / 2006-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-13.parquet
  size:    610 KB
  rows:    29,197
  symbols: 2,364

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-09-13 04:00:00	AAPL	Stock	2.5982	2.5982	2.5982	2.5982	140000.0
2006-09-13 06:00:00	AAPL	Stock	2.6018	2.6018	2.6018	2.6018	11200.0
2006-09-13 07:00:00	AAPL	Stock	2.6071	2.6114	2.6061	2.6061	19600.0
2006-09-13 08:00:00	AAPL	Stock	2.6071	2.6136	2.6054	2.6089	5612908.0
2006-09-13 09:00:00	AAPL	Stock	2.6093	2.6386	2.5889	2.6225	206352664.0
2006-09-13 10:00:00	AAPL	Stock	2.6221	2.6229	2.5821	2.6021	251956460.0
2006-09-13 11:00:00	AAPL	Stock	2.6018	2.636	2.6007	2.6082	121965788.0
2006-09-13 12:00:00	AAPL	Stock	2.6082	2.6118	2.6029	2.6096	81549440.0
2006-09-13 13:00:00	AAPL	Stock	2.6096	2.6268	2.6093	2.6161	113374576.0
2006-09-13 14:00:00	AAPL	Stock	2.6157	2.6407	2.6129	2.6386	134881152.0
2006-09-13 15:00:00	AAPL	Stock	2.6386	2.6543	2.6189	2.6475	218865752.0
2006-09-13 16:00:00	AAPL	Stock	2.6475	2.6518	2.6464	2.6493	1888208.0
2006-09-13 17:00:00	AAPL	Stock	2.6489	2.65	2.6464	2.65	476532.0
2006-09-13 18:00:00	AAPL	Stock	2.65	2.6514	2.6482	2.65	112028.0
2006-09-13 07:00:00	MSFT	Stock	25.92	25.92	25.92	25.92	500.0
2006-09-13 08:00:00	MSFT	Stock	25.9	25.93	25.87	25.88	26536.0
2006-09-13 09:00:00	MSFT	Stock	25.88	25.97	25.81	25.95	3905549.0
2006-09-13 10:00:00	MSFT	Stock	25.94	26.1	25.87	25.91	6854634.0
2006-09-13 11:00:00	MSFT	Stock	25.9	25.96	25.89	25.93	4562457.0
2006-09-13 12:00:00	MSFT	Stock	25.94	25.97	25.89	25.91	4214046.0
2006-09-13 13:00:00	MSFT	Stock	25.913	25.931	25.49	25.91	3874802.0
2006-09-13 14:00:00	MSFT	Stock	25.9	25.97	25.89	25.96	4140313.0
2006-09-13 15:00:00	MSFT	Stock	25.96	26.0	25.9	25.98	8230946.0
2006-09-13 16:00:00	MSFT	Stock	25.98	26.05	25.914	26.04	892981.0
2006-09-13 17:00:00	MSFT	Stock	26.0	26.02	26.0	26.0	373545.0
2006-09-13 18:00:00	MSFT	Stock	26.0	26.01	26.0	26.01	236400.0
2006-09-13 08:00:00	NVDA	Stock	0.4808	0.4848	0.4808	0.4843	120600.0
2006-09-13 09:00:00	NVDA	Stock	0.4833	0.491	0.4808	0.4883	70956480.0
2006-09-13 10:00:00	NVDA	Stock	0.4883	0.4886	0.4812	0.4828	87724560.0
2006-09-13 11:00:00	NVDA	Stock	0.483	0.4858	0.4827	0.4857	50111280.0
2006-09-13 12:00:00	NVDA	Stock	0.4857	0.4873	0.4833	0.4835	38195940.0
2006-09-13 13:00:00	NVDA	Stock	0.4835	0.4862	0.4832	0.486	35886240.0
2006-09-13 14:00:00	NVDA	Stock	0.486	0.4913	0.4858	0.489	87519840.0
2006-09-13 15:00:00	NVDA	Stock	0.489	0.4897	0.4837	0.4843	89262540.0
2006-09-13 16:00:00	NVDA	Stock	0.4845	0.4857	0.4837	0.4853	5748000.0
2006-09-13 17:00:00	NVDA	Stock	0.4857	0.4858	0.4853	0.4853	138000.0
2006-09-13 18:00:00	NVDA	Stock	0.4857	0.4857	0.4852	0.4852	186000.0
2006-09-13 08:00:00	AMZN	Stock	1.586	1.5875	1.586	1.5875	27580.0
2006-09-13 09:00:00	AMZN	Stock	1.592	1.595	1.573	1.589	11662780.0
2006-09-13 10:00:00	AMZN	Stock	1.588	1.59	1.5685	1.582	16541780.0
2006-09-13 11:00:00	AMZN	Stock	1.5815	1.598	1.5805	1.596	10466460.0
2006-09-13 12:00:00	AMZN	Stock	1.5955	1.597	1.578	1.578	8982220.0
2006-09-13 13:00:00	AMZN	Stock	1.5785	1.5855	1.578	1.5785	6217080.0
2006-09-13 14:00:00	AMZN	Stock	1.5795	1.59	1.5785	1.5885	8570320.0
2006-09-13 15:00:00	AMZN	Stock	1.5885	1.589	1.5795	1.583	17578420.0
2006-09-13 16:00:00	AMZN	Stock	1.5825	1.589	1.5815	1.5815	77000.0
2006-09-13 09:00:00	CL	Stock	30.945	31.01	30.915	31.0	602400.0
2006-09-13 10:00:00	CL	Stock	31.0	31.025	30.75	30.79	894800.0
2006-09-13 11:00:00	CL	Stock	30.79	30.825	30.656	30.68	938600.0
2006-09-13 12:00:00	CL	Stock	30.67	30.755	30.59	30.6	348600.0

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

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