PREVIEW / stock_1hour / 2008-02-21

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-21.parquet
  size:    798 KB
  rows:    39,536
  symbols: 3,245

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-21 05:00:00	AAPL	Stock	4.4464	4.4464	4.4457	4.4457	47600.0
2008-02-21 06:00:00	AAPL	Stock	4.4643	4.5	4.4643	4.5	109200.0
2008-02-21 07:00:00	AAPL	Stock	4.5	4.5318	4.4911	4.5121	1173116.0
2008-02-21 08:00:00	AAPL	Stock	4.5179	4.525	4.4832	4.5036	5983712.0
2008-02-21 09:00:00	AAPL	Stock	4.5043	4.5168	4.4564	4.4721	128095912.0
2008-02-21 10:00:00	AAPL	Stock	4.4732	4.4736	4.3725	4.3729	183263556.0
2008-02-21 11:00:00	AAPL	Stock	4.3718	4.4082	4.3579	4.4	145771416.0
2008-02-21 12:00:00	AAPL	Stock	4.4004	4.4004	4.3636	4.3829	70041412.0
2008-02-21 13:00:00	AAPL	Stock	4.3825	4.3907	4.3607	4.3707	74697420.0
2008-02-21 14:00:00	AAPL	Stock	4.3707	4.3993	4.3621	4.3682	97070932.0
2008-02-21 15:00:00	AAPL	Stock	4.3682	4.3693	4.3164	4.3439	208032720.0
2008-02-21 16:00:00	AAPL	Stock	4.3439	4.3953	4.3321	4.3393	24650332.0
2008-02-21 17:00:00	AAPL	Stock	4.3418	4.4221	4.3375	4.3386	4148452.0
2008-02-21 18:00:00	AAPL	Stock	4.3411	4.3457	4.3393	4.3457	328412.0
2008-02-21 19:00:00	AAPL	Stock	4.3457	4.3493	4.3432	4.3493	323344.0
2008-02-21 07:00:00	MSFT	Stock	28.5	28.5	28.5	28.5	100.0
2008-02-21 08:00:00	MSFT	Stock	28.4	28.75	28.34	28.62	1454020.0
2008-02-21 09:00:00	MSFT	Stock	28.61	28.8	28.57	28.79	11893006.0
2008-02-21 10:00:00	MSFT	Stock	28.79	28.96	28.35	28.37	27020294.0
2008-02-21 11:00:00	MSFT	Stock	28.38	28.48	28.25	28.31	11206066.0
2008-02-21 12:00:00	MSFT	Stock	28.31	28.32	28.14	28.28	8037279.0
2008-02-21 13:00:00	MSFT	Stock	28.28	28.34	28.16	28.26	7416152.0
2008-02-21 14:00:00	MSFT	Stock	28.26	28.34	28.182	28.218	6547111.0
2008-02-21 15:00:00	MSFT	Stock	28.215	28.22	27.96	28.12	17704181.0
2008-02-21 16:00:00	MSFT	Stock	28.113	28.426	28.09	28.1	7122697.0
2008-02-21 17:00:00	MSFT	Stock	28.12	28.22	28.1	28.16	443501.0
2008-02-21 18:00:00	MSFT	Stock	28.14	28.15	28.11	28.15	3700.0
2008-02-21 19:00:00	MSFT	Stock	28.13	28.15	28.12	28.12	4020.0
2008-02-21 08:00:00	NVDA	Stock	0.5458	0.5535	0.5458	0.5528	734560.0
2008-02-21 09:00:00	NVDA	Stock	0.553	0.5562	0.5432	0.547	82942240.0
2008-02-21 10:00:00	NVDA	Stock	0.547	0.5472	0.5367	0.5382	109113680.0
2008-02-21 11:00:00	NVDA	Stock	0.5385	0.5445	0.5372	0.5428	62538600.0
2008-02-21 12:00:00	NVDA	Stock	0.543	0.543	0.5365	0.5427	60214520.0
2008-02-21 13:00:00	NVDA	Stock	0.5425	0.543	0.5348	0.5367	52180200.0
2008-02-21 14:00:00	NVDA	Stock	0.5365	0.5398	0.5325	0.5342	68476120.0
2008-02-21 15:00:00	NVDA	Stock	0.534	0.5345	0.529	0.5322	118901240.0
2008-02-21 16:00:00	NVDA	Stock	0.5318	0.5396	0.5305	0.5322	84870040.0
2008-02-21 17:00:00	NVDA	Stock	0.5325	0.5445	0.5325	0.5332	4326000.0
2008-02-21 18:00:00	NVDA	Stock	0.5332	0.5332	0.531	0.5312	180000.0
2008-02-21 19:00:00	NVDA	Stock	0.5302	0.5312	0.53	0.5312	99400.0
2008-02-21 08:00:00	AMZN	Stock	3.705	3.7135	3.6965	3.7	224600.0
2008-02-21 09:00:00	AMZN	Stock	3.7	3.7105	3.6545	3.697	17457020.0
2008-02-21 10:00:00	AMZN	Stock	3.697	3.6995	3.621	3.623	29877380.0
2008-02-21 11:00:00	AMZN	Stock	3.622	3.6585	3.609	3.6541	17745700.0
2008-02-21 12:00:00	AMZN	Stock	3.654	3.656	3.6085	3.644	19095260.0
2008-02-21 13:00:00	AMZN	Stock	3.6445	3.649	3.5865	3.595	17071820.0
2008-02-21 14:00:00	AMZN	Stock	3.595	3.6035	3.4955	3.5245	61582440.0
2008-02-21 15:00:00	AMZN	Stock	3.5245	3.525	3.4685	3.499	78726160.0
2008-02-21 16:00:00	AMZN	Stock	3.498	3.5752	3.486	3.5095	14588160.0
2008-02-21 17:00:00	AMZN	Stock	3.4975	3.682	3.4975	3.5075	4450000.0

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

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