PREVIEW / stock_1hour / 2007-02-20

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-20.parquet
  size:    660 KB
  rows:    31,802
  symbols: 2,535

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
2007-02-20 06:00:00	AAPL	Stock	3.0304	3.0304	3.0304	3.0304	11200.0
2007-02-20 08:00:00	AAPL	Stock	3.0296	3.0357	3.0193	3.0321	440328.0
2007-02-20 09:00:00	AAPL	Stock	3.0321	3.0489	3.0057	3.0482	102498564.0
2007-02-20 10:00:00	AAPL	Stock	3.0482	3.0489	3.0214	3.0418	103437824.0
2007-02-20 11:00:00	AAPL	Stock	3.0418	3.0582	3.0375	3.0529	90056708.0
2007-02-20 12:00:00	AAPL	Stock	3.0525	3.0679	3.0521	3.0614	67730572.0
2007-02-20 13:00:00	AAPL	Stock	3.0614	3.0771	3.0604	3.0736	76433728.0
2007-02-20 14:00:00	AAPL	Stock	3.0736	3.075	3.0636	3.0718	64082984.0
2007-02-20 15:00:00	AAPL	Stock	3.0721	3.075	3.0646	3.0679	74170292.0
2007-02-20 16:00:00	AAPL	Stock	3.0679	3.0682	3.0646	3.0679	2896600.0
2007-02-20 17:00:00	AAPL	Stock	3.0664	3.0704	3.0664	3.0675	346808.0
2007-02-20 18:00:00	AAPL	Stock	3.0689	3.0704	3.0675	3.0704	142800.0
2007-02-20 19:00:00	AAPL	Stock	3.0693	3.0704	3.0679	3.0704	152936.0
2007-02-20 04:00:00	MSFT	Stock	28.52	28.52	28.52	28.52	100.0
2007-02-20 07:00:00	MSFT	Stock	28.5	28.63	28.5	28.58	13700.0
2007-02-20 08:00:00	MSFT	Stock	28.64	28.65	28.56	28.62	70650.0
2007-02-20 09:00:00	MSFT	Stock	28.64	28.68	28.54	28.54	8361166.0
2007-02-20 10:00:00	MSFT	Stock	28.54	28.61	28.47	28.557	9277047.0
2007-02-20 11:00:00	MSFT	Stock	28.56	28.7	28.54	28.65	7028760.0
2007-02-20 12:00:00	MSFT	Stock	28.65	28.75	28.63	28.71	4469635.0
2007-02-20 13:00:00	MSFT	Stock	28.71	28.86	28.67	28.82	5203614.0
2007-02-20 14:00:00	MSFT	Stock	28.82	28.86	28.7	28.76	7605637.0
2007-02-20 15:00:00	MSFT	Stock	28.76	28.85	28.73	28.83	8946966.0
2007-02-20 16:00:00	MSFT	Stock	28.82	28.85	28.76	28.79	368156.0
2007-02-20 17:00:00	MSFT	Stock	28.79	28.83	28.79	28.83	390436.0
2007-02-20 18:00:00	MSFT	Stock	28.82	28.83	28.75	28.75	11567.0
2007-02-20 19:00:00	MSFT	Stock	28.78	28.8	28.75	28.75	2900.0
2007-02-20 08:00:00	NVDA	Stock	0.5433	0.5453	0.5433	0.5445	204000.0
2007-02-20 09:00:00	NVDA	Stock	0.5445	0.5507	0.5423	0.5467	89819400.0
2007-02-20 10:00:00	NVDA	Stock	0.5467	0.5478	0.5452	0.5467	117601260.0
2007-02-20 11:00:00	NVDA	Stock	0.5467	0.5532	0.5462	0.5493	126222060.0
2007-02-20 12:00:00	NVDA	Stock	0.5492	0.5525	0.546	0.5487	59368440.0
2007-02-20 13:00:00	NVDA	Stock	0.5485	0.5507	0.548	0.5493	49192380.0
2007-02-20 14:00:00	NVDA	Stock	0.5493	0.5512	0.5485	0.5497	54578220.0
2007-02-20 15:00:00	NVDA	Stock	0.5497	0.5512	0.549	0.5502	97724100.0
2007-02-20 16:00:00	NVDA	Stock	0.5502	0.5503	0.5488	0.5488	335700.0
2007-02-20 17:00:00	NVDA	Stock	0.5492	0.5502	0.5483	0.5483	590280.0
2007-02-20 18:00:00	NVDA	Stock	0.5498	0.5502	0.5485	0.5502	180000.0
2007-02-20 19:00:00	NVDA	Stock	0.55	0.55	0.5483	0.5483	148500.0
2007-02-20 08:00:00	AMZN	Stock	2.0165	2.0165	2.0165	2.0165	2000.0
2007-02-20 09:00:00	AMZN	Stock	2.0035	2.015	2.0	2.01	17054580.0
2007-02-20 10:00:00	AMZN	Stock	2.01	2.056	2.006	2.049	36109140.0
2007-02-20 11:00:00	AMZN	Stock	2.0495	2.087	2.0445	2.069	33808640.0
2007-02-20 12:00:00	AMZN	Stock	2.069	2.0755	2.057	2.074	21192200.0
2007-02-20 13:00:00	AMZN	Stock	2.074	2.0855	2.0696	2.072	17370520.0
2007-02-20 14:00:00	AMZN	Stock	2.0715	2.0775	2.0625	2.0755	18226180.0
2007-02-20 15:00:00	AMZN	Stock	2.0755	2.076	2.0425	2.0755	30747540.0
2007-02-20 16:00:00	AMZN	Stock	2.074	2.0775	2.0725	2.0725	704920.0
2007-02-20 17:00:00	AMZN	Stock	2.0755	2.077	2.0755	2.077	34280.0
2007-02-20 18:00:00	AMZN	Stock	2.076	2.076	2.076	2.076	6000.0

> showing 50 of 31,802 rows — these rows as CSV

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