PREVIEW / stock_1hour / 2001-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-03-01.parquet
  size:    355 KB
  rows:    16,542
  symbols: 1,273

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
2001-03-01 08:00:00	AAPL	Stock	0.3203	0.3203	0.3181	0.3181	190400.0
2001-03-01 09:00:00	AAPL	Stock	0.3192	0.3259	0.3125	0.3147	58693600.0
2001-03-01 10:00:00	AAPL	Stock	0.3147	0.327	0.3125	0.317	54952800.0
2001-03-01 11:00:00	AAPL	Stock	0.317	0.3203	0.3158	0.3181	25513600.0
2001-03-01 12:00:00	AAPL	Stock	0.317	0.3181	0.3125	0.3147	27820800.0
2001-03-01 13:00:00	AAPL	Stock	0.3147	0.3181	0.3069	0.317	39681600.0
2001-03-01 14:00:00	AAPL	Stock	0.317	0.3203	0.3103	0.3181	39020800.0
2001-03-01 15:00:00	AAPL	Stock	0.3181	0.3348	0.317	0.3348	63554400.0
2001-03-01 16:00:00	AAPL	Stock	0.3348	0.3382	0.3192	0.3348	8758400.0
2001-03-01 17:00:00	AAPL	Stock	0.3348	0.3348	0.3225	0.327	537600.0
2001-03-01 18:00:00	AAPL	Stock	0.327	0.3292	0.3237	0.3292	72800.0
2001-03-01 08:00:00	MSFT	Stock	29.4688	29.5	29.0	29.0	253600.0
2001-03-01 09:00:00	MSFT	Stock	29.0312	29.3125	28.5312	28.75	14271600.0
2001-03-01 10:00:00	MSFT	Stock	28.75	29.0	28.5	28.5	13069400.0
2001-03-01 11:00:00	MSFT	Stock	28.5312	28.9062	28.4375	28.8125	5610200.0
2001-03-01 12:00:00	MSFT	Stock	28.8125	28.8438	28.2656	28.3125	5539600.0
2001-03-01 13:00:00	MSFT	Stock	28.2812	28.625	28.1562	28.4375	5809400.0
2001-03-01 14:00:00	MSFT	Stock	28.4062	28.875	28.125	28.7344	10992400.0
2001-03-01 15:00:00	MSFT	Stock	28.7188	29.75	28.5	29.75	15429000.0
2001-03-01 16:00:00	MSFT	Stock	29.6875	29.8438	28.6562	28.75	5853800.0
2001-03-01 17:00:00	MSFT	Stock	29.1875	29.6719	28.6406	29.0	485800.0
2001-03-01 18:00:00	MSFT	Stock	29.0	29.0625	28.9688	29.0625	13800.0
2001-03-01 08:00:00	NVDA	Stock	0.1868	0.1868	0.1846	0.1846	528000.0
2001-03-01 09:00:00	NVDA	Stock	0.1846	0.1846	0.1724	0.1747	121584000.0
2001-03-01 10:00:00	NVDA	Stock	0.1747	0.1849	0.1747	0.1793	157248000.0
2001-03-01 11:00:00	NVDA	Stock	0.1792	0.182	0.1773	0.1786	71976000.0
2001-03-01 12:00:00	NVDA	Stock	0.1784	0.1799	0.1766	0.1766	36648000.0
2001-03-01 13:00:00	NVDA	Stock	0.1766	0.1789	0.1711	0.1727	49872000.0
2001-03-01 14:00:00	NVDA	Stock	0.1724	0.1776	0.1667	0.1773	169104000.0
2001-03-01 15:00:00	NVDA	Stock	0.1771	0.2042	0.1766	0.2003	242400000.0
2001-03-01 16:00:00	NVDA	Stock	0.2	0.2021	0.1969	0.1977	6072000.0
2001-03-01 17:00:00	NVDA	Stock	0.2	0.201	0.1875	0.1875	840000.0
2001-03-01 18:00:00	NVDA	Stock	0.1875	0.1875	0.1875	0.1875	24000.0
2001-03-01 08:00:00	AMZN	Stock	0.4984	0.5062	0.4906	0.4906	230000.0
2001-03-01 09:00:00	AMZN	Stock	0.4875	0.4969	0.4812	0.4844	28288000.0
2001-03-01 10:00:00	AMZN	Stock	0.4812	0.5062	0.4797	0.5	45874000.0
2001-03-01 11:00:00	AMZN	Stock	0.5031	0.5219	0.5	0.5156	13844000.0
2001-03-01 12:00:00	AMZN	Stock	0.5156	0.5344	0.5125	0.5219	21916000.0
2001-03-01 13:00:00	AMZN	Stock	0.525	0.5281	0.5125	0.5188	13304000.0
2001-03-01 14:00:00	AMZN	Stock	0.5203	0.525	0.5125	0.5188	36474000.0
2001-03-01 15:00:00	AMZN	Stock	0.5219	0.5344	0.5156	0.525	46660000.0
2001-03-01 16:00:00	AMZN	Stock	0.525	0.525	0.4938	0.5219	6636000.0
2001-03-01 17:00:00	AMZN	Stock	0.5172	0.5188	0.5125	0.5188	8000.0
2001-03-01 18:00:00	AMZN	Stock	0.5188	0.5188	0.5188	0.5188	14000.0
2001-03-01 09:00:00	CL	Stock	29.4	29.5	29.35	29.395	191800.0
2001-03-01 10:00:00	CL	Stock	29.425	29.475	28.925	28.925	305400.0
2001-03-01 11:00:00	CL	Stock	28.905	29.0	28.825	28.85	399200.0
2001-03-01 12:00:00	CL	Stock	28.85	28.9	28.65	28.8	180400.0
2001-03-01 13:00:00	CL	Stock	28.78	28.825	28.63	28.775	168800.0
2001-03-01 14:00:00	CL	Stock	28.76	29.025	28.67	28.955	352000.0

> showing 50 of 16,542 rows — these rows as CSV

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