PREVIEW / stock_1hour / 2006-02-24

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-24.parquet
  size:    589 KB
  rows:    27,877
  symbols: 2,187

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-24 04:00:00	AAPL	Stock	2.5457	2.5457	2.5457	2.5457	2800.0
2006-02-24 05:00:00	AAPL	Stock	2.5821	2.5821	2.5821	2.5821	8400.0
2006-02-24 06:00:00	AAPL	Stock	2.5893	2.5893	2.5893	2.5893	5600.0
2006-02-24 07:00:00	AAPL	Stock	2.5768	2.5825	2.5768	2.5796	67200.0
2006-02-24 08:00:00	AAPL	Stock	2.5829	2.5843	2.5661	2.5696	3405136.0
2006-02-24 09:00:00	AAPL	Stock	2.5693	2.5857	2.5632	2.5807	81038048.0
2006-02-24 10:00:00	AAPL	Stock	2.5804	2.6032	2.5732	2.5764	124112632.0
2006-02-24 11:00:00	AAPL	Stock	2.5764	2.5918	2.5764	2.5907	57197784.0
2006-02-24 12:00:00	AAPL	Stock	2.5907	2.5921	2.5766	2.5861	36494976.0
2006-02-24 13:00:00	AAPL	Stock	2.5868	2.5893	2.5607	2.5625	52040716.0
2006-02-24 14:00:00	AAPL	Stock	2.5625	2.5782	2.5607	2.5671	56160300.0
2006-02-24 15:00:00	AAPL	Stock	2.5661	2.5732	2.5429	2.5518	104498632.0
2006-02-24 16:00:00	AAPL	Stock	2.5514	2.5589	2.5461	2.5568	2765616.0
2006-02-24 17:00:00	AAPL	Stock	2.5586	2.5607	2.5554	2.56	483420.0
2006-02-24 18:00:00	AAPL	Stock	2.5589	2.5607	2.5571	2.5607	30800.0
2006-02-24 06:00:00	MSFT	Stock	26.67	26.67	26.67	26.67	300.0
2006-02-24 07:00:00	MSFT	Stock	26.67	26.69	26.62	26.69	8120.0
2006-02-24 08:00:00	MSFT	Stock	26.66	26.66	26.65	26.65	36910.0
2006-02-24 09:00:00	MSFT	Stock	26.65	26.66	26.54	26.56	5219649.0
2006-02-24 10:00:00	MSFT	Stock	26.56	26.63	26.52	26.55	5412873.0
2006-02-24 11:00:00	MSFT	Stock	26.55	26.57	26.53	26.54	2827213.0
2006-02-24 12:00:00	MSFT	Stock	26.54	26.59	26.54	26.56	1942025.0
2006-02-24 13:00:00	MSFT	Stock	26.56	26.65	26.54	26.62	10226868.0
2006-02-24 14:00:00	MSFT	Stock	26.62	26.73	26.61	26.72	8470065.0
2006-02-24 15:00:00	MSFT	Stock	26.72	26.74	26.58	26.67	7953704.0
2006-02-24 16:00:00	MSFT	Stock	26.67	26.7	26.63	26.64	250605.0
2006-02-24 17:00:00	MSFT	Stock	26.67	26.67	26.64	26.64	1150.0
2006-02-24 18:00:00	MSFT	Stock	26.64	26.64	26.63	26.63	1240.0
2006-02-24 08:00:00	NVDA	Stock	0.3825	0.3825	0.3806	0.3806	84360.0
2006-02-24 09:00:00	NVDA	Stock	0.3814	0.3839	0.3785	0.3827	34980000.0
2006-02-24 10:00:00	NVDA	Stock	0.3827	0.3868	0.3823	0.3824	86197680.0
2006-02-24 11:00:00	NVDA	Stock	0.3823	0.3836	0.3803	0.381	56538600.0
2006-02-24 12:00:00	NVDA	Stock	0.381	0.3835	0.3808	0.3833	76394880.0
2006-02-24 13:00:00	NVDA	Stock	0.3834	0.3842	0.3818	0.3824	31012560.0
2006-02-24 14:00:00	NVDA	Stock	0.3824	0.3849	0.3821	0.3846	47364000.0
2006-02-24 15:00:00	NVDA	Stock	0.3845	0.3853	0.3797	0.3808	70062600.0
2006-02-24 16:00:00	NVDA	Stock	0.381	0.382	0.38	0.3812	1901040.0
2006-02-24 17:00:00	NVDA	Stock	0.3805	0.3805	0.3802	0.3802	168000.0
2006-02-24 08:00:00	AMZN	Stock	1.91	1.917	1.894	1.9015	181680.0
2006-02-24 09:00:00	AMZN	Stock	1.904	1.9165	1.893	1.902	12447380.0
2006-02-24 10:00:00	AMZN	Stock	1.902	1.912	1.8985	1.9005	9818220.0
2006-02-24 11:00:00	AMZN	Stock	1.9005	1.9075	1.8985	1.9	7545440.0
2006-02-24 12:00:00	AMZN	Stock	1.9	1.9115	1.8995	1.9095	6355000.0
2006-02-24 13:00:00	AMZN	Stock	1.9095	1.91	1.9015	1.906	8778300.0
2006-02-24 14:00:00	AMZN	Stock	1.906	1.9155	1.9055	1.9155	9816800.0
2006-02-24 15:00:00	AMZN	Stock	1.9155	1.9205	1.9	1.9145	17266300.0
2006-02-24 16:00:00	AMZN	Stock	1.9145	1.92	1.9145	1.9175	99460.0
2006-02-24 17:00:00	AMZN	Stock	1.9155	1.9155	1.915	1.915	29440.0
2006-02-24 18:00:00	AMZN	Stock	1.9105	1.9105	1.9105	1.9105	14000.0
2006-02-24 09:00:00	CL	Stock	27.4	27.445	27.325	27.405	147800.0

> showing 50 of 27,877 rows — these rows as CSV

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