PREVIEW / stock_1hour / 2010-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-15.parquet
  size:    935 KB
  rows:    44,225
  symbols: 3,541

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
2010-12-15 04:00:00	AAPL	Stock	11.3946	11.4107	11.3946	11.4107	5600.0
2010-12-15 05:00:00	AAPL	Stock	11.4107	11.4107	11.3982	11.3982	18340.0
2010-12-15 06:00:00	AAPL	Stock	11.4107	11.4518	11.4107	11.4514	19600.0
2010-12-15 07:00:00	AAPL	Stock	11.4314	11.4629	11.4314	11.4443	202216.0
2010-12-15 08:00:00	AAPL	Stock	11.4379	11.4518	11.3971	11.4086	2800728.0
2010-12-15 09:00:00	AAPL	Stock	11.4089	11.4732	11.4089	11.4429	49301252.0
2010-12-15 10:00:00	AAPL	Stock	11.4432	11.5357	11.4214	11.5132	86327864.0
2010-12-15 11:00:00	AAPL	Stock	11.5114	11.5154	11.4579	11.4775	39092060.0
2010-12-15 12:00:00	AAPL	Stock	11.4768	11.4821	11.425	11.4329	30304008.0
2010-12-15 13:00:00	AAPL	Stock	11.4339	11.4569	11.4175	11.4532	33265372.0
2010-12-15 14:00:00	AAPL	Stock	11.4543	11.4614	11.3996	11.4146	46766132.0
2010-12-15 15:00:00	AAPL	Stock	11.4125	11.4589	11.4093	11.4429	60523764.0
2010-12-15 16:00:00	AAPL	Stock	11.4429	11.4821	11.4371	11.4604	58226840.0
2010-12-15 17:00:00	AAPL	Stock	11.4604	11.4621	11.4557	11.4571	293776.0
2010-12-15 18:00:00	AAPL	Stock	11.4582	11.4589	11.4414	11.4464	824544.0
2010-12-15 19:00:00	AAPL	Stock	11.4468	11.4482	11.4018	11.4164	953456.0
2010-12-15 06:00:00	MSFT	Stock	27.43	27.57	27.43	27.57	600.0
2010-12-15 07:00:00	MSFT	Stock	27.61	27.65	27.61	27.64	1000.0
2010-12-15 08:00:00	MSFT	Stock	27.62	27.73	27.62	27.7	44953.0
2010-12-15 09:00:00	MSFT	Stock	27.7	27.73	27.53	27.67	7805717.0
2010-12-15 10:00:00	MSFT	Stock	27.665	27.93	27.6	27.89	9076779.0
2010-12-15 11:00:00	MSFT	Stock	27.884	27.97	27.84	27.965	6381251.0
2010-12-15 12:00:00	MSFT	Stock	27.96	27.99	27.761	27.82	6467239.0
2010-12-15 13:00:00	MSFT	Stock	27.825	27.835	27.71	27.79	4966888.0
2010-12-15 14:00:00	MSFT	Stock	27.8	27.84	27.68	27.77	5763418.0
2010-12-15 15:00:00	MSFT	Stock	27.77	27.98	27.76	27.86	14018335.0
2010-12-15 16:00:00	MSFT	Stock	27.85	27.94	27.63	27.9	13381687.0
2010-12-15 17:00:00	MSFT	Stock	27.94	27.94	27.833	27.94	30700.0
2010-12-15 18:00:00	MSFT	Stock	27.91	27.94	27.85	27.9	46339.0
2010-12-15 19:00:00	MSFT	Stock	27.88	27.95	27.85	27.94	15010.0
2010-12-15 08:00:00	NVDA	Stock	0.3725	0.3725	0.3655	0.3655	219200.0
2010-12-15 09:00:00	NVDA	Stock	0.3672	0.3672	0.3612	0.3638	76285720.0
2010-12-15 10:00:00	NVDA	Stock	0.3636	0.37	0.3632	0.3695	70704160.0
2010-12-15 11:00:00	NVDA	Stock	0.3695	0.3695	0.365	0.3652	52182200.0
2010-12-15 12:00:00	NVDA	Stock	0.3652	0.3659	0.3618	0.3621	47830120.0
2010-12-15 13:00:00	NVDA	Stock	0.3622	0.3635	0.3605	0.3615	38250600.0
2010-12-15 14:00:00	NVDA	Stock	0.3615	0.3622	0.3592	0.3598	61353720.0
2010-12-15 15:00:00	NVDA	Stock	0.3598	0.361	0.3562	0.3568	217509680.0
2010-12-15 16:00:00	NVDA	Stock	0.3568	0.3622	0.3567	0.3575	55225160.0
2010-12-15 17:00:00	NVDA	Stock	0.357	0.357	0.357	0.357	4000.0
2010-12-15 18:00:00	NVDA	Stock	0.3562	0.3562	0.3562	0.3562	4000.0
2010-12-15 19:00:00	NVDA	Stock	0.357	0.357	0.357	0.357	9000.0
2010-12-15 08:00:00	AMZN	Stock	8.7005	8.7125	8.6875	8.6895	197860.0
2010-12-15 09:00:00	AMZN	Stock	8.6905	8.8	8.6796	8.797	12446120.0
2010-12-15 10:00:00	AMZN	Stock	8.797	8.95	8.7802	8.922	31606480.0
2010-12-15 11:00:00	AMZN	Stock	8.922	8.9335	8.833	8.856	14214260.0
2010-12-15 12:00:00	AMZN	Stock	8.856	8.881	8.8115	8.8165	9341420.0
2010-12-15 13:00:00	AMZN	Stock	8.815	8.8245	8.756	8.8115	14115480.0
2010-12-15 14:00:00	AMZN	Stock	8.813	8.826	8.7575	8.7865	9039740.0
2010-12-15 15:00:00	AMZN	Stock	8.788	8.818	8.7675	8.7785	17448340.0

> showing 50 of 44,225 rows — these rows as CSV

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