PREVIEW / stock_1hour / 2000-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-04-03.parquet
  size:    284 KB
  rows:    14,620
  symbols: 1,152

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
2000-04-03 09:00:00	AAPL	Stock	1.2098	1.2455	1.2054	1.2254	34574400.0
2000-04-03 10:00:00	AAPL	Stock	1.2232	1.2294	1.1747	1.192	65049600.0
2000-04-03 11:00:00	AAPL	Stock	1.192	1.2003	1.1557	1.1719	44598400.0
2000-04-03 12:00:00	AAPL	Stock	1.1741	1.1897	1.1657	1.1869	17292800.0
2000-04-03 13:00:00	AAPL	Stock	1.1869	1.1948	1.1635	1.1948	29680000.0
2000-04-03 14:00:00	AAPL	Stock	1.1942	1.2299	1.1886	1.1925	60760000.0
2000-04-03 15:00:00	AAPL	Stock	1.192	1.2132	1.1691	1.1908	51172800.0
2000-04-03 16:00:00	AAPL	Stock	1.1908	1.1908	1.183	1.1903	627200.0
2000-04-03 09:00:00	MSFT	Stock	47.2188	48.3438	46.5625	46.9375	37919800.0
2000-04-03 10:00:00	MSFT	Stock	46.9375	47.2812	45.5	46.2188	54492200.0
2000-04-03 11:00:00	MSFT	Stock	46.25	46.6406	45.5	45.5312	27239400.0
2000-04-03 12:00:00	MSFT	Stock	45.5312	46.0	45.25	45.25	25153400.0
2000-04-03 13:00:00	MSFT	Stock	45.2812	46.1875	45.0	46.0625	28274200.0
2000-04-03 14:00:00	MSFT	Stock	46.0	46.1875	45.5	45.5156	21534000.0
2000-04-03 15:00:00	MSFT	Stock	45.5	45.875	45.125	45.4062	37280600.0
2000-04-03 16:00:00	MSFT	Stock	45.4375	45.5	45.375	45.4375	265000.0
2000-04-03 09:00:00	NVDA	Stock	0.1744	0.175	0.1667	0.1667	29856000.0
2000-04-03 10:00:00	NVDA	Stock	0.1667	0.1677	0.1583	0.1661	68064000.0
2000-04-03 11:00:00	NVDA	Stock	0.1654	0.1677	0.1586	0.1604	31968000.0
2000-04-03 12:00:00	NVDA	Stock	0.1604	0.1682	0.1602	0.1665	42240000.0
2000-04-03 13:00:00	NVDA	Stock	0.1665	0.1687	0.1637	0.1667	29232000.0
2000-04-03 14:00:00	NVDA	Stock	0.1667	0.1729	0.1656	0.1691	46224000.0
2000-04-03 15:00:00	NVDA	Stock	0.1693	0.1703	0.1604	0.1622	64656000.0
2000-04-03 16:00:00	NVDA	Stock	0.1622	0.1622	0.1622	0.1622	240000.0
2000-04-03 09:00:00	AMZN	Stock	3.2719	3.2844	3.2188	3.2188	8590000.0
2000-04-03 10:00:00	AMZN	Stock	3.2219	3.2438	3.15	3.225	16280000.0
2000-04-03 11:00:00	AMZN	Stock	3.2188	3.25	3.1688	3.175	11310000.0
2000-04-03 12:00:00	AMZN	Stock	3.1813	3.2031	3.1625	3.1688	8100000.0
2000-04-03 13:00:00	AMZN	Stock	3.1719	3.1781	3.1125	3.1688	18540000.0
2000-04-03 14:00:00	AMZN	Stock	3.1688	3.1813	3.125	3.1375	8900000.0
2000-04-03 15:00:00	AMZN	Stock	3.1312	3.1938	3.1	3.1781	18700000.0
2000-04-03 16:00:00	AMZN	Stock	3.1813	3.1813	3.175	3.1781	184000.0
2000-04-03 09:00:00	CL	Stock	28.3125	28.4688	28.2188	28.4375	357400.0
2000-04-03 10:00:00	CL	Stock	28.5	28.8438	28.3125	28.8438	621400.0
2000-04-03 11:00:00	CL	Stock	28.75	29.0625	28.6875	28.875	416400.0
2000-04-03 12:00:00	CL	Stock	28.9062	29.0312	28.7812	28.9688	187800.0
2000-04-03 13:00:00	CL	Stock	29.0	29.6875	29.0	29.5625	426400.0
2000-04-03 14:00:00	CL	Stock	29.5312	30.4375	29.4688	30.125	705400.0
2000-04-03 15:00:00	CL	Stock	30.0938	30.25	29.75	30.25	803200.0
2000-04-03 16:00:00	CL	Stock	30.2188	30.25	30.2188	30.25	220400.0

> showing 40 of 14,620 rows — these rows as CSV

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