PREVIEW / stock_1hour / 2009-02-25

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-25.parquet
  size:    819 KB
  rows:    41,272
  symbols: 3,309

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-25 06:00:00	AAPL	Stock	3.2018	3.2018	3.2018	3.2018	5600.0
2009-02-25 07:00:00	AAPL	Stock	3.2018	3.2143	3.1807	3.2143	33964.0
2009-02-25 08:00:00	AAPL	Stock	3.2143	3.2232	3.2143	3.2164	237636.0
2009-02-25 09:00:00	AAPL	Stock	3.2196	3.2679	3.2029	3.2393	91626164.0
2009-02-25 10:00:00	AAPL	Stock	3.2396	3.25	3.1875	3.2286	148780464.0
2009-02-25 11:00:00	AAPL	Stock	3.2282	3.2893	3.2218	3.26	107684808.0
2009-02-25 12:00:00	AAPL	Stock	3.2596	3.265	3.2282	3.2479	56998844.0
2009-02-25 13:00:00	AAPL	Stock	3.2471	3.2914	3.2429	3.2816	73372712.0
2009-02-25 14:00:00	AAPL	Stock	3.2807	3.2911	3.2461	3.2768	110268144.0
2009-02-25 15:00:00	AAPL	Stock	3.2768	3.3186	3.2525	3.2525	160062644.0
2009-02-25 16:00:00	AAPL	Stock	3.2579	3.2803	3.25	3.2536	20145860.0
2009-02-25 17:00:00	AAPL	Stock	3.2771	3.2771	3.2557	3.2625	39150020.0
2009-02-25 18:00:00	AAPL	Stock	3.2589	3.2607	3.2557	3.2607	15573880.0
2009-02-25 19:00:00	AAPL	Stock	3.26	3.2654	3.2589	3.2625	249536.0
2009-02-25 07:00:00	MSFT	Stock	17.12	17.13	17.12	17.13	200.0
2009-02-25 08:00:00	MSFT	Stock	17.12	17.13	17.03	17.1	48237.0
2009-02-25 09:00:00	MSFT	Stock	17.11	17.17	16.77	16.9	9458994.0
2009-02-25 10:00:00	MSFT	Stock	16.9	16.9	16.46	16.62	15495823.0
2009-02-25 11:00:00	MSFT	Stock	16.62	16.89	16.6	16.76	9395106.0
2009-02-25 12:00:00	MSFT	Stock	16.76	16.81	16.71	16.79	8313158.0
2009-02-25 13:00:00	MSFT	Stock	16.798	17.08	16.78	17.02	8858038.0
2009-02-25 14:00:00	MSFT	Stock	17.01	17.06	16.78	16.93	9537080.0
2009-02-25 15:00:00	MSFT	Stock	16.93	17.24	16.84	16.84	20072293.0
2009-02-25 16:00:00	MSFT	Stock	16.85	17.0	16.785	16.908	19689395.0
2009-02-25 17:00:00	MSFT	Stock	16.94	16.96	16.91	16.91	9796.0
2009-02-25 18:00:00	MSFT	Stock	16.98	16.98	16.95	16.95	78670.0
2009-02-25 19:00:00	MSFT	Stock	16.95	17.0	16.95	17.0	11522.0
2009-02-25 08:00:00	NVDA	Stock	0.199	0.199	0.1942	0.1942	40000.0
2009-02-25 09:00:00	NVDA	Stock	0.1962	0.2	0.1948	0.1962	69074320.0
2009-02-25 10:00:00	NVDA	Stock	0.1962	0.1965	0.1905	0.1925	100452240.0
2009-02-25 11:00:00	NVDA	Stock	0.1925	0.1995	0.1921	0.1941	100534640.0
2009-02-25 12:00:00	NVDA	Stock	0.1948	0.1968	0.1945	0.1965	62428440.0
2009-02-25 13:00:00	NVDA	Stock	0.1962	0.2007	0.1958	0.1995	55620160.0
2009-02-25 14:00:00	NVDA	Stock	0.1998	0.2018	0.1975	0.2	117607120.0
2009-02-25 15:00:00	NVDA	Stock	0.2	0.206	0.1998	0.2002	178084600.0
2009-02-25 16:00:00	NVDA	Stock	0.2	0.2013	0.1983	0.1987	17818160.0
2009-02-25 19:00:00	NVDA	Stock	0.201	0.201	0.2002	0.2002	16000.0
2009-02-25 06:00:00	AMZN	Stock	3.25	3.25	3.25	3.25	2800.0
2009-02-25 07:00:00	AMZN	Stock	3.25	3.25	3.25	3.25	2000.0
2009-02-25 08:00:00	AMZN	Stock	3.26	3.2745	3.26	3.26	27040.0
2009-02-25 09:00:00	AMZN	Stock	3.2545	3.2875	3.23	3.266	20649340.0
2009-02-25 10:00:00	AMZN	Stock	3.2635	3.264	3.1925	3.2105	27720560.0
2009-02-25 11:00:00	AMZN	Stock	3.2115	3.2405	3.1875	3.1915	19937480.0
2009-02-25 12:00:00	AMZN	Stock	3.1935	3.2	3.1535	3.1675	10466260.0
2009-02-25 13:00:00	AMZN	Stock	3.167	3.2025	3.141	3.189	24409520.0
2009-02-25 14:00:00	AMZN	Stock	3.19	3.195	3.1425	3.177	30096800.0
2009-02-25 15:00:00	AMZN	Stock	3.1765	3.247	3.1705	3.186	38764820.0
2009-02-25 16:00:00	AMZN	Stock	3.1855	3.2044	3.1765	3.1855	3820080.0
2009-02-25 17:00:00	AMZN	Stock	3.2218	3.28	3.1855	3.1855	2532860.0
2009-02-25 19:00:00	AMZN	Stock	3.199	3.199	3.199	3.199	8000.0

> showing 50 of 41,272 rows — these rows as CSV

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