PREVIEW / stock_1hour / 2009-12-02

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-02.parquet
  size:    900 KB
  rows:    42,647
  symbols: 3,428

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
2009-12-02 04:00:00	AAPL	Stock	7.0875	7.0875	7.0732	7.0732	7560.0
2009-12-02 05:00:00	AAPL	Stock	7.0775	7.0836	7.0607	7.0714	37744.0
2009-12-02 06:00:00	AAPL	Stock	7.0714	7.0821	7.0714	7.0779	30800.0
2009-12-02 07:00:00	AAPL	Stock	7.0857	7.1175	7.0793	7.0946	63840.0
2009-12-02 08:00:00	AAPL	Stock	7.0982	7.12	7.0346	7.0941	2359224.0
2009-12-02 09:00:00	AAPL	Stock	7.0964	7.1343	7.0718	7.1179	83222440.0
2009-12-02 10:00:00	AAPL	Stock	7.1179	7.1936	7.1154	7.1493	115870748.0
2009-12-02 11:00:00	AAPL	Stock	7.1493	7.1536	7.0879	7.0921	88526564.0
2009-12-02 12:00:00	AAPL	Stock	7.0921	7.1	7.0393	7.0689	65755480.0
2009-12-02 13:00:00	AAPL	Stock	7.0689	7.0704	7.0	7.0382	100680132.0
2009-12-02 14:00:00	AAPL	Stock	7.0382	7.0546	7.0061	7.0275	85549828.0
2009-12-02 15:00:00	AAPL	Stock	7.0268	7.035	6.9911	7.0043	123045412.0
2009-12-02 16:00:00	AAPL	Stock	7.0043	7.0733	7.0017	7.0107	25315640.0
2009-12-02 17:00:00	AAPL	Stock	7.0111	7.0693	7.0111	7.0204	691824.0
2009-12-02 18:00:00	AAPL	Stock	7.0196	7.0321	7.0082	7.025	1050588.0
2009-12-02 19:00:00	AAPL	Stock	7.025	7.0357	7.0207	7.0343	625436.0
2009-12-02 04:00:00	MSFT	Stock	30.06	30.16	30.06	30.08	2500.0
2009-12-02 07:00:00	MSFT	Stock	30.05	30.05	30.05	30.05	1100.0
2009-12-02 08:00:00	MSFT	Stock	30.01	30.02	29.91	29.92	5163.0
2009-12-02 09:00:00	MSFT	Stock	29.92	30.01	29.67	29.87	4419682.0
2009-12-02 10:00:00	MSFT	Stock	29.87	29.99	29.83	29.92	4764691.0
2009-12-02 11:00:00	MSFT	Stock	29.92	29.95	29.8	29.888	5132304.0
2009-12-02 12:00:00	MSFT	Stock	29.885	29.91	29.8	29.81	4282777.0
2009-12-02 13:00:00	MSFT	Stock	29.815	29.84	29.76	29.76	3138765.0
2009-12-02 14:00:00	MSFT	Stock	29.77	29.81	29.65	29.74	4327948.0
2009-12-02 15:00:00	MSFT	Stock	29.735	29.82	29.68	29.78	6971368.0
2009-12-02 16:00:00	MSFT	Stock	29.77	30.01	29.7	29.7	2368910.0
2009-12-02 17:00:00	MSFT	Stock	29.69	29.78	29.69	29.78	601.0
2009-12-02 18:00:00	MSFT	Stock	29.78	29.78	29.67	29.69	15368.0
2009-12-02 19:00:00	MSFT	Stock	29.76	29.76	29.76	29.76	1180.0
2009-12-02 08:00:00	NVDA	Stock	0.3328	0.335	0.3328	0.335	20840.0
2009-12-02 09:00:00	NVDA	Stock	0.3323	0.3388	0.3318	0.3382	50378800.0
2009-12-02 10:00:00	NVDA	Stock	0.3384	0.3438	0.3382	0.342	145545400.0
2009-12-02 11:00:00	NVDA	Stock	0.3418	0.3425	0.3388	0.3402	55528680.0
2009-12-02 12:00:00	NVDA	Stock	0.3402	0.341	0.3375	0.3409	48845000.0
2009-12-02 13:00:00	NVDA	Stock	0.341	0.3435	0.3402	0.3425	69745240.0
2009-12-02 14:00:00	NVDA	Stock	0.3425	0.3438	0.3413	0.3425	107412560.0
2009-12-02 15:00:00	NVDA	Stock	0.3425	0.3435	0.3418	0.343	113940760.0
2009-12-02 16:00:00	NVDA	Stock	0.343	0.3433	0.333	0.343	1451280.0
2009-12-02 17:00:00	NVDA	Stock	0.343	0.3433	0.343	0.3433	92800.0
2009-12-02 18:00:00	NVDA	Stock	0.343	0.343	0.342	0.342	48000.0
2009-12-02 19:00:00	NVDA	Stock	0.343	0.343	0.343	0.343	4800.0
2009-12-02 07:00:00	AMZN	Stock	6.9435	6.9605	6.9435	6.9485	158000.0
2009-12-02 08:00:00	AMZN	Stock	6.9575	6.96	6.925	6.94	375400.0
2009-12-02 09:00:00	AMZN	Stock	6.941	6.995	6.935	6.9855	21787600.0
2009-12-02 10:00:00	AMZN	Stock	6.9855	7.098	6.984	7.0825	53392180.0
2009-12-02 11:00:00	AMZN	Stock	7.0825	7.1335	7.065	7.1065	37453220.0
2009-12-02 12:00:00	AMZN	Stock	7.1062	7.118	7.05	7.0925	33370580.0
2009-12-02 13:00:00	AMZN	Stock	7.0925	7.0965	7.0555	7.0782	18618480.0
2009-12-02 14:00:00	AMZN	Stock	7.079	7.12	7.07	7.1155	25291920.0

> showing 50 of 42,647 rows — these rows as CSV

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