PREVIEW / stock_1hour / 2008-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-06.parquet
  size:    844 KB
  rows:    40,214
  symbols: 3,290

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-06-06 04:00:00	AAPL	Stock	6.7857	6.7857	6.7857	6.7857	5600.0
2008-06-06 06:00:00	AAPL	Stock	6.7657	6.7657	6.7654	6.7654	5600.0
2008-06-06 07:00:00	AAPL	Stock	6.7857	6.7957	6.7664	6.7718	222600.0
2008-06-06 08:00:00	AAPL	Stock	6.7811	6.7964	6.7104	6.7236	11794748.0
2008-06-06 09:00:00	AAPL	Stock	6.7246	6.7839	6.6968	6.7771	135831836.0
2008-06-06 10:00:00	AAPL	Stock	6.7764	6.7768	6.7011	6.7236	147922796.0
2008-06-06 11:00:00	AAPL	Stock	6.7248	6.7288	6.6429	6.6864	130192020.0
2008-06-06 12:00:00	AAPL	Stock	6.6861	6.735	6.6721	6.72	79474220.0
2008-06-06 13:00:00	AAPL	Stock	6.7196	6.7371	6.6768	6.7264	109636016.0
2008-06-06 14:00:00	AAPL	Stock	6.7264	6.7332	6.6429	6.6593	148220380.0
2008-06-06 15:00:00	AAPL	Stock	6.6593	6.7079	6.6268	6.6343	170608620.0
2008-06-06 16:00:00	AAPL	Stock	6.6343	6.7321	6.625	6.6421	18673228.0
2008-06-06 17:00:00	AAPL	Stock	6.6411	6.6882	6.6379	6.6568	1436988.0
2008-06-06 18:00:00	AAPL	Stock	6.6571	6.6661	6.65	6.6504	648648.0
2008-06-06 19:00:00	AAPL	Stock	6.6571	6.6643	6.6521	6.6554	379624.0
2008-06-06 08:00:00	MSFT	Stock	28.34	28.35	28.02	28.05	73589.0
2008-06-06 09:00:00	MSFT	Stock	28.05	28.14	27.85	28.05	8586888.0
2008-06-06 10:00:00	MSFT	Stock	28.05	28.17	27.89	28.05	12289959.0
2008-06-06 11:00:00	MSFT	Stock	28.05	28.11	27.98	28.03	7858116.0
2008-06-06 12:00:00	MSFT	Stock	28.02	28.05	27.93	27.965	5854243.0
2008-06-06 13:00:00	MSFT	Stock	27.97	27.98	27.84	27.94	7561011.0
2008-06-06 14:00:00	MSFT	Stock	27.94	27.94	27.67	27.7	11271759.0
2008-06-06 15:00:00	MSFT	Stock	27.7	27.9	27.5	27.5	20373456.0
2008-06-06 16:00:00	MSFT	Stock	27.49	27.871	27.45	27.58	3992703.0
2008-06-06 17:00:00	MSFT	Stock	27.59	27.691	27.49	27.691	98355.0
2008-06-06 18:00:00	MSFT	Stock	27.55	27.61	27.55	27.6	4176.0
2008-06-06 19:00:00	MSFT	Stock	27.59	27.59	27.55	27.55	7592.0
2008-06-06 08:00:00	NVDA	Stock	0.6215	0.6215	0.6125	0.6125	510880.0
2008-06-06 09:00:00	NVDA	Stock	0.6125	0.6145	0.6063	0.608	72081600.0
2008-06-06 10:00:00	NVDA	Stock	0.608	0.6103	0.6028	0.6045	109105400.0
2008-06-06 11:00:00	NVDA	Stock	0.6045	0.6105	0.6003	0.6088	119424520.0
2008-06-06 12:00:00	NVDA	Stock	0.6088	0.611	0.6053	0.6073	75142560.0
2008-06-06 13:00:00	NVDA	Stock	0.6073	0.6075	0.6028	0.6035	87158600.0
2008-06-06 14:00:00	NVDA	Stock	0.6033	0.6035	0.598	0.5998	122145400.0
2008-06-06 15:00:00	NVDA	Stock	0.5998	0.6055	0.5995	0.601	158734800.0
2008-06-06 16:00:00	NVDA	Stock	0.601	0.6048	0.5995	0.6046	38266520.0
2008-06-06 17:00:00	NVDA	Stock	0.6	0.6	0.5975	0.5998	38000.0
2008-06-06 18:00:00	NVDA	Stock	0.6008	0.6013	0.5998	0.5998	223480.0
2008-06-06 19:00:00	NVDA	Stock	0.6008	0.6008	0.6	0.6	24000.0
2008-06-06 08:00:00	AMZN	Stock	4.244	4.244	4.1535	4.1635	135600.0
2008-06-06 09:00:00	AMZN	Stock	4.1675	4.182	4.131	4.1495	21025880.0
2008-06-06 10:00:00	AMZN	Stock	4.149	4.157	4.1125	4.1125	22623080.0
2008-06-06 11:00:00	AMZN	Stock	4.1125	4.116	4.0785	4.1025	13405660.0
2008-06-06 12:00:00	AMZN	Stock	4.101	4.129	4.0905	4.1169	14519860.0
2008-06-06 13:00:00	AMZN	Stock	4.123	4.125	4.0825	4.113	21426260.0
2008-06-06 14:00:00	AMZN	Stock	4.1115	4.1125	4.043	4.0545	24881360.0
2008-06-06 15:00:00	AMZN	Stock	4.056	4.077	4.028	4.031	34530800.0
2008-06-06 16:00:00	AMZN	Stock	4.0425	4.0957	4.0315	4.0315	233820.0
2008-06-06 17:00:00	AMZN	Stock	4.04	4.04	4.04	4.04	3000.0
2008-06-06 18:00:00	AMZN	Stock	4.049	4.05	4.049	4.05	23120.0

> showing 50 of 40,214 rows — these rows as CSV

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