PREVIEW / stock_1hour / 2010-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-01.parquet
  size:    903 KB
  rows:    43,488
  symbols: 3,459

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
2010-07-01 04:00:00	AAPL	Stock	9.0	9.05	9.0	9.05	36400.0
2010-07-01 05:00:00	AAPL	Stock	9.0532	9.0532	9.0321	9.0321	12208.0
2010-07-01 06:00:00	AAPL	Stock	9.0686	9.1079	9.0614	9.1079	69160.0
2010-07-01 07:00:00	AAPL	Stock	9.1	9.1	8.9911	9.0336	1040872.0
2010-07-01 08:00:00	AAPL	Stock	9.0286	9.0686	8.9832	9.0679	9317980.0
2010-07-01 09:00:00	AAPL	Stock	9.0686	9.1214	8.9329	8.9532	152616324.0
2010-07-01 10:00:00	AAPL	Stock	8.9532	8.9561	8.6864	8.7711	280239596.0
2010-07-01 11:00:00	AAPL	Stock	8.7704	8.8993	8.7393	8.87	152608988.0
2010-07-01 12:00:00	AAPL	Stock	8.8696	8.9454	8.819	8.8846	96490324.0
2010-07-01 13:00:00	AAPL	Stock	8.8791	8.9089	8.8479	8.8968	78310008.0
2010-07-01 14:00:00	AAPL	Stock	8.895	8.9375	8.7946	8.856	98996492.0
2010-07-01 15:00:00	AAPL	Stock	8.8564	8.9054	8.815	8.8739	128340352.0
2010-07-01 16:00:00	AAPL	Stock	8.8739	9.0814	8.8464	8.8575	16200772.0
2010-07-01 17:00:00	AAPL	Stock	8.9832	8.9832	8.8589	8.8768	445872.0
2010-07-01 18:00:00	AAPL	Stock	8.8732	8.8857	8.8725	8.8857	293692.0
2010-07-01 19:00:00	AAPL	Stock	8.8857	8.9	8.8804	8.8829	422044.0
2010-07-01 06:00:00	MSFT	Stock	22.97	22.97	22.97	22.97	1500.0
2010-07-01 07:00:00	MSFT	Stock	23.05	23.1	23.05	23.1	91584.0
2010-07-01 08:00:00	MSFT	Stock	23.1	23.12	22.94	23.12	203393.0
2010-07-01 09:00:00	MSFT	Stock	23.11	23.25	23.05	23.19	7309067.0
2010-07-01 10:00:00	MSFT	Stock	23.19	23.2	22.73	22.87	17406122.0
2010-07-01 11:00:00	MSFT	Stock	22.87	23.12	22.85	23.016	14149042.0
2010-07-01 12:00:00	MSFT	Stock	23.015	23.19	22.91	23.14	8496852.0
2010-07-01 13:00:00	MSFT	Stock	23.14	23.32	23.11	23.23	9134064.0
2010-07-01 14:00:00	MSFT	Stock	23.24	23.265	23.0	23.095	11194675.0
2010-07-01 15:00:00	MSFT	Stock	23.09	23.31	23.05	23.18	16723664.0
2010-07-01 16:00:00	MSFT	Stock	23.16	23.218	23.0	23.16	3633126.0
2010-07-01 17:00:00	MSFT	Stock	23.01	23.19	23.01	23.19	7696.0
2010-07-01 18:00:00	MSFT	Stock	23.17	23.22	23.16	23.2	15584.0
2010-07-01 19:00:00	MSFT	Stock	23.22	23.22	23.12	23.13	7398.0
2010-07-01 20:00:00	MSFT	Stock	23.18	23.18	23.18	23.18	5000.0
2010-07-01 08:00:00	NVDA	Stock	0.2543	0.2553	0.2543	0.255	132000.0
2010-07-01 09:00:00	NVDA	Stock	0.2558	0.2598	0.254	0.2575	66559480.0
2010-07-01 10:00:00	NVDA	Stock	0.2572	0.2572	0.2482	0.2509	149683560.0
2010-07-01 11:00:00	NVDA	Stock	0.2507	0.257	0.2493	0.2555	81907280.0
2010-07-01 12:00:00	NVDA	Stock	0.2558	0.2588	0.2533	0.2578	98152960.0
2010-07-01 13:00:00	NVDA	Stock	0.2579	0.2588	0.2558	0.258	66611880.0
2010-07-01 14:00:00	NVDA	Stock	0.2583	0.2612	0.257	0.2583	101887040.0
2010-07-01 15:00:00	NVDA	Stock	0.2583	0.2608	0.2575	0.2592	153362840.0
2010-07-01 16:00:00	NVDA	Stock	0.2592	0.2596	0.2563	0.2588	15180400.0
2010-07-01 17:00:00	NVDA	Stock	0.2553	0.2595	0.2553	0.2595	67920.0
2010-07-01 19:00:00	NVDA	Stock	0.2595	0.2595	0.2595	0.2595	38080.0
2010-07-01 08:00:00	AMZN	Stock	5.4075	5.44	5.4	5.44	69380.0
2010-07-01 09:00:00	AMZN	Stock	5.44	5.496	5.4165	5.4735	19041960.0
2010-07-01 10:00:00	AMZN	Stock	5.4755	5.481	5.335	5.3725	33868980.0
2010-07-01 11:00:00	AMZN	Stock	5.372	5.5215	5.34	5.491	30540940.0
2010-07-01 12:00:00	AMZN	Stock	5.492	5.562	5.4645	5.5386	17154340.0
2010-07-01 13:00:00	AMZN	Stock	5.54	5.581	5.5245	5.5725	21108780.0
2010-07-01 14:00:00	AMZN	Stock	5.571	5.5845	5.5085	5.5275	21315440.0
2010-07-01 15:00:00	AMZN	Stock	5.5292	5.5656	5.502	5.548	22858840.0

> showing 50 of 43,488 rows — these rows as CSV

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