PREVIEW / stock_1hour / 2009-02-17

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-17.parquet
  size:    802 KB
  rows:    40,007
  symbols: 3,303

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-02-17 04:00:00	AAPL	Stock	3.5182	3.5182	3.5182	3.5182	2800.0
2009-02-17 05:00:00	AAPL	Stock	3.4821	3.4821	3.4821	3.4821	2800.0
2009-02-17 07:00:00	AAPL	Stock	3.4714	3.4714	3.4571	3.4643	53144.0
2009-02-17 08:00:00	AAPL	Stock	3.4696	3.4821	3.4454	3.4582	1853012.0
2009-02-17 09:00:00	AAPL	Stock	3.4582	3.47	3.3764	3.4071	115201352.0
2009-02-17 10:00:00	AAPL	Stock	3.4071	3.4332	3.3896	3.4236	102791640.0
2009-02-17 11:00:00	AAPL	Stock	3.4232	3.4236	3.3857	3.3868	70039200.0
2009-02-17 12:00:00	AAPL	Stock	3.3868	3.3996	3.3825	3.3932	47831112.0
2009-02-17 13:00:00	AAPL	Stock	3.3936	3.4043	3.3775	3.3896	64609300.0
2009-02-17 14:00:00	AAPL	Stock	3.39	3.4129	3.3825	3.3896	72955064.0
2009-02-17 15:00:00	AAPL	Stock	3.3896	3.4196	3.3671	3.3761	160768692.0
2009-02-17 16:00:00	AAPL	Stock	3.3761	3.4072	3.376	3.3786	20543320.0
2009-02-17 17:00:00	AAPL	Stock	3.3786	3.3829	3.3661	3.3782	184240.0
2009-02-17 18:00:00	AAPL	Stock	3.3768	3.3786	3.3746	3.3746	17547712.0
2009-02-17 19:00:00	AAPL	Stock	3.3804	3.3804	3.3661	3.3696	250460.0
2009-02-17 07:00:00	MSFT	Stock	18.66	18.7	18.66	18.7	2130.0
2009-02-17 08:00:00	MSFT	Stock	18.7	18.86	18.38	18.4	52996.0
2009-02-17 09:00:00	MSFT	Stock	18.53	18.78	17.89	17.96	12134334.0
2009-02-17 10:00:00	MSFT	Stock	17.97	18.21	17.93	18.15	13386103.0
2009-02-17 11:00:00	MSFT	Stock	18.14	18.25	18.07	18.185	10186263.0
2009-02-17 12:00:00	MSFT	Stock	18.185	18.26	18.15	18.26	5862778.0
2009-02-17 13:00:00	MSFT	Stock	18.255	18.37	18.14	18.241	7161153.0
2009-02-17 14:00:00	MSFT	Stock	18.25	18.5	18.22	18.38	8093107.0
2009-02-17 15:00:00	MSFT	Stock	18.385	18.5	18.1	18.1	14175291.0
2009-02-17 16:00:00	MSFT	Stock	18.09	18.35	18.01	18.13	3779957.0
2009-02-17 17:00:00	MSFT	Stock	18.13	18.207	18.12	18.19	385909.0
2009-02-17 18:00:00	MSFT	Stock	18.09	18.15	18.09	18.15	20587.0
2009-02-17 19:00:00	MSFT	Stock	18.12	18.23	18.12	18.12	8275.0
2009-02-17 04:00:00	NVDA	Stock	0.2038	0.2038	0.2038	0.2038	17160.0
2009-02-17 08:00:00	NVDA	Stock	0.2068	0.2068	0.1992	0.1992	475760.0
2009-02-17 09:00:00	NVDA	Stock	0.1992	0.2027	0.195	0.2007	137410400.0
2009-02-17 10:00:00	NVDA	Stock	0.2007	0.2047	0.2002	0.2018	108326800.0
2009-02-17 11:00:00	NVDA	Stock	0.2018	0.202	0.1962	0.198	110680560.0
2009-02-17 12:00:00	NVDA	Stock	0.198	0.1992	0.1958	0.1972	73439800.0
2009-02-17 13:00:00	NVDA	Stock	0.1972	0.1978	0.195	0.1965	52202440.0
2009-02-17 14:00:00	NVDA	Stock	0.1965	0.2005	0.1962	0.1985	91282240.0
2009-02-17 15:00:00	NVDA	Stock	0.1985	0.1995	0.1958	0.1958	178185680.0
2009-02-17 16:00:00	NVDA	Stock	0.196	0.1987	0.195	0.1958	6109640.0
2009-02-17 17:00:00	NVDA	Stock	0.195	0.195	0.195	0.195	232000.0
2009-02-17 18:00:00	NVDA	Stock	0.195	0.195	0.195	0.195	200000.0
2009-02-17 04:00:00	AMZN	Stock	3.141	3.141	3.141	3.141	2000.0
2009-02-17 07:00:00	AMZN	Stock	3.105	3.105	3.105	3.105	18000.0
2009-02-17 08:00:00	AMZN	Stock	3.1125	3.12	3.071	3.0735	168260.0
2009-02-17 09:00:00	AMZN	Stock	3.0775	3.124	3.059	3.094	26565240.0
2009-02-17 10:00:00	AMZN	Stock	3.0935	3.1	3.064	3.0975	19052800.0
2009-02-17 11:00:00	AMZN	Stock	3.0975	3.1	3.0825	3.0895	10791580.0
2009-02-17 12:00:00	AMZN	Stock	3.0885	3.0995	3.08	3.084	11563600.0
2009-02-17 13:00:00	AMZN	Stock	3.0845	3.0925	3.0675	3.078	12803820.0
2009-02-17 14:00:00	AMZN	Stock	3.079	3.117	3.0725	3.103	22616440.0
2009-02-17 15:00:00	AMZN	Stock	3.102	3.1325	3.08	3.084	33506960.0

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

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