PREVIEW / stock_1hour / 2007-04-30

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-30.parquet
  size:    715 KB
  rows:    33,717
  symbols: 2,654

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-04-30 09:00:00	AAPL	Stock	3.5746	3.5807	3.5654	3.5725	115873688.0
2007-04-30 10:00:00	AAPL	Stock	3.5721	3.6064	3.5718	3.6007	129696504.0
2007-04-30 11:00:00	AAPL	Stock	3.6004	3.6071	3.5879	3.5936	61023452.0
2007-04-30 12:00:00	AAPL	Stock	3.5936	3.6021	3.5932	3.5972	30481836.0
2007-04-30 13:00:00	AAPL	Stock	3.5971	3.6021	3.5968	3.6	30062508.0
2007-04-30 14:00:00	AAPL	Stock	3.6	3.6	3.5729	3.5732	79709364.0
2007-04-30 15:00:00	AAPL	Stock	3.5732	3.5854	3.5596	3.5646	134222172.0
2007-04-30 16:00:00	AAPL	Stock	3.565	3.5668	3.5643	3.5643	14180544.0
2007-04-30 09:00:00	MSFT	Stock	30.13	30.19	30.03	30.12	6196438.0
2007-04-30 10:00:00	MSFT	Stock	30.12	30.37	30.07	30.37	8256405.0
2007-04-30 11:00:00	MSFT	Stock	30.36	30.37	30.16	30.17	6939497.0
2007-04-30 12:00:00	MSFT	Stock	30.17	30.25	30.16	30.17	4974296.0
2007-04-30 13:00:00	MSFT	Stock	30.17	30.2	30.06	30.08	6240933.0
2007-04-30 14:00:00	MSFT	Stock	30.09	30.14	30.02	30.06	6814685.0
2007-04-30 15:00:00	MSFT	Stock	30.07	30.19	29.94	29.94	13406671.0
2007-04-30 16:00:00	MSFT	Stock	29.94	29.95	29.94	29.94	2001071.0
2007-04-30 08:00:00	NVDA	Stock	0.5517	0.5583	0.5517	0.5583	795000.0
2007-04-30 09:00:00	NVDA	Stock	0.5583	0.5628	0.5552	0.5618	77658060.0
2007-04-30 10:00:00	NVDA	Stock	0.5617	0.5657	0.5597	0.5643	99639000.0
2007-04-30 11:00:00	NVDA	Stock	0.5643	0.5648	0.5568	0.5587	58930800.0
2007-04-30 12:00:00	NVDA	Stock	0.5585	0.5645	0.5573	0.5623	46917540.0
2007-04-30 13:00:00	NVDA	Stock	0.5625	0.564	0.5602	0.5612	37703940.0
2007-04-30 14:00:00	NVDA	Stock	0.561	0.5618	0.5515	0.5537	62067540.0
2007-04-30 15:00:00	NVDA	Stock	0.5537	0.5547	0.548	0.5487	126416580.0
2007-04-30 16:00:00	NVDA	Stock	0.5487	0.5497	0.548	0.5493	6711420.0
2007-04-30 17:00:00	NVDA	Stock	0.5493	0.5493	0.5482	0.5482	488940.0
2007-04-30 18:00:00	NVDA	Stock	0.5487	0.5487	0.5487	0.5487	30000.0
2007-04-30 19:00:00	NVDA	Stock	0.5483	0.5483	0.5483	0.5483	9000.0
2007-04-30 06:00:00	AMZN	Stock	3.1125	3.1125	3.1125	3.1125	4000.0
2007-04-30 07:00:00	AMZN	Stock	3.105	3.119	3.0955	3.108	940300.0
2007-04-30 08:00:00	AMZN	Stock	3.1075	3.1245	3.1075	3.1075	2385920.0
2007-04-30 09:00:00	AMZN	Stock	3.1075	3.1145	3.071	3.0875	102920240.0
2007-04-30 10:00:00	AMZN	Stock	3.087	3.122	3.066	3.0735	97749600.0
2007-04-30 11:00:00	AMZN	Stock	3.0735	3.104	3.0635	3.094	69870800.0
2007-04-30 12:00:00	AMZN	Stock	3.094	3.1055	3.0825	3.083	33267980.0
2007-04-30 13:00:00	AMZN	Stock	3.084	3.1015	3.0835	3.0975	22845580.0
2007-04-30 14:00:00	AMZN	Stock	3.098	3.1085	3.08	3.085	52952480.0
2007-04-30 15:00:00	AMZN	Stock	3.085	3.0895	3.059	3.0665	78152100.0
2007-04-30 16:00:00	AMZN	Stock	3.065	3.0855	3.06	3.068	5625140.0
2007-04-30 17:00:00	AMZN	Stock	3.0675	3.068	3.0645	3.065	382640.0
2007-04-30 18:00:00	AMZN	Stock	3.064	3.0675	3.0605	3.065	1666100.0
2007-04-30 19:00:00	AMZN	Stock	3.064	3.0655	3.0615	3.0645	102000.0
2007-04-30 09:00:00	CL	Stock	33.75	33.785	33.6	33.7	1040798.0
2007-04-30 10:00:00	CL	Stock	33.695	33.765	33.695	33.755	790200.0
2007-04-30 11:00:00	CL	Stock	33.755	33.86	33.755	33.77	730660.0
2007-04-30 12:00:00	CL	Stock	33.77	33.86	33.765	33.825	647000.0
2007-04-30 13:00:00	CL	Stock	33.82	33.88	33.775	33.775	323400.0
2007-04-30 14:00:00	CL	Stock	33.775	33.875	33.775	33.87	586210.0
2007-04-30 15:00:00	CL	Stock	33.865	33.89	33.82	33.85	1274884.0
2007-04-30 16:00:00	CL	Stock	33.845	33.87	33.845	33.87	788800.0

> showing 50 of 33,717 rows — these rows as CSV

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