PREVIEW / stock_1hour / 2008-02-19

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-19.parquet
  size:    804 KB
  rows:    40,427
  symbols: 3,282

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-02-19 04:00:00	AAPL	Stock	4.4854	4.4854	4.4746	4.4746	15400.0
2008-02-19 05:00:00	AAPL	Stock	4.49	4.49	4.49	4.49	7000.0
2008-02-19 06:00:00	AAPL	Stock	4.49	4.4996	4.49	4.4996	100800.0
2008-02-19 07:00:00	AAPL	Stock	4.5086	4.5175	4.4964	4.5132	489440.0
2008-02-19 08:00:00	AAPL	Stock	4.5132	4.5179	4.4936	4.5018	5038404.0
2008-02-19 09:00:00	AAPL	Stock	4.5011	4.5268	4.4746	4.4854	142431800.0
2008-02-19 10:00:00	AAPL	Stock	4.4857	4.5011	4.45	4.47	165189948.0
2008-02-19 11:00:00	AAPL	Stock	4.47	4.495	4.4543	4.4925	87743432.0
2008-02-19 12:00:00	AAPL	Stock	4.4932	4.5082	4.4754	4.4861	89800732.0
2008-02-19 13:00:00	AAPL	Stock	4.4861	4.5204	4.4661	4.4718	95202324.0
2008-02-19 14:00:00	AAPL	Stock	4.4714	4.4793	4.3814	4.3818	160720756.0
2008-02-19 15:00:00	AAPL	Stock	4.3839	4.3946	4.3371	4.3714	240815680.0
2008-02-19 16:00:00	AAPL	Stock	4.3714	4.4482	4.3579	4.3636	17790360.0
2008-02-19 17:00:00	AAPL	Stock	4.4071	4.5002	4.3636	4.3982	796684.0
2008-02-19 18:00:00	AAPL	Stock	4.3982	4.4036	4.3864	4.3896	674520.0
2008-02-19 19:00:00	AAPL	Stock	4.3929	4.4018	4.3861	4.3961	399504.0
2008-02-19 07:00:00	MSFT	Stock	28.75	28.84	28.75	28.82	135100.0
2008-02-19 08:00:00	MSFT	Stock	28.8	28.91	28.68	28.7	443809.0
2008-02-19 09:00:00	MSFT	Stock	28.71	28.84	28.7	28.798	9052826.0
2008-02-19 10:00:00	MSFT	Stock	28.8	28.81	28.621	28.63	10935255.0
2008-02-19 11:00:00	MSFT	Stock	28.628	28.65	28.53	28.65	5351425.0
2008-02-19 12:00:00	MSFT	Stock	28.65	28.78	28.61	28.62	6097198.0
2008-02-19 13:00:00	MSFT	Stock	28.63	28.71	28.56	28.6	7572533.0
2008-02-19 14:00:00	MSFT	Stock	28.6	28.6	28.15	28.16	11014008.0
2008-02-19 15:00:00	MSFT	Stock	28.15	28.26	28.07	28.2	14595875.0
2008-02-19 16:00:00	MSFT	Stock	28.2	28.85	28.16	28.39	2384226.0
2008-02-19 17:00:00	MSFT	Stock	28.39	28.564	28.17	28.35	679468.0
2008-02-19 18:00:00	MSFT	Stock	28.35	28.8	28.35	28.36	11825.0
2008-02-19 19:00:00	MSFT	Stock	28.36	28.37	28.34	28.34	9555.0
2008-02-19 07:00:00	NVDA	Stock	0.5685	0.5685	0.5685	0.5685	4000.0
2008-02-19 08:00:00	NVDA	Stock	0.5662	0.5685	0.5625	0.5675	611200.0
2008-02-19 09:00:00	NVDA	Stock	0.5662	0.5682	0.5588	0.5665	68012080.0
2008-02-19 10:00:00	NVDA	Stock	0.5668	0.5678	0.5605	0.563	80050120.0
2008-02-19 11:00:00	NVDA	Stock	0.5628	0.5642	0.5575	0.5631	52281920.0
2008-02-19 12:00:00	NVDA	Stock	0.5631	0.565	0.5605	0.5625	54735200.0
2008-02-19 13:00:00	NVDA	Stock	0.5628	0.5672	0.5602	0.5605	42359080.0
2008-02-19 14:00:00	NVDA	Stock	0.5605	0.5615	0.549	0.549	75258640.0
2008-02-19 15:00:00	NVDA	Stock	0.549	0.5575	0.5438	0.5482	131005040.0
2008-02-19 16:00:00	NVDA	Stock	0.5485	0.565	0.5485	0.5545	35277720.0
2008-02-19 17:00:00	NVDA	Stock	0.5545	0.5545	0.5485	0.5518	8731880.0
2008-02-19 18:00:00	NVDA	Stock	0.5518	0.5665	0.5498	0.5498	184040.0
2008-02-19 19:00:00	NVDA	Stock	0.5492	0.553	0.525	0.5525	92560.0
2008-02-19 07:00:00	AMZN	Stock	3.661	3.661	3.661	3.661	20000.0
2008-02-19 08:00:00	AMZN	Stock	3.6725	3.705	3.6675	3.6995	419400.0
2008-02-19 09:00:00	AMZN	Stock	3.6975	3.7	3.615	3.6495	20447240.0
2008-02-19 10:00:00	AMZN	Stock	3.648	3.695	3.6265	3.645	24887840.0
2008-02-19 11:00:00	AMZN	Stock	3.6475	3.65	3.6185	3.6465	13266520.0
2008-02-19 12:00:00	AMZN	Stock	3.647	3.6565	3.627	3.628	10009700.0
2008-02-19 13:00:00	AMZN	Stock	3.628	3.6675	3.628	3.658	13402040.0
2008-02-19 14:00:00	AMZN	Stock	3.6575	3.66	3.595	3.5995	20131720.0

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

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