PREVIEW / stock_1hour / 2008-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-08.parquet
  size:    794 KB
  rows:    39,816
  symbols: 3,280

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-04-08 05:00:00	AAPL	Stock	5.5254	5.5286	5.4825	5.495	280000.0
2008-04-08 06:00:00	AAPL	Stock	5.5179	5.5179	5.4861	5.4932	304164.0
2008-04-08 07:00:00	AAPL	Stock	5.49	5.4946	5.4639	5.4729	1708056.0
2008-04-08 08:00:00	AAPL	Stock	5.4732	5.4982	5.4682	5.4843	6212836.0
2008-04-08 09:00:00	AAPL	Stock	5.4836	5.5275	5.45	5.5157	155714468.0
2008-04-08 10:00:00	AAPL	Stock	5.5161	5.5875	5.4914	5.5625	212216760.0
2008-04-08 11:00:00	AAPL	Stock	5.5629	5.5804	5.5196	5.5336	113201732.0
2008-04-08 12:00:00	AAPL	Stock	5.5336	5.5429	5.51	5.5157	67341652.0
2008-04-08 13:00:00	AAPL	Stock	5.5157	5.5271	5.49	5.5139	82226424.0
2008-04-08 14:00:00	AAPL	Stock	5.5139	5.5143	5.44	5.4807	166626908.0
2008-04-08 15:00:00	AAPL	Stock	5.4804	5.4814	5.4421	5.4575	152086144.0
2008-04-08 16:00:00	AAPL	Stock	5.4575	5.5764	5.4568	5.4646	35599928.0
2008-04-08 17:00:00	AAPL	Stock	5.4661	5.4714	5.4586	5.4679	919828.0
2008-04-08 18:00:00	AAPL	Stock	5.4679	5.4779	5.4671	5.4746	643160.0
2008-04-08 19:00:00	AAPL	Stock	5.4704	5.4875	5.4704	5.4857	514108.0
2008-04-08 08:00:00	MSFT	Stock	29.05	29.16	28.95	29.0	34720.0
2008-04-08 09:00:00	MSFT	Stock	29.0	29.0	28.79	28.795	3417535.0
2008-04-08 10:00:00	MSFT	Stock	28.79	28.85	28.68	28.82	7198802.0
2008-04-08 11:00:00	MSFT	Stock	28.815	28.85	28.74	28.77	3662384.0
2008-04-08 12:00:00	MSFT	Stock	28.765	28.9	28.72	28.73	3577782.0
2008-04-08 13:00:00	MSFT	Stock	28.74	28.8	28.68	28.705	3887253.0
2008-04-08 14:00:00	MSFT	Stock	28.7	28.8	28.54	28.792	5908399.0
2008-04-08 15:00:00	MSFT	Stock	28.8	28.85	28.73	28.79	8735056.0
2008-04-08 16:00:00	MSFT	Stock	28.79	29.16	28.67	28.71	7380323.0
2008-04-08 17:00:00	MSFT	Stock	28.71	28.75	28.7	28.7	2654.0
2008-04-08 18:00:00	MSFT	Stock	28.74	28.75	28.72	28.75	1825087.0
2008-04-08 19:00:00	MSFT	Stock	28.75	28.77	28.74	28.77	18890.0
2008-04-08 08:00:00	NVDA	Stock	0.477	0.477	0.475	0.4763	190600.0
2008-04-08 09:00:00	NVDA	Stock	0.476	0.481	0.475	0.4798	66847040.0
2008-04-08 10:00:00	NVDA	Stock	0.4798	0.4935	0.478	0.4906	121805840.0
2008-04-08 11:00:00	NVDA	Stock	0.4908	0.4918	0.4858	0.4858	78847200.0
2008-04-08 12:00:00	NVDA	Stock	0.486	0.4878	0.4848	0.4868	70238600.0
2008-04-08 13:00:00	NVDA	Stock	0.4868	0.4895	0.484	0.4848	70731400.0
2008-04-08 14:00:00	NVDA	Stock	0.485	0.485	0.479	0.4822	75887200.0
2008-04-08 15:00:00	NVDA	Stock	0.4822	0.4822	0.4775	0.4782	121715680.0
2008-04-08 16:00:00	NVDA	Stock	0.4782	0.4838	0.478	0.4788	29718080.0
2008-04-08 17:00:00	NVDA	Stock	0.4788	0.4798	0.4788	0.4798	44000.0
2008-04-08 18:00:00	NVDA	Stock	0.48	0.4808	0.48	0.4808	104000.0
2008-04-08 19:00:00	NVDA	Stock	0.4808	0.4825	0.48	0.4805	208000.0
2008-04-08 08:00:00	AMZN	Stock	3.845	3.845	3.8025	3.803	520000.0
2008-04-08 09:00:00	AMZN	Stock	3.805	3.84	3.775	3.8175	8838480.0
2008-04-08 10:00:00	AMZN	Stock	3.817	3.8655	3.804	3.8505	16045340.0
2008-04-08 11:00:00	AMZN	Stock	3.853	3.863	3.8145	3.833	11527940.0
2008-04-08 12:00:00	AMZN	Stock	3.834	3.853	3.817	3.832	8923120.0
2008-04-08 13:00:00	AMZN	Stock	3.832	3.848	3.825	3.843	10394500.0
2008-04-08 14:00:00	AMZN	Stock	3.8405	3.8585	3.825	3.856	15308020.0
2008-04-08 15:00:00	AMZN	Stock	3.856	3.8805	3.8385	3.8675	21436700.0
2008-04-08 16:00:00	AMZN	Stock	3.8605	3.8755	3.8392	3.845	893560.0
2008-04-08 17:00:00	AMZN	Stock	3.8715	3.8715	3.8215	3.827	418000.0
2008-04-08 18:00:00	AMZN	Stock	3.8275	3.8325	3.825	3.825	140000.0

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

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