PREVIEW / stock_1hour / 2008-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-14.parquet
  size:    786 KB
  rows:    39,578
  symbols: 3,259

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-14 05:00:00	AAPL	Stock	4.5589	4.5589	4.5589	4.5589	2800.0
2008-03-14 06:00:00	AAPL	Stock	4.5589	4.5679	4.5589	4.5679	19600.0
2008-03-14 07:00:00	AAPL	Stock	4.56	4.56	4.5471	4.5504	126000.0
2008-03-14 08:00:00	AAPL	Stock	4.5504	4.6536	4.55	4.6357	14836164.0
2008-03-14 09:00:00	AAPL	Stock	4.6364	4.6696	4.5179	4.5182	187125148.0
2008-03-14 10:00:00	AAPL	Stock	4.5189	4.575	4.4357	4.5484	254369920.0
2008-03-14 11:00:00	AAPL	Stock	4.5482	4.5757	4.5025	4.5496	139849948.0
2008-03-14 12:00:00	AAPL	Stock	4.5486	4.5625	4.4929	4.5114	93926028.0
2008-03-14 13:00:00	AAPL	Stock	4.5125	4.5211	4.485	4.4918	100206036.0
2008-03-14 14:00:00	AAPL	Stock	4.4911	4.5064	4.4479	4.4917	138532744.0
2008-03-14 15:00:00	AAPL	Stock	4.4911	4.5429	4.4814	4.5343	208773964.0
2008-03-14 16:00:00	AAPL	Stock	4.535	4.5389	4.5196	4.5296	18955832.0
2008-03-14 17:00:00	AAPL	Stock	4.5286	4.5304	4.5214	4.525	257880.0
2008-03-14 18:00:00	AAPL	Stock	4.525	4.5264	4.5221	4.5232	172872.0
2008-03-14 19:00:00	AAPL	Stock	4.525	4.5257	4.5218	4.5257	151396.0
2008-03-14 07:00:00	MSFT	Stock	28.5	28.5	28.5	28.5	100.0
2008-03-14 08:00:00	MSFT	Stock	28.62	28.85	28.4	28.81	42651.0
2008-03-14 09:00:00	MSFT	Stock	28.82	29.01	28.24	28.26	12047638.0
2008-03-14 10:00:00	MSFT	Stock	28.25	28.51	27.86	28.34	21296759.0
2008-03-14 11:00:00	MSFT	Stock	28.34	28.38	28.0	28.06	9994205.0
2008-03-14 12:00:00	MSFT	Stock	28.05	28.13	27.89	27.98	7764205.0
2008-03-14 13:00:00	MSFT	Stock	27.98	27.98	27.86	27.87	9379176.0
2008-03-14 14:00:00	MSFT	Stock	27.87	28.03	27.64	27.94	14739957.0
2008-03-14 15:00:00	MSFT	Stock	27.95	28.19	27.805	27.97	24745217.0
2008-03-14 16:00:00	MSFT	Stock	27.962	28.121	27.75	27.81	5045564.0
2008-03-14 17:00:00	MSFT	Stock	27.82	27.83	27.82	27.82	9303.0
2008-03-14 18:00:00	MSFT	Stock	27.82	28.3	27.81	27.85	141956.0
2008-03-14 19:00:00	MSFT	Stock	27.84	27.85	27.81	27.84	8992.0
2008-03-14 08:00:00	NVDA	Stock	0.4948	0.5035	0.4875	0.4998	784000.0
2008-03-14 09:00:00	NVDA	Stock	0.5	0.5	0.4695	0.4732	141137680.0
2008-03-14 10:00:00	NVDA	Stock	0.4732	0.48	0.4655	0.4695	188512160.0
2008-03-14 11:00:00	NVDA	Stock	0.4692	0.4713	0.463	0.4655	116249360.0
2008-03-14 12:00:00	NVDA	Stock	0.4652	0.4692	0.46	0.464	111815400.0
2008-03-14 13:00:00	NVDA	Stock	0.4638	0.4645	0.4572	0.4575	89179400.0
2008-03-14 14:00:00	NVDA	Stock	0.4575	0.4635	0.4545	0.4588	170326520.0
2008-03-14 15:00:00	NVDA	Stock	0.459	0.4655	0.4562	0.4582	241526000.0
2008-03-14 16:00:00	NVDA	Stock	0.4582	0.4662	0.4555	0.4562	95257800.0
2008-03-14 17:00:00	NVDA	Stock	0.458	0.4588	0.457	0.458	161360.0
2008-03-14 18:00:00	NVDA	Stock	0.4595	0.461	0.4588	0.461	93200.0
2008-03-14 19:00:00	NVDA	Stock	0.4605	0.4605	0.4593	0.46	107800.0
2008-03-14 07:00:00	AMZN	Stock	3.4185	3.44	3.4175	3.44	80000.0
2008-03-14 08:00:00	AMZN	Stock	3.429	3.463	3.425	3.4555	193500.0
2008-03-14 09:00:00	AMZN	Stock	3.455	3.534	3.3815	3.3905	36824200.0
2008-03-14 10:00:00	AMZN	Stock	3.3905	3.4815	3.36	3.438	41692280.0
2008-03-14 11:00:00	AMZN	Stock	3.4365	3.4515	3.401	3.4475	21131020.0
2008-03-14 12:00:00	AMZN	Stock	3.447	3.4555	3.388	3.404	25218500.0
2008-03-14 13:00:00	AMZN	Stock	3.4015	3.4045	3.3385	3.339	29200740.0
2008-03-14 14:00:00	AMZN	Stock	3.3395	3.351	3.303	3.3145	26866040.0
2008-03-14 15:00:00	AMZN	Stock	3.3145	3.4275	3.3045	3.411	60085540.0
2008-03-14 16:00:00	AMZN	Stock	3.411	3.4173	3.4	3.405	7058940.0

> showing 50 of 39,578 rows — these rows as CSV

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