PREVIEW / stock_1hour / 2004-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-02-27.parquet
  size:    512 KB
  rows:    23,500
  symbols: 1,730

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
2004-02-27 08:00:00	AAPL	Stock	0.415	0.4155	0.4114	0.4114	260400.0
2004-02-27 09:00:00	AAPL	Stock	0.4125	0.4141	0.4098	0.4133	19293680.0
2004-02-27 10:00:00	AAPL	Stock	0.4136	0.4155	0.4125	0.4136	18390848.0
2004-02-27 11:00:00	AAPL	Stock	0.4132	0.417	0.413	0.4161	59728872.0
2004-02-27 12:00:00	AAPL	Stock	0.4161	0.4264	0.4155	0.4229	125087480.0
2004-02-27 13:00:00	AAPL	Stock	0.423	0.4232	0.4209	0.4223	59250016.0
2004-02-27 14:00:00	AAPL	Stock	0.4221	0.4289	0.4221	0.4279	64510152.0
2004-02-27 15:00:00	AAPL	Stock	0.4277	0.4282	0.4248	0.4275	88294248.0
2004-02-27 16:00:00	AAPL	Stock	0.4275	0.4279	0.4257	0.4257	12609576.0
2004-02-27 17:00:00	AAPL	Stock	0.4273	0.4277	0.4255	0.4273	210056.0
2004-02-27 18:00:00	AAPL	Stock	0.4277	0.4277	0.4277	0.4277	56000.0
2004-02-27 08:00:00	MSFT	Stock	26.41	26.6	26.41	26.54	40032.0
2004-02-27 09:00:00	MSFT	Stock	26.53	26.58	26.47	26.51	6426281.0
2004-02-27 10:00:00	MSFT	Stock	26.51	26.62	26.49	26.5	6731860.0
2004-02-27 11:00:00	MSFT	Stock	26.5	26.59	26.41	26.44	9995927.0
2004-02-27 12:00:00	MSFT	Stock	26.44	26.44	26.35	26.41	7451504.0
2004-02-27 13:00:00	MSFT	Stock	26.41	26.49	26.39	26.47	4657047.0
2004-02-27 14:00:00	MSFT	Stock	26.48	26.57	26.45	26.54	4933180.0
2004-02-27 15:00:00	MSFT	Stock	26.54	26.55	26.45	26.53	12673796.0
2004-02-27 16:00:00	MSFT	Stock	26.52	26.54	26.28	26.5	1890976.0
2004-02-27 17:00:00	MSFT	Stock	26.5	26.57	26.5	26.5	48680.0
2004-02-27 18:00:00	MSFT	Stock	26.5	26.5	26.47	26.47	800.0
2004-02-27 08:00:00	NVDA	Stock	0.1889	0.1889	0.1889	0.1889	156000.0
2004-02-27 09:00:00	NVDA	Stock	0.1892	0.1893	0.1875	0.188	37943400.0
2004-02-27 10:00:00	NVDA	Stock	0.1881	0.1892	0.185	0.1857	147543840.0
2004-02-27 11:00:00	NVDA	Stock	0.1857	0.1862	0.1826	0.1842	80721840.0
2004-02-27 12:00:00	NVDA	Stock	0.1842	0.1845	0.1827	0.1843	45719040.0
2004-02-27 13:00:00	NVDA	Stock	0.1843	0.1844	0.1836	0.1838	41346360.0
2004-02-27 14:00:00	NVDA	Stock	0.1838	0.1863	0.1836	0.1863	59943120.0
2004-02-27 15:00:00	NVDA	Stock	0.1863	0.1864	0.184	0.1857	172092600.0
2004-02-27 16:00:00	NVDA	Stock	0.1857	0.1859	0.1848	0.1853	1316640.0
2004-02-27 17:00:00	NVDA	Stock	0.1854	0.1854	0.1847	0.1854	274200.0
2004-02-27 18:00:00	NVDA	Stock	0.1853	0.1853	0.1853	0.1853	192000.0
2004-02-27 08:00:00	AMZN	Stock	2.2	2.2	2.15	2.1665	912000.0
2004-02-27 09:00:00	AMZN	Stock	2.17	2.18	2.1405	2.1535	27495980.0
2004-02-27 10:00:00	AMZN	Stock	2.1525	2.162	2.1285	2.149	31493200.0
2004-02-27 11:00:00	AMZN	Stock	2.1478	2.1536	2.1355	2.1435	21228700.0
2004-02-27 12:00:00	AMZN	Stock	2.1435	2.147	2.13	2.1335	14235960.0
2004-02-27 13:00:00	AMZN	Stock	2.133	2.137	2.1275	2.1275	8594080.0
2004-02-27 14:00:00	AMZN	Stock	2.1275	2.145	2.126	2.1428	11484100.0
2004-02-27 15:00:00	AMZN	Stock	2.1445	2.1535	2.1415	2.151	17664120.0
2004-02-27 16:00:00	AMZN	Stock	2.1535	2.16	2.147	2.1525	4829800.0
2004-02-27 17:00:00	AMZN	Stock	2.1575	2.1575	2.1525	2.1525	39200.0
2004-02-27 18:00:00	AMZN	Stock	2.1505	2.1555	2.1505	2.1555	48000.0
2004-02-27 09:00:00	CL	Stock	27.775	27.85	27.71	27.795	221600.0
2004-02-27 10:00:00	CL	Stock	27.8	27.88	27.765	27.77	322400.0
2004-02-27 11:00:00	CL	Stock	27.765	27.875	27.615	27.65	393800.0
2004-02-27 12:00:00	CL	Stock	27.65	27.655	27.58	27.635	210000.0
2004-02-27 13:00:00	CL	Stock	27.635	27.69	27.625	27.65	196800.0
2004-02-27 14:00:00	CL	Stock	27.65	27.77	27.645	27.77	311200.0

> showing 50 of 23,500 rows — these rows as CSV

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