PREVIEW / stock_1hour / 2006-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-25.parquet
  size:    592 KB
  rows:    27,987
  symbols: 2,179

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-25 04:00:00	AAPL	Stock	2.7554	2.7554	2.7554	2.7554	8400.0
2006-01-25 05:00:00	AAPL	Stock	2.7571	2.7571	2.7571	2.7571	11200.0
2006-01-25 07:00:00	AAPL	Stock	2.7711	2.78	2.7607	2.7696	168000.0
2006-01-25 08:00:00	AAPL	Stock	2.7729	2.785	2.7625	2.7625	5146876.0
2006-01-25 09:00:00	AAPL	Stock	2.7625	2.7796	2.6875	2.6936	164792740.0
2006-01-25 10:00:00	AAPL	Stock	2.6936	2.7032	2.6161	2.6832	427781704.0
2006-01-25 11:00:00	AAPL	Stock	2.6829	2.7	2.6461	2.6636	211459892.0
2006-01-25 12:00:00	AAPL	Stock	2.6632	2.6693	2.6432	2.6661	93748648.0
2006-01-25 13:00:00	AAPL	Stock	2.6671	2.6825	2.6596	2.6696	78737064.0
2006-01-25 14:00:00	AAPL	Stock	2.6693	2.6804	2.63	2.6371	125036632.0
2006-01-25 15:00:00	AAPL	Stock	2.6371	2.6568	2.6318	2.6493	142653392.0
2006-01-25 16:00:00	AAPL	Stock	2.6493	2.6687	2.6468	2.65	3420004.0
2006-01-25 17:00:00	AAPL	Stock	2.65	2.6529	2.6482	2.6511	8007944.0
2006-01-25 18:00:00	AAPL	Stock	2.6511	2.6511	2.6443	2.6468	295484.0
2006-01-25 06:00:00	MSFT	Stock	26.4	26.4	26.4	26.4	200.0
2006-01-25 07:00:00	MSFT	Stock	26.4	26.4	26.4	26.4	1000.0
2006-01-25 08:00:00	MSFT	Stock	26.35	26.44	26.35	26.42	45283.0
2006-01-25 09:00:00	MSFT	Stock	26.43	26.52	26.28	26.51	8464393.0
2006-01-25 10:00:00	MSFT	Stock	26.51	26.57	26.34	26.51	12048140.0
2006-01-25 11:00:00	MSFT	Stock	26.5	26.56	26.45	26.522	6877864.0
2006-01-25 12:00:00	MSFT	Stock	26.52	26.55	26.41	26.45	6374677.0
2006-01-25 13:00:00	MSFT	Stock	26.44	26.49	26.3	26.322	7242544.0
2006-01-25 14:00:00	MSFT	Stock	26.32	26.44	26.23	26.28	6413507.0
2006-01-25 15:00:00	MSFT	Stock	26.29	26.43	26.27	26.39	9935858.0
2006-01-25 16:00:00	MSFT	Stock	26.39	26.45	26.35	26.4	533116.0
2006-01-25 17:00:00	MSFT	Stock	26.4	26.42	26.4	26.42	9784.0
2006-01-25 18:00:00	MSFT	Stock	26.4	26.4	26.4	26.4	700.0
2006-01-25 08:00:00	NVDA	Stock	0.3709	0.3709	0.3709	0.3709	108000.0
2006-01-25 09:00:00	NVDA	Stock	0.3709	0.3747	0.369	0.3713	35747520.0
2006-01-25 10:00:00	NVDA	Stock	0.3714	0.3714	0.3632	0.365	116683560.0
2006-01-25 11:00:00	NVDA	Stock	0.3652	0.3672	0.3649	0.3664	39245520.0
2006-01-25 12:00:00	NVDA	Stock	0.3663	0.3663	0.3633	0.3652	30186240.0
2006-01-25 13:00:00	NVDA	Stock	0.3652	0.3675	0.3635	0.3641	31198080.0
2006-01-25 14:00:00	NVDA	Stock	0.3641	0.365	0.3613	0.3622	63594000.0
2006-01-25 15:00:00	NVDA	Stock	0.3622	0.3657	0.3617	0.3657	71648400.0
2006-01-25 16:00:00	NVDA	Stock	0.3657	0.3657	0.3656	0.3657	487200.0
2006-01-25 17:00:00	NVDA	Stock	0.3656	0.3656	0.3656	0.3656	84000.0
2006-01-25 18:00:00	NVDA	Stock	0.3651	0.3651	0.3651	0.3651	60000.0
2006-01-25 09:00:00	AMZN	Stock	2.205	2.2235	2.189	2.1895	6864440.0
2006-01-25 10:00:00	AMZN	Stock	2.1905	2.203	2.17	2.187	19273120.0
2006-01-25 11:00:00	AMZN	Stock	2.188	2.2065	2.1705	2.1835	16451940.0
2006-01-25 12:00:00	AMZN	Stock	2.1825	2.1905	2.167	2.1835	11598080.0
2006-01-25 13:00:00	AMZN	Stock	2.1835	2.1955	2.1755	2.1795	8123340.0
2006-01-25 14:00:00	AMZN	Stock	2.1795	2.185	2.1675	2.1705	9300240.0
2006-01-25 15:00:00	AMZN	Stock	2.172	2.1855	2.1705	2.1805	12317380.0
2006-01-25 16:00:00	AMZN	Stock	2.18	2.186	2.1755	2.1812	377860.0
2006-01-25 18:00:00	AMZN	Stock	2.1755	2.1755	2.1755	2.1755	10000.0
2006-01-25 09:00:00	CL	Stock	27.37	27.725	27.33	27.65	1682800.0
2006-01-25 10:00:00	CL	Stock	27.65	27.84	27.44	27.82	1897200.0
2006-01-25 11:00:00	CL	Stock	27.825	27.855	27.725	27.765	928200.0

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

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