PREVIEW / stock_1hour / 2007-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-27.parquet
  size:    679 KB
  rows:    32,212
  symbols: 2,556

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
2007-03-27 06:00:00	AAPL	Stock	3.4107	3.4107	3.4107	3.4107	2800.0
2007-03-27 07:00:00	AAPL	Stock	3.4214	3.4321	3.4196	3.4243	801640.0
2007-03-27 08:00:00	AAPL	Stock	3.4268	3.4268	3.4179	3.4214	1430212.0
2007-03-27 09:00:00	AAPL	Stock	3.4218	3.4259	3.3986	3.4057	97480712.0
2007-03-27 10:00:00	AAPL	Stock	3.4054	3.4196	3.3929	3.4189	129553984.0
2007-03-27 11:00:00	AAPL	Stock	3.4189	3.4368	3.4129	3.435	144226124.0
2007-03-27 12:00:00	AAPL	Stock	3.435	3.4454	3.4236	3.4436	84977396.0
2007-03-27 13:00:00	AAPL	Stock	3.4432	3.4582	3.4429	3.4471	132579440.0
2007-03-27 14:00:00	AAPL	Stock	3.4471	3.4536	3.4018	3.4168	190435140.0
2007-03-27 15:00:00	AAPL	Stock	3.4164	3.4275	3.4071	3.4086	131349736.0
2007-03-27 16:00:00	AAPL	Stock	3.4082	3.4179	3.3929	3.4029	6376468.0
2007-03-27 17:00:00	AAPL	Stock	3.3986	3.4096	3.3925	3.4011	8128260.0
2007-03-27 18:00:00	AAPL	Stock	3.4032	3.4043	3.4	3.4036	500640.0
2007-03-27 19:00:00	AAPL	Stock	3.4004	3.4004	3.3932	3.3993	329448.0
2007-03-27 08:00:00	MSFT	Stock	28.19	28.19	28.12	28.17	5195.0
2007-03-27 09:00:00	MSFT	Stock	28.15	28.17	27.97	28.0	5343961.0
2007-03-27 10:00:00	MSFT	Stock	27.99	28.1	27.85	28.04	8091492.0
2007-03-27 11:00:00	MSFT	Stock	28.03	28.04	27.89	27.9	4964227.0
2007-03-27 12:00:00	MSFT	Stock	27.9	27.92	27.86	27.865	6176654.0
2007-03-27 13:00:00	MSFT	Stock	27.862	27.9	27.73	27.75	8587486.0
2007-03-27 14:00:00	MSFT	Stock	27.74	27.86	27.65	27.83	8325950.0
2007-03-27 15:00:00	MSFT	Stock	27.83	27.9	27.72	27.76	13951253.0
2007-03-27 16:00:00	MSFT	Stock	27.73	28.04	27.65	27.65	1850258.0
2007-03-27 17:00:00	MSFT	Stock	27.7	27.72	27.64	27.68	18496.0
2007-03-27 18:00:00	MSFT	Stock	27.7	27.71	27.7	27.7	1800.0
2007-03-27 19:00:00	MSFT	Stock	27.7	27.72	27.66	27.72	1500.0
2007-03-27 09:00:00	NVDA	Stock	0.5067	0.507	0.4976	0.4977	75973740.0
2007-03-27 10:00:00	NVDA	Stock	0.4978	0.4998	0.4958	0.4982	95298960.0
2007-03-27 11:00:00	NVDA	Stock	0.4982	0.4997	0.4965	0.497	60097080.0
2007-03-27 12:00:00	NVDA	Stock	0.4972	0.4992	0.4968	0.4988	44826240.0
2007-03-27 13:00:00	NVDA	Stock	0.4988	0.5	0.4977	0.498	38800260.0
2007-03-27 14:00:00	NVDA	Stock	0.498	0.4988	0.4963	0.4975	61579140.0
2007-03-27 15:00:00	NVDA	Stock	0.4973	0.4983	0.496	0.4962	70654440.0
2007-03-27 16:00:00	NVDA	Stock	0.4962	0.4972	0.4958	0.4958	10833780.0
2007-03-27 17:00:00	NVDA	Stock	0.4958	0.4958	0.4947	0.4947	208440.0
2007-03-27 18:00:00	NVDA	Stock	0.4948	0.4948	0.4948	0.4948	24000.0
2007-03-27 19:00:00	NVDA	Stock	0.4942	0.4958	0.4942	0.4958	49560.0
2007-03-27 09:00:00	AMZN	Stock	1.94	1.95	1.938	1.945	6276160.0
2007-03-27 10:00:00	AMZN	Stock	1.945	1.9515	1.942	1.9515	11911460.0
2007-03-27 11:00:00	AMZN	Stock	1.951	1.9545	1.943	1.9465	10383020.0
2007-03-27 12:00:00	AMZN	Stock	1.946	1.9565	1.945	1.951	7808140.0
2007-03-27 13:00:00	AMZN	Stock	1.951	1.9665	1.9495	1.966	7391580.0
2007-03-27 14:00:00	AMZN	Stock	1.9655	1.9685	1.9595	1.9675	9947760.0
2007-03-27 15:00:00	AMZN	Stock	1.9675	1.971	1.966	1.9665	18288560.0
2007-03-27 16:00:00	AMZN	Stock	1.9675	1.9675	1.964	1.964	252520.0
2007-03-27 17:00:00	AMZN	Stock	1.963	1.963	1.955	1.96	1333000.0
2007-03-27 18:00:00	AMZN	Stock	1.9615	1.9615	1.961	1.961	19000.0
2007-03-27 09:00:00	CL	Stock	33.36	33.395	33.22	33.22	229600.0
2007-03-27 10:00:00	CL	Stock	33.2	33.285	33.155	33.2	407400.0
2007-03-27 11:00:00	CL	Stock	33.195	33.245	33.13	33.21	573600.0

> showing 50 of 32,212 rows — these rows as CSV

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