PREVIEW / stock_1hour / 2010-12-16

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-16.parquet
  size:    942 KB
  rows:    45,285
  symbols: 3,537

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
2010-12-16 04:00:00	AAPL	Stock	11.4579	11.4579	11.4579	11.4579	13384.0
2010-12-16 05:00:00	AAPL	Stock	11.4325	11.4643	11.4325	11.4643	30800.0
2010-12-16 06:00:00	AAPL	Stock	11.4682	11.5171	11.4643	11.5171	12600.0
2010-12-16 07:00:00	AAPL	Stock	11.4989	11.5161	11.4864	11.5054	665588.0
2010-12-16 08:00:00	AAPL	Stock	11.5018	11.5036	11.4564	11.4918	2835672.0
2010-12-16 09:00:00	AAPL	Stock	11.4918	11.4946	11.4321	11.4325	45196480.0
2010-12-16 10:00:00	AAPL	Stock	11.4325	11.4704	11.4325	11.4521	47091016.0
2010-12-16 11:00:00	AAPL	Stock	11.4529	11.4946	11.4414	11.4934	50232028.0
2010-12-16 12:00:00	AAPL	Stock	11.4932	11.5218	11.4857	11.5132	33394004.0
2010-12-16 13:00:00	AAPL	Stock	11.5132	11.5171	11.4793	11.4836	35560896.0
2010-12-16 14:00:00	AAPL	Stock	11.4854	11.4929	11.4739	11.4789	22443848.0
2010-12-16 15:00:00	AAPL	Stock	11.48	11.4946	11.4621	11.4643	50993124.0
2010-12-16 16:00:00	AAPL	Stock	11.4646	11.49	11.4583	11.485	15430296.0
2010-12-16 17:00:00	AAPL	Stock	11.4759	11.4861	11.4646	11.4768	3066476.0
2010-12-16 18:00:00	AAPL	Stock	11.4768	11.4814	11.4714	11.4804	252196.0
2010-12-16 19:00:00	AAPL	Stock	11.4804	11.4961	11.4804	11.4961	339584.0
2010-12-16 04:00:00	MSFT	Stock	27.7	27.7	27.7	27.7	1000.0
2010-12-16 07:00:00	MSFT	Stock	27.85	27.85	27.84	27.84	1400.0
2010-12-16 08:00:00	MSFT	Stock	27.85	27.96	27.85	27.93	17459.0
2010-12-16 09:00:00	MSFT	Stock	27.92	27.94	27.69	27.71	8922377.0
2010-12-16 10:00:00	MSFT	Stock	27.71	27.82	27.66	27.74	8533208.0
2010-12-16 11:00:00	MSFT	Stock	27.74	27.8	27.68	27.795	7699212.0
2010-12-16 12:00:00	MSFT	Stock	27.8	27.97	27.77	27.97	5332567.0
2010-12-16 13:00:00	MSFT	Stock	27.97	27.975	27.86	27.861	4341479.0
2010-12-16 14:00:00	MSFT	Stock	27.87	27.88	27.81	27.875	4782804.0
2010-12-16 15:00:00	MSFT	Stock	27.88	27.99	27.875	27.97	10568201.0
2010-12-16 16:00:00	MSFT	Stock	27.988	28.84	27.846	27.98	3048464.0
2010-12-16 17:00:00	MSFT	Stock	27.736	27.98	27.736	27.98	745377.0
2010-12-16 18:00:00	MSFT	Stock	27.96	27.99	27.93	27.97	33411.0
2010-12-16 19:00:00	MSFT	Stock	27.97	27.98	27.93	27.97	7169.0
2010-12-16 08:00:00	NVDA	Stock	0.3675	0.3675	0.3592	0.3592	58600.0
2010-12-16 09:00:00	NVDA	Stock	0.3592	0.3625	0.3575	0.36	84693920.0
2010-12-16 10:00:00	NVDA	Stock	0.3602	0.3622	0.3585	0.3595	130260000.0
2010-12-16 11:00:00	NVDA	Stock	0.3594	0.3622	0.359	0.3596	80761760.0
2010-12-16 12:00:00	NVDA	Stock	0.3598	0.3598	0.3585	0.359	49317200.0
2010-12-16 13:00:00	NVDA	Stock	0.3592	0.3592	0.3575	0.3575	66711800.0
2010-12-16 14:00:00	NVDA	Stock	0.3575	0.3588	0.3571	0.3577	61168720.0
2010-12-16 15:00:00	NVDA	Stock	0.3577	0.3582	0.3562	0.3572	145516280.0
2010-12-16 16:00:00	NVDA	Stock	0.3572	0.3575	0.3569	0.3572	10800080.0
2010-12-16 17:00:00	NVDA	Stock	0.3614	0.3614	0.3572	0.3572	2228880.0
2010-12-16 19:00:00	NVDA	Stock	0.357	0.357	0.357	0.357	59200.0
2010-12-16 07:00:00	AMZN	Stock	8.8	8.83	8.76	8.7985	58000.0
2010-12-16 08:00:00	AMZN	Stock	8.8	8.821	8.785	8.8055	286280.0
2010-12-16 09:00:00	AMZN	Stock	8.7785	8.8125	8.752	8.7655	10706700.0
2010-12-16 10:00:00	AMZN	Stock	8.7573	8.86	8.755	8.8315	17913580.0
2010-12-16 11:00:00	AMZN	Stock	8.8325	8.915	8.829	8.8955	15113520.0
2010-12-16 12:00:00	AMZN	Stock	8.8985	8.915	8.8935	8.8975	6672640.0
2010-12-16 13:00:00	AMZN	Stock	8.898	8.9045	8.8713	8.8786	6199160.0
2010-12-16 14:00:00	AMZN	Stock	8.8795	8.89	8.8605	8.867	6138360.0
2010-12-16 15:00:00	AMZN	Stock	8.8675	8.9135	8.8675	8.903	14860680.0

> showing 50 of 45,285 rows — these rows as CSV

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