PREVIEW / stock_1hour / 2004-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-03-18.parquet
  size:    485 KB
  rows:    22,779
  symbols: 1,743

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-03-18 08:00:00	AAPL	Stock	0.4677	0.4677	0.4659	0.4659	123200.0
2004-03-18 09:00:00	AAPL	Stock	0.4646	0.4654	0.4464	0.4598	42631400.0
2004-03-18 10:00:00	AAPL	Stock	0.4598	0.4618	0.4579	0.4589	44924096.0
2004-03-18 11:00:00	AAPL	Stock	0.4589	0.4629	0.458	0.4625	16563736.0
2004-03-18 12:00:00	AAPL	Stock	0.4623	0.4625	0.4588	0.4598	35873096.0
2004-03-18 13:00:00	AAPL	Stock	0.4596	0.4622	0.4582	0.4591	46835656.0
2004-03-18 14:00:00	AAPL	Stock	0.4589	0.4596	0.457	0.4588	48078520.0
2004-03-18 15:00:00	AAPL	Stock	0.4586	0.4625	0.4584	0.4591	65408504.0
2004-03-18 16:00:00	AAPL	Stock	0.4588	0.4598	0.4555	0.458	10695104.0
2004-03-18 17:00:00	AAPL	Stock	0.4584	0.4595	0.458	0.458	279440.0
2004-03-18 18:00:00	AAPL	Stock	0.4575	0.4575	0.4563	0.4563	156800.0
2004-03-18 08:00:00	MSFT	Stock	24.81	25.18	24.6	24.99	2148344.0
2004-03-18 09:00:00	MSFT	Stock	24.98	25.01	24.6	24.8	18129992.0
2004-03-18 10:00:00	MSFT	Stock	24.8	24.84	24.58	24.65	25997555.0
2004-03-18 11:00:00	MSFT	Stock	24.65	24.76	24.6	24.65	14324369.0
2004-03-18 12:00:00	MSFT	Stock	24.64	24.78	24.6199	24.68	18715121.0
2004-03-18 13:00:00	MSFT	Stock	24.69	24.83	24.65	24.679	13430159.0
2004-03-18 14:00:00	MSFT	Stock	24.68	24.78	24.64	24.75	10046347.0
2004-03-18 15:00:00	MSFT	Stock	24.76	24.95	24.75	24.9	17987794.0
2004-03-18 16:00:00	MSFT	Stock	24.89	25.0	24.86	24.97	432826.0
2004-03-18 17:00:00	MSFT	Stock	24.97	24.97	24.885	24.95	19903.0
2004-03-18 18:00:00	MSFT	Stock	24.95	24.97	24.91	24.97	4421.0
2004-03-18 08:00:00	NVDA	Stock	0.1846	0.1846	0.1846	0.1846	180000.0
2004-03-18 09:00:00	NVDA	Stock	0.1847	0.1892	0.1833	0.1863	105702000.0
2004-03-18 10:00:00	NVDA	Stock	0.1862	0.1878	0.1843	0.1868	82047120.0
2004-03-18 11:00:00	NVDA	Stock	0.1868	0.1868	0.1843	0.185	60967200.0
2004-03-18 12:00:00	NVDA	Stock	0.185	0.1867	0.1833	0.1862	51010800.0
2004-03-18 13:00:00	NVDA	Stock	0.1861	0.1877	0.1855	0.1868	80996280.0
2004-03-18 14:00:00	NVDA	Stock	0.1867	0.1874	0.186	0.1867	40145160.0
2004-03-18 15:00:00	NVDA	Stock	0.1866	0.1883	0.1865	0.1867	91060800.0
2004-03-18 16:00:00	NVDA	Stock	0.1869	0.1869	0.1864	0.1867	1498200.0
2004-03-18 17:00:00	NVDA	Stock	0.1867	0.1869	0.1867	0.1867	917640.0
2004-03-18 08:00:00	AMZN	Stock	2.137	2.137	2.137	2.137	6000.0
2004-03-18 09:00:00	AMZN	Stock	2.1325	2.139	2.1125	2.127	15406260.0
2004-03-18 10:00:00	AMZN	Stock	2.127	2.134	2.1105	2.117	18459220.0
2004-03-18 11:00:00	AMZN	Stock	2.1165	2.1335	2.113	2.13	13197820.0
2004-03-18 12:00:00	AMZN	Stock	2.13	2.1335	2.1205	2.1325	12054640.0
2004-03-18 13:00:00	AMZN	Stock	2.1325	2.1565	2.1305	2.139	22840160.0
2004-03-18 14:00:00	AMZN	Stock	2.1395	2.142	2.1275	2.1385	8288440.0
2004-03-18 15:00:00	AMZN	Stock	2.138	2.16	2.138	2.1505	18058080.0
2004-03-18 16:00:00	AMZN	Stock	2.1535	2.155	2.15	2.1505	310060.0
2004-03-18 17:00:00	AMZN	Stock	2.1505	2.16	2.1505	2.1525	18020.0
2004-03-18 18:00:00	AMZN	Stock	2.153	2.153	2.153	2.153	10000.0
2004-03-18 09:00:00	CL	Stock	27.5	27.58	27.455	27.51	200800.0
2004-03-18 10:00:00	CL	Stock	27.51	27.52	27.435	27.45	524200.0
2004-03-18 11:00:00	CL	Stock	27.445	27.46	27.4	27.455	364800.0
2004-03-18 12:00:00	CL	Stock	27.45	27.59	27.355	27.555	382800.0
2004-03-18 13:00:00	CL	Stock	27.55	27.73	27.525	27.565	421200.0
2004-03-18 14:00:00	CL	Stock	27.565	27.6	27.465	27.5	263400.0
2004-03-18 15:00:00	CL	Stock	27.495	27.615	27.485	27.52	581600.0

> showing 50 of 22,779 rows — these rows as CSV

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