PREVIEW / stock_1hour / 2004-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-10-28.parquet
  size:    519 KB
  rows:    24,036
  symbols: 1,853

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-10-28 08:00:00	AAPL	Stock	0.8955	0.8957	0.8936	0.895	408688.0
2004-10-28 09:00:00	AAPL	Stock	0.8961	0.9	0.8839	0.8996	99389192.0
2004-10-28 10:00:00	AAPL	Stock	0.8996	0.9041	0.8927	0.8971	116417336.0
2004-10-28 11:00:00	AAPL	Stock	0.8971	0.907	0.8966	0.9048	100700768.0
2004-10-28 12:00:00	AAPL	Stock	0.905	0.9093	0.903	0.9088	78787912.0
2004-10-28 13:00:00	AAPL	Stock	0.9086	0.9222	0.908	0.9173	129876152.0
2004-10-28 14:00:00	AAPL	Stock	0.9173	0.9293	0.9164	0.9254	152803280.0
2004-10-28 15:00:00	AAPL	Stock	0.9252	0.9325	0.9221	0.9316	159478480.0
2004-10-28 16:00:00	AAPL	Stock	0.9316	0.9323	0.928	0.9321	5878432.0
2004-10-28 17:00:00	AAPL	Stock	0.9305	0.9321	0.9291	0.9295	104664.0
2004-10-28 18:00:00	AAPL	Stock	0.9291	0.9291	0.9291	0.9291	11200.0
2004-10-28 08:00:00	MSFT	Stock	28.15	28.15	28.11	28.14	46000.0
2004-10-28 09:00:00	MSFT	Stock	28.14	28.2	28.01	28.16	4873692.0
2004-10-28 10:00:00	MSFT	Stock	28.15	28.18	28.07	28.12	8870963.0
2004-10-28 11:00:00	MSFT	Stock	28.12	28.13	27.99	28.01	7971721.0
2004-10-28 12:00:00	MSFT	Stock	28.01	28.03	27.9	28.01	5455400.0
2004-10-28 13:00:00	MSFT	Stock	28.01	28.06	27.98	28.02	6874119.0
2004-10-28 14:00:00	MSFT	Stock	28.01	28.15	28.01	28.079	7857460.0
2004-10-28 15:00:00	MSFT	Stock	28.07	28.13	27.99	28.05	13023605.0
2004-10-28 16:00:00	MSFT	Stock	28.05	28.14	28.01	28.08	5332118.0
2004-10-28 17:00:00	MSFT	Stock	28.08	28.08	28.0	28.06	25248.0
2004-10-28 18:00:00	MSFT	Stock	28.08	28.08	28.07	28.08	4700.0
2004-10-28 08:00:00	NVDA	Stock	0.1228	0.1237	0.1228	0.1236	432000.0
2004-10-28 09:00:00	NVDA	Stock	0.1229	0.125	0.1224	0.1241	96927000.0
2004-10-28 10:00:00	NVDA	Stock	0.1243	0.1246	0.1222	0.1236	96519360.0
2004-10-28 11:00:00	NVDA	Stock	0.1236	0.1238	0.1227	0.1227	59153400.0
2004-10-28 12:00:00	NVDA	Stock	0.1227	0.1236	0.1225	0.1232	51847680.0
2004-10-28 13:00:00	NVDA	Stock	0.1232	0.1242	0.1229	0.1232	55091880.0
2004-10-28 14:00:00	NVDA	Stock	0.1232	0.1238	0.1227	0.1233	84111480.0
2004-10-28 15:00:00	NVDA	Stock	0.1233	0.1235	0.1216	0.1225	108067200.0
2004-10-28 16:00:00	NVDA	Stock	0.1227	0.1242	0.1222	0.1227	4750560.0
2004-10-28 17:00:00	NVDA	Stock	0.1222	0.1222	0.1222	0.1222	36000.0
2004-10-28 08:00:00	AMZN	Stock	1.7085	1.7255	1.7085	1.7225	148000.0
2004-10-28 09:00:00	AMZN	Stock	1.7225	1.7335	1.7075	1.7215	18701040.0
2004-10-28 10:00:00	AMZN	Stock	1.7215	1.723	1.707	1.7115	23805800.0
2004-10-28 11:00:00	AMZN	Stock	1.711	1.7305	1.7105	1.7235	19598400.0
2004-10-28 12:00:00	AMZN	Stock	1.724	1.729	1.72	1.7275	9183860.0
2004-10-28 13:00:00	AMZN	Stock	1.7275	1.7385	1.7245	1.73	15352800.0
2004-10-28 14:00:00	AMZN	Stock	1.7305	1.734	1.717	1.7176	17473120.0
2004-10-28 15:00:00	AMZN	Stock	1.7175	1.725	1.7145	1.724	24664740.0
2004-10-28 16:00:00	AMZN	Stock	1.7245	1.7365	1.7215	1.7225	9437380.0
2004-10-28 17:00:00	AMZN	Stock	1.7225	1.7225	1.7223	1.7225	442800.0
2004-10-28 18:00:00	AMZN	Stock	1.7225	1.7225	1.7225	1.7225	10000.0
2004-10-28 09:00:00	CL	Stock	22.835	22.885	22.735	22.845	754000.0
2004-10-28 10:00:00	CL	Stock	22.85	22.885	22.625	22.65	938400.0
2004-10-28 11:00:00	CL	Stock	22.65	22.655	22.55	22.595	776600.0
2004-10-28 12:00:00	CL	Stock	22.59	22.64	22.565	22.6	633800.0
2004-10-28 13:00:00	CL	Stock	22.595	22.675	22.59	22.645	522400.0
2004-10-28 14:00:00	CL	Stock	22.65	22.66	22.625	22.635	1011200.0
2004-10-28 15:00:00	CL	Stock	22.635	22.64	22.465	22.49	2850400.0

> showing 50 of 24,036 rows — these rows as CSV

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