PREVIEW / stock_1hour / 2008-06-11

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-11.parquet
  size:    835 KB
  rows:    40,227
  symbols: 3,314

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-11 04:00:00	AAPL	Stock	6.6239	6.6239	6.6239	6.6239	2800.0
2008-06-11 05:00:00	AAPL	Stock	6.6568	6.6568	6.6568	6.6568	2800.0
2008-06-11 06:00:00	AAPL	Stock	6.6429	6.6429	6.6429	6.6429	8400.0
2008-06-11 07:00:00	AAPL	Stock	6.6618	6.6657	6.6432	6.6654	260400.0
2008-06-11 08:00:00	AAPL	Stock	6.6625	6.6661	6.6179	6.6314	4141928.0
2008-06-11 09:00:00	AAPL	Stock	6.6314	6.6429	6.5511	6.5658	129054408.0
2008-06-11 10:00:00	AAPL	Stock	6.5654	6.5661	6.4743	6.5482	200686864.0
2008-06-11 11:00:00	AAPL	Stock	6.5475	6.5804	6.4729	6.5279	147308392.0
2008-06-11 12:00:00	AAPL	Stock	6.5275	6.5282	6.4554	6.475	88398548.0
2008-06-11 13:00:00	AAPL	Stock	6.4754	6.5104	6.4661	6.4893	76475224.0
2008-06-11 14:00:00	AAPL	Stock	6.4879	6.5321	6.4768	6.4857	85261484.0
2008-06-11 15:00:00	AAPL	Stock	6.485	6.4954	6.4139	6.4625	172082400.0
2008-06-11 16:00:00	AAPL	Stock	6.4634	6.5077	6.4446	6.45	15891288.0
2008-06-11 17:00:00	AAPL	Stock	6.45	6.4575	6.4486	6.4514	447692.0
2008-06-11 18:00:00	AAPL	Stock	6.4518	6.4568	6.4468	6.4482	260596.0
2008-06-11 19:00:00	AAPL	Stock	6.4482	6.4536	6.4468	6.4482	381696.0
2008-06-11 08:00:00	MSFT	Stock	27.95	27.98	27.95	27.95	6433.0
2008-06-11 09:00:00	MSFT	Stock	27.97	27.97	27.56	27.6	4462029.0
2008-06-11 10:00:00	MSFT	Stock	27.6	27.69	27.48	27.59	10122095.0
2008-06-11 11:00:00	MSFT	Stock	27.59	27.63	27.32	27.44	7690468.0
2008-06-11 12:00:00	MSFT	Stock	27.43	27.46	27.25	27.32	5791435.0
2008-06-11 13:00:00	MSFT	Stock	27.31	27.37	27.27	27.37	5297799.0
2008-06-11 14:00:00	MSFT	Stock	27.36	27.45	27.25	27.265	6937572.0
2008-06-11 15:00:00	MSFT	Stock	27.26	27.33	27.11	27.13	12967174.0
2008-06-11 16:00:00	MSFT	Stock	27.12	27.398	27.0	27.16	2952957.0
2008-06-11 17:00:00	MSFT	Stock	27.18	27.19	27.12	27.19	17289.0
2008-06-11 18:00:00	MSFT	Stock	27.19	27.2	27.12	27.19	1203086.0
2008-06-11 19:00:00	MSFT	Stock	27.19	27.27	27.19	27.27	16600.0
2008-06-11 08:00:00	NVDA	Stock	0.5638	0.5638	0.5605	0.5635	59800.0
2008-06-11 09:00:00	NVDA	Stock	0.5612	0.5612	0.549	0.5545	84270880.0
2008-06-11 10:00:00	NVDA	Stock	0.5542	0.5542	0.5375	0.5498	255473760.0
2008-06-11 11:00:00	NVDA	Stock	0.5498	0.551	0.5428	0.549	141854640.0
2008-06-11 12:00:00	NVDA	Stock	0.549	0.5492	0.54	0.541	95470080.0
2008-06-11 13:00:00	NVDA	Stock	0.541	0.5708	0.5382	0.54	103762160.0
2008-06-11 14:00:00	NVDA	Stock	0.5398	0.5445	0.539	0.5392	84509480.0
2008-06-11 15:00:00	NVDA	Stock	0.5392	0.5405	0.5305	0.5315	198363160.0
2008-06-11 16:00:00	NVDA	Stock	0.5315	0.5436	0.53	0.5312	20917400.0
2008-06-11 17:00:00	NVDA	Stock	0.5312	0.5312	0.5287	0.53	514240.0
2008-06-11 18:00:00	NVDA	Stock	0.53	0.5312	0.5298	0.53	370000.0
2008-06-11 19:00:00	NVDA	Stock	0.5312	0.5312	0.5287	0.5312	42800.0
2008-06-11 08:00:00	AMZN	Stock	3.98	3.98	3.9555	3.9555	12000.0
2008-06-11 09:00:00	AMZN	Stock	3.9675	4.0	3.9375	3.939	12354080.0
2008-06-11 10:00:00	AMZN	Stock	3.938	3.952	3.887	3.93	22773220.0
2008-06-11 11:00:00	AMZN	Stock	3.9285	3.93	3.88	3.891	12174780.0
2008-06-11 12:00:00	AMZN	Stock	3.8925	3.9	3.881	3.8995	11383440.0
2008-06-11 13:00:00	AMZN	Stock	3.8996	3.92	3.89	3.9085	10719200.0
2008-06-11 14:00:00	AMZN	Stock	3.9085	3.921	3.9	3.9005	12348500.0
2008-06-11 15:00:00	AMZN	Stock	3.9	3.913	3.8515	3.8635	28826340.0
2008-06-11 16:00:00	AMZN	Stock	3.864	3.9038	3.8615	3.8615	802580.0
2008-06-11 17:00:00	AMZN	Stock	3.864	3.864	3.862	3.862	218280.0

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

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