PREVIEW / stock_1hour / 2006-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-24.parquet
  size:    593 KB
  rows:    28,196
  symbols: 2,183

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-01-24 06:00:00	AAPL	Stock	2.7768	2.7786	2.7768	2.7786	11200.0
2006-01-24 07:00:00	AAPL	Stock	2.7946	2.8071	2.7946	2.8054	113708.0
2006-01-24 08:00:00	AAPL	Stock	2.8054	2.8254	2.8054	2.8071	3705324.0
2006-01-24 09:00:00	AAPL	Stock	2.8061	2.8364	2.8057	2.8289	137043648.0
2006-01-24 10:00:00	AAPL	Stock	2.8286	2.8325	2.7793	2.7868	165424056.0
2006-01-24 11:00:00	AAPL	Stock	2.7868	2.7882	2.7714	2.7786	120603644.0
2006-01-24 12:00:00	AAPL	Stock	2.7786	2.7825	2.7354	2.7389	150669428.0
2006-01-24 13:00:00	AAPL	Stock	2.7389	2.7804	2.7061	2.7436	208198032.0
2006-01-24 14:00:00	AAPL	Stock	2.7436	2.7632	2.7232	2.7261	157196172.0
2006-01-24 15:00:00	AAPL	Stock	2.7261	2.7421	2.7111	2.7118	166951456.0
2006-01-24 16:00:00	AAPL	Stock	2.7132	2.7336	2.7093	2.7304	8426012.0
2006-01-24 17:00:00	AAPL	Stock	2.7318	2.7554	2.7157	2.7514	4894484.0
2006-01-24 18:00:00	AAPL	Stock	2.7514	2.7514	2.7429	2.7471	391804.0
2006-01-24 06:00:00	MSFT	Stock	26.4	26.4	26.35	26.35	500.0
2006-01-24 08:00:00	MSFT	Stock	26.45	26.45	26.37	26.37	6544.0
2006-01-24 09:00:00	MSFT	Stock	26.4	26.44	26.32	26.41	6468573.0
2006-01-24 10:00:00	MSFT	Stock	26.4	26.45	26.365	26.39	9040865.0
2006-01-24 11:00:00	MSFT	Stock	26.4	26.41	26.32	26.4	8043016.0
2006-01-24 12:00:00	MSFT	Stock	26.4	26.43	26.33	26.38	7286268.0
2006-01-24 13:00:00	MSFT	Stock	26.37	26.38	26.31	26.342	8586619.0
2006-01-24 14:00:00	MSFT	Stock	26.35	26.42	26.27	26.31	8578266.0
2006-01-24 15:00:00	MSFT	Stock	26.31	26.36	26.22	26.28	11377936.0
2006-01-24 16:00:00	MSFT	Stock	26.25	26.38	26.235	26.27	1504870.0
2006-01-24 17:00:00	MSFT	Stock	26.28	26.28	26.25	26.28	325987.0
2006-01-24 18:00:00	MSFT	Stock	26.27	26.3	26.27	26.3	20986.0
2006-01-24 09:00:00	NVDA	Stock	0.368	0.3767	0.367	0.3746	64993320.0
2006-01-24 10:00:00	NVDA	Stock	0.3747	0.3759	0.3717	0.3718	68697720.0
2006-01-24 11:00:00	NVDA	Stock	0.3718	0.3722	0.3691	0.3701	37904400.0
2006-01-24 12:00:00	NVDA	Stock	0.3702	0.3712	0.3695	0.3702	24056520.0
2006-01-24 13:00:00	NVDA	Stock	0.3702	0.3708	0.3692	0.3706	26655120.0
2006-01-24 14:00:00	NVDA	Stock	0.3706	0.3708	0.3691	0.3694	43042080.0
2006-01-24 15:00:00	NVDA	Stock	0.3695	0.3697	0.3677	0.3689	100714920.0
2006-01-24 16:00:00	NVDA	Stock	0.3687	0.369	0.3683	0.369	648000.0
2006-01-24 17:00:00	NVDA	Stock	0.369	0.369	0.369	0.369	704400.0
2006-01-24 09:00:00	AMZN	Stock	2.189	2.2215	2.183	2.218	8273240.0
2006-01-24 10:00:00	AMZN	Stock	2.2185	2.219	2.171	2.1845	21646140.0
2006-01-24 11:00:00	AMZN	Stock	2.1845	2.202	2.181	2.1955	10201180.0
2006-01-24 12:00:00	AMZN	Stock	2.195	2.2	2.187	2.1985	7618320.0
2006-01-24 13:00:00	AMZN	Stock	2.199	2.2125	2.1955	2.209	8852480.0
2006-01-24 14:00:00	AMZN	Stock	2.209	2.219	2.1975	2.198	12159680.0
2006-01-24 15:00:00	AMZN	Stock	2.199	2.204	2.191	2.2	12609080.0
2006-01-24 16:00:00	AMZN	Stock	2.2005	2.2025	2.1998	2.201	217380.0
2006-01-24 17:00:00	AMZN	Stock	2.201	2.2075	2.201	2.2075	230180.0
2006-01-24 09:00:00	CL	Stock	26.86	26.9945	26.845	26.965	251600.0
2006-01-24 10:00:00	CL	Stock	26.965	27.04	26.76	26.78	501600.0
2006-01-24 11:00:00	CL	Stock	26.78	26.79	26.705	26.75	585600.0
2006-01-24 12:00:00	CL	Stock	26.765	26.85	26.74	26.785	373800.0
2006-01-24 13:00:00	CL	Stock	26.785	26.88	26.75	26.865	307400.0
2006-01-24 14:00:00	CL	Stock	26.865	26.92	26.8	26.805	494600.0
2006-01-24 15:00:00	CL	Stock	26.805	26.87	26.75	26.87	681000.0

> showing 50 of 28,196 rows — these rows as CSV

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