PREVIEW / stock_1hour / 2006-02-15

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-15.parquet
  size:    598 KB
  rows:    28,355
  symbols: 2,189

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-02-15 08:00:00	AAPL	Stock	2.4071	2.4121	2.3971	2.4071	2132424.0
2006-02-15 09:00:00	AAPL	Stock	2.4071	2.4629	2.3839	2.455	223828444.0
2006-02-15 10:00:00	AAPL	Stock	2.4546	2.4864	2.4336	2.4675	306113052.0
2006-02-15 11:00:00	AAPL	Stock	2.4675	2.4714	2.4475	2.4675	159939080.0
2006-02-15 12:00:00	AAPL	Stock	2.4675	2.4682	2.4364	2.4521	115966732.0
2006-02-15 13:00:00	AAPL	Stock	2.4521	2.4757	2.4504	2.4725	103240088.0
2006-02-15 14:00:00	AAPL	Stock	2.4729	2.4764	2.4604	2.4696	95353860.0
2006-02-15 15:00:00	AAPL	Stock	2.4696	2.4732	2.4561	2.4725	121878232.0
2006-02-15 16:00:00	AAPL	Stock	2.4729	2.4779	2.4646	2.4768	3373300.0
2006-02-15 17:00:00	AAPL	Stock	2.4761	2.4786	2.4721	2.4786	13648460.0
2006-02-15 18:00:00	AAPL	Stock	2.4793	2.4821	2.4782	2.4821	296044.0
2006-02-15 08:00:00	MSFT	Stock	26.62	26.65	26.54	26.59	11421.0
2006-02-15 09:00:00	MSFT	Stock	26.59	26.75	26.5	26.7	4293328.0
2006-02-15 10:00:00	MSFT	Stock	26.69	26.86	26.63	26.85	10943120.0
2006-02-15 11:00:00	MSFT	Stock	26.86	26.88	26.72	26.8	10937904.0
2006-02-15 12:00:00	MSFT	Stock	26.8	26.87	26.72	26.76	5725058.0
2006-02-15 13:00:00	MSFT	Stock	26.76	26.85	26.75	26.83	6755407.0
2006-02-15 14:00:00	MSFT	Stock	26.83	26.92	26.77	26.892	9886777.0
2006-02-15 15:00:00	MSFT	Stock	26.9	26.93	26.81	26.87	11302008.0
2006-02-15 16:00:00	MSFT	Stock	26.87	26.9	26.86	26.88	183367.0
2006-02-15 17:00:00	MSFT	Stock	26.89	26.9	26.87	26.87	764363.0
2006-02-15 18:00:00	MSFT	Stock	26.85	26.88	26.85	26.88	2432.0
2006-02-15 09:00:00	NVDA	Stock	0.3666	0.3706	0.3661	0.37	47562720.0
2006-02-15 10:00:00	NVDA	Stock	0.3699	0.3753	0.3697	0.3713	100266000.0
2006-02-15 11:00:00	NVDA	Stock	0.3712	0.3736	0.3691	0.3735	49159440.0
2006-02-15 12:00:00	NVDA	Stock	0.3736	0.3742	0.3707	0.3732	88085520.0
2006-02-15 13:00:00	NVDA	Stock	0.373	0.3758	0.3722	0.3747	48290520.0
2006-02-15 14:00:00	NVDA	Stock	0.3743	0.3758	0.3735	0.3754	56123280.0
2006-02-15 15:00:00	NVDA	Stock	0.3754	0.3757	0.3734	0.3757	75286320.0
2006-02-15 16:00:00	NVDA	Stock	0.3758	0.3767	0.3752	0.3762	561480.0
2006-02-15 17:00:00	NVDA	Stock	0.3762	0.3772	0.3757	0.3757	599880.0
2006-02-15 18:00:00	NVDA	Stock	0.3772	0.3772	0.3772	0.3772	12000.0
2006-02-15 09:00:00	AMZN	Stock	1.9125	1.921	1.9065	1.915	10533440.0
2006-02-15 10:00:00	AMZN	Stock	1.915	1.9375	1.905	1.931	28578860.0
2006-02-15 11:00:00	AMZN	Stock	1.931	1.935	1.9205	1.9335	13526620.0
2006-02-15 12:00:00	AMZN	Stock	1.933	1.937	1.924	1.9295	9205760.0
2006-02-15 13:00:00	AMZN	Stock	1.93	1.944	1.93	1.9402	12682060.0
2006-02-15 14:00:00	AMZN	Stock	1.94	1.9565	1.937	1.9555	22253340.0
2006-02-15 15:00:00	AMZN	Stock	1.955	1.964	1.9445	1.963	37248280.0
2006-02-15 16:00:00	AMZN	Stock	1.961	1.9725	1.961	1.968	1839600.0
2006-02-15 17:00:00	AMZN	Stock	1.965	1.9715	1.963	1.965	168800.0
2006-02-15 09:00:00	CL	Stock	27.135	27.15	26.855	26.965	404400.0
2006-02-15 10:00:00	CL	Stock	26.97	27.14	26.95	27.125	408000.0
2006-02-15 11:00:00	CL	Stock	27.125	27.145	26.995	27.035	474600.0
2006-02-15 12:00:00	CL	Stock	27.03	27.035	26.86	26.8715	386600.0
2006-02-15 13:00:00	CL	Stock	26.875	27.09	26.855	27.0765	328400.0
2006-02-15 14:00:00	CL	Stock	27.075	27.21	27.015	27.205	480400.0
2006-02-15 15:00:00	CL	Stock	27.205	27.3	27.185	27.245	576800.0

> showing 48 of 28,355 rows — these rows as CSV

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