PREVIEW / stock_1hour / 2008-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-06.parquet
  size:    852 KB
  rows:    41,365
  symbols: 3,326

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-05-06 06:00:00	AAPL	Stock	6.6161	6.6275	6.6143	6.6275	58800.0
2008-05-06 07:00:00	AAPL	Stock	6.6254	6.6329	6.5857	6.5857	1108912.0
2008-05-06 08:00:00	AAPL	Stock	6.5925	6.6336	6.5754	6.6107	5834444.0
2008-05-06 09:00:00	AAPL	Stock	6.6093	6.6157	6.5064	6.535	145761784.0
2008-05-06 10:00:00	AAPL	Stock	6.5346	6.5811	6.5279	6.5804	158601044.0
2008-05-06 11:00:00	AAPL	Stock	6.5796	6.5986	6.5579	6.5982	96908364.0
2008-05-06 12:00:00	AAPL	Stock	6.5982	6.6518	6.5975	6.6357	130915512.0
2008-05-06 13:00:00	AAPL	Stock	6.6364	6.6564	6.6232	6.6446	88867520.0
2008-05-06 14:00:00	AAPL	Stock	6.6444	6.67	6.6168	6.6621	113668156.0
2008-05-06 15:00:00	AAPL	Stock	6.6621	6.6829	6.6486	6.6636	144832576.0
2008-05-06 16:00:00	AAPL	Stock	6.6621	6.6889	6.6056	6.6629	17185756.0
2008-05-06 17:00:00	AAPL	Stock	6.6629	6.6629	6.5657	6.6571	1571864.0
2008-05-06 18:00:00	AAPL	Stock	6.6571	6.6668	6.6486	6.6571	315896.0
2008-05-06 19:00:00	AAPL	Stock	6.655	6.6632	6.6471	6.6629	261912.0
2008-05-06 06:00:00	MSFT	Stock	29.1	29.1	29.1	29.1	200.0
2008-05-06 07:00:00	MSFT	Stock	29.1	29.18	28.9	28.92	13496.0
2008-05-06 08:00:00	MSFT	Stock	28.9	29.2	28.9	28.98	137027.0
2008-05-06 09:00:00	MSFT	Stock	29.0	29.34	28.93	29.28	11502038.0
2008-05-06 10:00:00	MSFT	Stock	29.28	29.69	29.28	29.6	21067877.0
2008-05-06 11:00:00	MSFT	Stock	29.6	29.64	29.35	29.45	10043733.0
2008-05-06 12:00:00	MSFT	Stock	29.45	29.58	29.43	29.5	9219727.0
2008-05-06 13:00:00	MSFT	Stock	29.49	29.61	29.48	29.58	7568086.0
2008-05-06 14:00:00	MSFT	Stock	29.58	29.7	29.51	29.66	9264412.0
2008-05-06 15:00:00	MSFT	Stock	29.66	29.86	29.6	29.72	17253728.0
2008-05-06 16:00:00	MSFT	Stock	29.7	29.8	29.516	29.68	5732427.0
2008-05-06 17:00:00	MSFT	Stock	29.7	29.78	29.41	29.7	187372.0
2008-05-06 18:00:00	MSFT	Stock	29.63	29.7	29.61	29.7	23118.0
2008-05-06 19:00:00	MSFT	Stock	29.7	29.74	29.65	29.68	8710.0
2008-05-06 07:00:00	NVDA	Stock	0.55	0.55	0.549	0.549	40000.0
2008-05-06 08:00:00	NVDA	Stock	0.549	0.5525	0.5428	0.5432	971600.0
2008-05-06 09:00:00	NVDA	Stock	0.543	0.5488	0.539	0.5415	67180440.0
2008-05-06 10:00:00	NVDA	Stock	0.5415	0.5495	0.5405	0.549	87441720.0
2008-05-06 11:00:00	NVDA	Stock	0.5488	0.5498	0.543	0.5475	60054880.0
2008-05-06 12:00:00	NVDA	Stock	0.5475	0.5575	0.5474	0.5565	105812360.0
2008-05-06 13:00:00	NVDA	Stock	0.5566	0.5588	0.554	0.5582	65500520.0
2008-05-06 14:00:00	NVDA	Stock	0.5582	0.56	0.554	0.5598	73161040.0
2008-05-06 15:00:00	NVDA	Stock	0.5598	0.5645	0.5595	0.5638	173552920.0
2008-05-06 16:00:00	NVDA	Stock	0.5632	0.5648	0.5422	0.5625	90519400.0
2008-05-06 17:00:00	NVDA	Stock	0.562	0.5645	0.5539	0.5645	344520.0
2008-05-06 18:00:00	NVDA	Stock	0.5645	0.5658	0.5638	0.5638	351480.0
2008-05-06 19:00:00	NVDA	Stock	0.564	0.5642	0.564	0.5642	85200.0
2008-05-06 08:00:00	AMZN	Stock	3.796	3.7975	3.785	3.785	74860.0
2008-05-06 09:00:00	AMZN	Stock	3.7705	3.8	3.7525	3.774	16522880.0
2008-05-06 10:00:00	AMZN	Stock	3.7735	3.794	3.766	3.778	15637780.0
2008-05-06 11:00:00	AMZN	Stock	3.778	3.7985	3.768	3.786	12504040.0
2008-05-06 12:00:00	AMZN	Stock	3.7865	3.8375	3.7845	3.823	22830640.0
2008-05-06 13:00:00	AMZN	Stock	3.823	3.8385	3.7775	3.8035	15742780.0
2008-05-06 14:00:00	AMZN	Stock	3.801	3.8065	3.784	3.793	11777940.0
2008-05-06 15:00:00	AMZN	Stock	3.794	3.8035	3.771	3.785	26536120.0
2008-05-06 16:00:00	AMZN	Stock	3.78	3.8005	3.7755	3.785	2141200.0

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

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