PREVIEW / stock_1hour / 2008-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-22.parquet
  size:    803 KB
  rows:    40,054
  symbols: 3,267

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-22 04:00:00	AAPL	Stock	4.3554	4.3554	4.355	4.355	5600.0
2008-02-22 07:00:00	AAPL	Stock	4.3589	4.3589	4.3461	4.3461	30800.0
2008-02-22 08:00:00	AAPL	Stock	4.3511	4.3686	4.3436	4.3607	3822196.0
2008-02-22 09:00:00	AAPL	Stock	4.3607	4.3754	4.3093	4.3294	125987596.0
2008-02-22 10:00:00	AAPL	Stock	4.3314	4.3336	4.2421	4.265	298055660.0
2008-02-22 11:00:00	AAPL	Stock	4.2646	4.2804	4.2339	4.2425	177277436.0
2008-02-22 12:00:00	AAPL	Stock	4.2418	4.2429	4.21	4.2305	144143356.0
2008-02-22 13:00:00	AAPL	Stock	4.2306	4.2357	4.1829	4.185	157357564.0
2008-02-22 14:00:00	AAPL	Stock	4.185	4.2143	4.1646	4.2054	205239608.0
2008-02-22 15:00:00	AAPL	Stock	4.2046	4.2661	4.1382	4.2643	393240036.0
2008-02-22 16:00:00	AAPL	Stock	4.2661	4.2829	4.2277	4.2714	23503060.0
2008-02-22 17:00:00	AAPL	Stock	4.2714	4.2761	4.2636	4.2721	1301496.0
2008-02-22 18:00:00	AAPL	Stock	4.2718	4.2725	4.25	4.2625	592508.0
2008-02-22 19:00:00	AAPL	Stock	4.2675	4.2675	4.2571	4.2621	755720.0
2008-02-22 08:00:00	MSFT	Stock	28.16	28.25	28.16	28.22	79330.0
2008-02-22 09:00:00	MSFT	Stock	28.22	28.39	28.11	28.2	8910801.0
2008-02-22 10:00:00	MSFT	Stock	28.2	28.2	27.88	27.9	16722880.0
2008-02-22 11:00:00	MSFT	Stock	27.898	27.93	27.55	27.63	16427646.0
2008-02-22 12:00:00	MSFT	Stock	27.64	27.65	27.2	27.58	19374445.0
2008-02-22 13:00:00	MSFT	Stock	27.58	27.66	27.45	27.65	12021824.0
2008-02-22 14:00:00	MSFT	Stock	27.65	27.76	27.56	27.72	17844605.0
2008-02-22 15:00:00	MSFT	Stock	27.72	27.76	27.54	27.73	29964495.0
2008-02-22 16:00:00	MSFT	Stock	27.719	27.76	27.635	27.7	4323206.0
2008-02-22 17:00:00	MSFT	Stock	27.71	27.73	27.7	27.71	43168.0
2008-02-22 18:00:00	MSFT	Stock	27.72	27.73	27.71	27.72	12208.0
2008-02-22 19:00:00	MSFT	Stock	27.71	27.73	27.71	27.73	4179.0
2008-02-22 08:00:00	NVDA	Stock	0.5312	0.5355	0.5312	0.5355	14168000.0
2008-02-22 09:00:00	NVDA	Stock	0.5355	0.5458	0.5335	0.5438	66039880.0
2008-02-22 10:00:00	NVDA	Stock	0.544	0.545	0.5378	0.541	112334280.0
2008-02-22 11:00:00	NVDA	Stock	0.5412	0.5428	0.5342	0.5375	92071720.0
2008-02-22 12:00:00	NVDA	Stock	0.5378	0.5415	0.5325	0.5407	83129240.0
2008-02-22 13:00:00	NVDA	Stock	0.5407	0.5442	0.5395	0.542	68749640.0
2008-02-22 14:00:00	NVDA	Stock	0.5422	0.5472	0.54	0.5462	73714400.0
2008-02-22 15:00:00	NVDA	Stock	0.5462	0.559	0.5448	0.5585	198100600.0
2008-02-22 16:00:00	NVDA	Stock	0.558	0.5595	0.5441	0.558	14539200.0
2008-02-22 17:00:00	NVDA	Stock	0.5578	0.5588	0.5578	0.5588	100000.0
2008-02-22 18:00:00	NVDA	Stock	0.5588	0.559	0.5575	0.5575	20000.0
2008-02-22 19:00:00	NVDA	Stock	0.559	0.559	0.5582	0.5582	56000.0
2008-02-22 08:00:00	AMZN	Stock	3.495	3.54	3.495	3.535	362000.0
2008-02-22 09:00:00	AMZN	Stock	3.525	3.6015	3.493	3.591	34647880.0
2008-02-22 10:00:00	AMZN	Stock	3.5905	3.5995	3.5375	3.5525	61809920.0
2008-02-22 11:00:00	AMZN	Stock	3.5525	3.595	3.5485	3.57	32029280.0
2008-02-22 12:00:00	AMZN	Stock	3.5705	3.578	3.5385	3.5715	24836540.0
2008-02-22 13:00:00	AMZN	Stock	3.572	3.584	3.5575	3.5655	20869560.0
2008-02-22 14:00:00	AMZN	Stock	3.5645	3.5715	3.5435	3.559	22196200.0
2008-02-22 15:00:00	AMZN	Stock	3.5585	3.6105	3.5225	3.604	44654320.0
2008-02-22 16:00:00	AMZN	Stock	3.604	3.605	3.5625	3.5825	5398320.0
2008-02-22 17:00:00	AMZN	Stock	3.589	3.589	3.579	3.579	13000.0
2008-02-22 18:00:00	AMZN	Stock	3.579	3.579	3.5725	3.5725	14000.0
2008-02-22 19:00:00	AMZN	Stock	3.5925	3.6	3.5925	3.5945	16000.0

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

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