PREVIEW / stock_1hour / 2008-03-11

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-11.parquet
  size:    814 KB
  rows:    41,143
  symbols: 3,288

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
2008-03-11 04:00:00	AAPL	Stock	4.2768	4.2925	4.2768	4.2925	5600.0
2008-03-11 06:00:00	AAPL	Stock	4.3125	4.3125	4.3125	4.3125	26600.0
2008-03-11 07:00:00	AAPL	Stock	4.3125	4.3232	4.3036	4.3036	159348.0
2008-03-11 08:00:00	AAPL	Stock	4.3018	4.4143	4.2879	4.3879	14837004.0
2008-03-11 09:00:00	AAPL	Stock	4.3886	4.4643	4.3796	4.3814	194496624.0
2008-03-11 10:00:00	AAPL	Stock	4.3797	4.4239	4.3689	4.4214	168727580.0
2008-03-11 11:00:00	AAPL	Stock	4.4218	4.4464	4.3571	4.3875	138121368.0
2008-03-11 12:00:00	AAPL	Stock	4.3875	4.4179	4.3636	4.3992	113125656.0
2008-03-11 13:00:00	AAPL	Stock	4.3996	4.4518	4.3911	4.4432	118012776.0
2008-03-11 14:00:00	AAPL	Stock	4.4432	4.4957	4.43	4.4736	156192848.0
2008-03-11 15:00:00	AAPL	Stock	4.4736	4.5529	4.4675	4.5482	225070020.0
2008-03-11 16:00:00	AAPL	Stock	4.5482	4.5661	4.4071	4.5607	30102632.0
2008-03-11 17:00:00	AAPL	Stock	4.5607	4.5804	4.5482	4.5689	5546856.0
2008-03-11 18:00:00	AAPL	Stock	4.5714	4.5775	4.5661	4.5689	680344.0
2008-03-11 19:00:00	AAPL	Stock	4.5682	4.5682	4.5596	4.5679	319200.0
2008-03-11 08:00:00	MSFT	Stock	28.15	28.38	28.05	28.35	465469.0
2008-03-11 09:00:00	MSFT	Stock	28.35	28.81	28.34	28.56	11905787.0
2008-03-11 10:00:00	MSFT	Stock	28.56	28.83	28.54	28.81	13766973.0
2008-03-11 11:00:00	MSFT	Stock	28.8	28.85	28.6	28.69	11970098.0
2008-03-11 12:00:00	MSFT	Stock	28.69	28.8	28.55	28.69	10725727.0
2008-03-11 13:00:00	MSFT	Stock	28.7	28.89	28.67	28.88	10186755.0
2008-03-11 14:00:00	MSFT	Stock	28.88	29.03	28.87	28.96	9187018.0
2008-03-11 15:00:00	MSFT	Stock	28.96	29.34	28.91	29.28	22073358.0
2008-03-11 16:00:00	MSFT	Stock	29.28	29.39	28.805	29.35	4691924.0
2008-03-11 17:00:00	MSFT	Stock	29.28	29.42	28.96	29.42	3764500.0
2008-03-11 18:00:00	MSFT	Stock	29.4	29.42	29.33	29.35	20180.0
2008-03-11 19:00:00	MSFT	Stock	29.38	29.38	29.33	29.33	2150.0
2008-03-11 08:00:00	NVDA	Stock	0.4612	0.4688	0.4575	0.4688	960400.0
2008-03-11 09:00:00	NVDA	Stock	0.4688	0.4808	0.4688	0.4718	87885520.0
2008-03-11 10:00:00	NVDA	Stock	0.4718	0.4768	0.4665	0.4728	122425960.0
2008-03-11 11:00:00	NVDA	Stock	0.4728	0.475	0.4588	0.461	125903800.0
2008-03-11 12:00:00	NVDA	Stock	0.4608	0.4645	0.456	0.4605	98900680.0
2008-03-11 13:00:00	NVDA	Stock	0.4605	0.4675	0.4578	0.4662	100143120.0
2008-03-11 14:00:00	NVDA	Stock	0.4662	0.4728	0.4645	0.4708	110430400.0
2008-03-11 15:00:00	NVDA	Stock	0.4705	0.476	0.4685	0.476	180374360.0
2008-03-11 16:00:00	NVDA	Stock	0.476	0.4803	0.4668	0.4763	30413520.0
2008-03-11 17:00:00	NVDA	Stock	0.476	0.4765	0.475	0.475	328000.0
2008-03-11 18:00:00	NVDA	Stock	0.4763	0.4775	0.4763	0.477	30280.0
2008-03-11 19:00:00	NVDA	Stock	0.476	0.476	0.476	0.476	4000.0
2008-03-11 07:00:00	AMZN	Stock	3.205	3.205	3.205	3.205	8000.0
2008-03-11 08:00:00	AMZN	Stock	3.1735	3.322	3.1735	3.3005	868060.0
2008-03-11 09:00:00	AMZN	Stock	3.3	3.3475	3.2315	3.233	27075660.0
2008-03-11 10:00:00	AMZN	Stock	3.2315	3.3075	3.215	3.2785	32466540.0
2008-03-11 11:00:00	AMZN	Stock	3.278	3.2895	3.2085	3.222	23052260.0
2008-03-11 12:00:00	AMZN	Stock	3.2225	3.255	3.1855	3.216	17988680.0
2008-03-11 13:00:00	AMZN	Stock	3.2165	3.268	3.205	3.2605	13883180.0
2008-03-11 14:00:00	AMZN	Stock	3.262	3.2875	3.2375	3.263	24129180.0
2008-03-11 15:00:00	AMZN	Stock	3.2635	3.3585	3.2635	3.3575	50061380.0
2008-03-11 16:00:00	AMZN	Stock	3.3575	3.3606	3.2744	3.347	1342600.0
2008-03-11 17:00:00	AMZN	Stock	3.3575	3.3575	3.349	3.349	9760.0

> showing 50 of 41,143 rows — these rows as CSV

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