PREVIEW / stock_1hour / 2007-03-21

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-21.parquet
  size:    681 KB
  rows:    32,478
  symbols: 2,558

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-21 07:00:00	AAPL	Stock	3.2793	3.2793	3.275	3.2786	58800.0
2007-03-21 08:00:00	AAPL	Stock	3.2786	3.2929	3.2718	3.2893	3504536.0
2007-03-21 09:00:00	AAPL	Stock	3.2893	3.2929	3.2671	3.2839	76513024.0
2007-03-21 10:00:00	AAPL	Stock	3.2843	3.2871	3.2732	3.2793	75415816.0
2007-03-21 11:00:00	AAPL	Stock	3.2793	3.2889	3.2793	3.2843	54591292.0
2007-03-21 12:00:00	AAPL	Stock	3.2843	3.2879	3.2818	3.2879	24341380.0
2007-03-21 13:00:00	AAPL	Stock	3.2879	3.2943	3.2857	3.2896	40678260.0
2007-03-21 14:00:00	AAPL	Stock	3.29	3.3439	3.2839	3.3396	161914760.0
2007-03-21 15:00:00	AAPL	Stock	3.34	3.3571	3.3225	3.3525	228497220.0
2007-03-21 16:00:00	AAPL	Stock	3.3525	3.3546	3.345	3.35	6008744.0
2007-03-21 17:00:00	AAPL	Stock	3.3511	3.3511	3.3443	3.3464	3267572.0
2007-03-21 18:00:00	AAPL	Stock	3.3457	3.3496	3.345	3.3464	296688.0
2007-03-21 19:00:00	AAPL	Stock	3.3489	3.3493	3.3457	3.3489	135240.0
2007-03-21 08:00:00	MSFT	Stock	27.88	27.93	27.88	27.93	37475.0
2007-03-21 09:00:00	MSFT	Stock	27.93	28.0	27.57	27.61	5865175.0
2007-03-21 10:00:00	MSFT	Stock	27.6	27.75	27.57	27.63	5896240.0
2007-03-21 11:00:00	MSFT	Stock	27.63	27.65	27.56	27.64	4805000.0
2007-03-21 12:00:00	MSFT	Stock	27.63	27.91	27.63	27.9	4516018.0
2007-03-21 13:00:00	MSFT	Stock	27.9	27.97	27.83	27.83	4435685.0
2007-03-21 14:00:00	MSFT	Stock	27.84	28.46	27.68	28.45	13918115.0
2007-03-21 15:00:00	MSFT	Stock	28.45	28.52	27.972	28.52	21283176.0
2007-03-21 16:00:00	MSFT	Stock	28.51	28.55	28.46	28.47	328611.0
2007-03-21 17:00:00	MSFT	Stock	28.47	28.52	28.46	28.52	2816715.0
2007-03-21 18:00:00	MSFT	Stock	28.52	28.59	28.5	28.5	12796.0
2007-03-21 19:00:00	MSFT	Stock	28.52	28.52	28.49	28.49	373.0
2007-03-21 06:00:00	NVDA	Stock	0.4793	0.4833	0.4793	0.4833	264000.0
2007-03-21 07:00:00	NVDA	Stock	0.4883	0.4948	0.4837	0.4948	1820700.0
2007-03-21 08:00:00	NVDA	Stock	0.4942	0.4948	0.485	0.4917	7508340.0
2007-03-21 09:00:00	NVDA	Stock	0.4923	0.494	0.4725	0.4897	167957820.0
2007-03-21 10:00:00	NVDA	Stock	0.4898	0.49	0.4833	0.4862	161121480.0
2007-03-21 11:00:00	NVDA	Stock	0.4862	0.4867	0.4824	0.4838	169662960.0
2007-03-21 12:00:00	NVDA	Stock	0.4838	0.4915	0.4838	0.4915	112121760.0
2007-03-21 13:00:00	NVDA	Stock	0.4915	0.493	0.4893	0.4907	141203160.0
2007-03-21 14:00:00	NVDA	Stock	0.4907	0.5042	0.4903	0.5038	194748480.0
2007-03-21 15:00:00	NVDA	Stock	0.5038	0.5073	0.495	0.4995	277276380.0
2007-03-21 16:00:00	NVDA	Stock	0.4995	0.5017	0.4983	0.5004	4457580.0
2007-03-21 17:00:00	NVDA	Stock	0.4987	0.5	0.4987	0.5	122242800.0
2007-03-21 18:00:00	NVDA	Stock	0.5	0.5015	0.5	0.5	197100.0
2007-03-21 19:00:00	NVDA	Stock	0.5	0.5	0.4995	0.5	276000.0
2007-03-21 09:00:00	AMZN	Stock	1.9225	1.9275	1.9155	1.9205	9219440.0
2007-03-21 10:00:00	AMZN	Stock	1.9205	1.932	1.916	1.928	7032960.0
2007-03-21 11:00:00	AMZN	Stock	1.9285	1.9435	1.9285	1.936	9258280.0
2007-03-21 12:00:00	AMZN	Stock	1.936	1.94	1.933	1.9345	3080600.0
2007-03-21 13:00:00	AMZN	Stock	1.9345	1.9455	1.9314	1.9325	8564800.0
2007-03-21 14:00:00	AMZN	Stock	1.932	1.975	1.9315	1.974	18148500.0
2007-03-21 15:00:00	AMZN	Stock	1.974	1.99	1.9655	1.99	40899100.0
2007-03-21 16:00:00	AMZN	Stock	1.993	1.9945	1.984	1.9865	298720.0
2007-03-21 17:00:00	AMZN	Stock	1.9855	1.9855	1.984	1.984	4000.0
2007-03-21 18:00:00	AMZN	Stock	1.9855	1.9855	1.9845	1.9845	21080.0
2007-03-21 19:00:00	AMZN	Stock	1.9835	1.984	1.9835	1.984	28000.0

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

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