PREVIEW / stock_1hour / 2004-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-14.parquet
  size:    519 KB
  rows:    24,790
  symbols: 1,785

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-06-14 08:00:00	AAPL	Stock	0.5455	0.5489	0.5438	0.5455	442400.0
2004-06-14 09:00:00	AAPL	Stock	0.5455	0.5479	0.5427	0.5443	32865056.0
2004-06-14 10:00:00	AAPL	Stock	0.5439	0.5446	0.5388	0.5402	53191544.0
2004-06-14 11:00:00	AAPL	Stock	0.5402	0.542	0.5393	0.5395	20214152.0
2004-06-14 12:00:00	AAPL	Stock	0.5395	0.5396	0.5341	0.5345	33704328.0
2004-06-14 13:00:00	AAPL	Stock	0.5345	0.5384	0.5341	0.5375	25688992.0
2004-06-14 14:00:00	AAPL	Stock	0.5375	0.5375	0.5339	0.5348	16808512.0
2004-06-14 15:00:00	AAPL	Stock	0.5348	0.5384	0.5348	0.537	38676064.0
2004-06-14 16:00:00	AAPL	Stock	0.5368	0.5379	0.5368	0.5373	3811360.0
2004-06-14 17:00:00	AAPL	Stock	0.5379	0.5379	0.5379	0.5379	359520.0
2004-06-14 08:00:00	MSFT	Stock	26.67	26.79	26.5	26.62	73700.0
2004-06-14 09:00:00	MSFT	Stock	26.61	27.0	26.53	26.64	8255600.0
2004-06-14 10:00:00	MSFT	Stock	26.65	26.8701	26.64	26.82	12127382.0
2004-06-14 11:00:00	MSFT	Stock	26.82	26.85	26.74	26.77	8449264.0
2004-06-14 12:00:00	MSFT	Stock	26.77	26.78	26.66	26.75	6305013.0
2004-06-14 13:00:00	MSFT	Stock	26.75	26.8	26.66	26.78	5914426.0
2004-06-14 14:00:00	MSFT	Stock	26.77	26.79	26.67	26.7	6749366.0
2004-06-14 15:00:00	MSFT	Stock	26.7	26.89	26.65	26.86	15749743.0
2004-06-14 16:00:00	MSFT	Stock	26.86	26.93	26.7652	26.91	2132149.0
2004-06-14 17:00:00	MSFT	Stock	26.89	27.36	26.88	27.15	221542.0
2004-06-14 18:00:00	MSFT	Stock	27.15	27.23	27.13	27.2	10100.0
2004-06-14 08:00:00	NVDA	Stock	0.1728	0.1728	0.1728	0.1728	120000.0
2004-06-14 09:00:00	NVDA	Stock	0.1724	0.1724	0.1709	0.1715	34920960.0
2004-06-14 10:00:00	NVDA	Stock	0.1716	0.1717	0.1703	0.1705	48288960.0
2004-06-14 11:00:00	NVDA	Stock	0.1704	0.1707	0.1687	0.1689	65910600.0
2004-06-14 12:00:00	NVDA	Stock	0.1689	0.1691	0.1678	0.168	54131880.0
2004-06-14 13:00:00	NVDA	Stock	0.168	0.1686	0.1666	0.1671	89254200.0
2004-06-14 14:00:00	NVDA	Stock	0.1671	0.1675	0.1666	0.1669	46076280.0
2004-06-14 15:00:00	NVDA	Stock	0.1669	0.1687	0.1667	0.1677	78963360.0
2004-06-14 16:00:00	NVDA	Stock	0.1677	0.1683	0.1675	0.1682	1460880.0
2004-06-14 17:00:00	NVDA	Stock	0.1687	0.1687	0.1678	0.1678	180000.0
2004-06-14 18:00:00	NVDA	Stock	0.1687	0.1687	0.1687	0.1687	12000.0
2004-06-14 08:00:00	AMZN	Stock	2.4875	2.4975	2.461	2.461	197720.0
2004-06-14 09:00:00	AMZN	Stock	2.4655	2.4995	2.464	2.4825	17057860.0
2004-06-14 10:00:00	AMZN	Stock	2.483	2.485	2.4575	2.471	23801280.0
2004-06-14 11:00:00	AMZN	Stock	2.4705	2.4715	2.4605	2.4625	11074860.0
2004-06-14 12:00:00	AMZN	Stock	2.4625	2.465	2.452	2.4605	10309200.0
2004-06-14 13:00:00	AMZN	Stock	2.4615	2.463	2.4545	2.458	6410520.0
2004-06-14 14:00:00	AMZN	Stock	2.459	2.467	2.4535	2.4615	10555720.0
2004-06-14 15:00:00	AMZN	Stock	2.4615	2.4645	2.459	2.4625	18162600.0
2004-06-14 16:00:00	AMZN	Stock	2.4615	2.4635	2.4605	2.463	1212460.0
2004-06-14 17:00:00	AMZN	Stock	2.464	2.464	2.463	2.463	239840.0
2004-06-14 18:00:00	AMZN	Stock	2.464	2.464	2.464	2.464	2000.0
2004-06-14 09:00:00	CL	Stock	29.5	29.5	28.89	29.06	247400.0
2004-06-14 10:00:00	CL	Stock	29.05	29.055	28.95	28.975	290800.0
2004-06-14 11:00:00	CL	Stock	28.97	29.005	28.935	28.95	187200.0
2004-06-14 12:00:00	CL	Stock	28.935	28.975	28.885	28.905	296800.0
2004-06-14 13:00:00	CL	Stock	28.91	29.0	28.905	28.97	126200.0
2004-06-14 14:00:00	CL	Stock	28.975	28.995	28.9	28.94	191800.0
2004-06-14 15:00:00	CL	Stock	28.935	29.045	28.905	29.025	592800.0

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

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