PREVIEW / stock_1hour / 2004-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-28.parquet
  size:    507 KB
  rows:    23,654
  symbols: 1,713

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-01-28 08:00:00	AAPL	Stock	0.412	0.412	0.412	0.412	78400.0
2004-01-28 09:00:00	AAPL	Stock	0.4114	0.4146	0.4079	0.4118	19301072.0
2004-01-28 10:00:00	AAPL	Stock	0.4116	0.4146	0.4095	0.4111	23577120.0
2004-01-28 11:00:00	AAPL	Stock	0.4111	0.4175	0.4109	0.4159	54954928.0
2004-01-28 12:00:00	AAPL	Stock	0.4159	0.4164	0.4134	0.4148	18174408.0
2004-01-28 13:00:00	AAPL	Stock	0.4148	0.415	0.4134	0.4139	12058648.0
2004-01-28 14:00:00	AAPL	Stock	0.4139	0.4145	0.4041	0.4073	59109400.0
2004-01-28 15:00:00	AAPL	Stock	0.407	0.4095	0.4005	0.4005	76028120.0
2004-01-28 16:00:00	AAPL	Stock	0.4004	0.4048	0.4002	0.4036	1318240.0
2004-01-28 17:00:00	AAPL	Stock	0.4036	0.4036	0.4007	0.4036	1120560.0
2004-01-28 08:00:00	MSFT	Stock	28.35	28.4	28.29	28.3	44695.0
2004-01-28 09:00:00	MSFT	Stock	28.3	28.44	28.24	28.39	5429301.0
2004-01-28 10:00:00	MSFT	Stock	28.38	28.4	28.25	28.26	8045776.0
2004-01-28 11:00:00	MSFT	Stock	28.26	28.26	28.06	28.09	8692479.0
2004-01-28 12:00:00	MSFT	Stock	28.09	28.11	28.02	28.069	6233003.0
2004-01-28 13:00:00	MSFT	Stock	28.05	28.101	28.0	28.001	5384229.0
2004-01-28 14:00:00	MSFT	Stock	28.0	28.15	27.81	27.9	17527466.0
2004-01-28 15:00:00	MSFT	Stock	27.9	27.96	27.47	27.7	16698936.0
2004-01-28 16:00:00	MSFT	Stock	27.7	27.76	27.6	27.63	1164062.0
2004-01-28 17:00:00	MSFT	Stock	27.63	27.71	27.6	27.69	181182.0
2004-01-28 18:00:00	MSFT	Stock	27.69	27.7	27.66	27.7	11990.0
2004-01-28 08:00:00	NVDA	Stock	0.1883	0.1899	0.1883	0.1892	828000.0
2004-01-28 09:00:00	NVDA	Stock	0.1905	0.1932	0.1888	0.1912	93029520.0
2004-01-28 10:00:00	NVDA	Stock	0.1912	0.1929	0.1908	0.1919	89065680.0
2004-01-28 11:00:00	NVDA	Stock	0.192	0.193	0.1918	0.1929	75062520.0
2004-01-28 12:00:00	NVDA	Stock	0.1929	0.1932	0.1921	0.1931	34941480.0
2004-01-28 13:00:00	NVDA	Stock	0.1931	0.1933	0.1922	0.1932	41076600.0
2004-01-28 14:00:00	NVDA	Stock	0.193	0.194	0.1896	0.1917	143753520.0
2004-01-28 15:00:00	NVDA	Stock	0.1917	0.1918	0.1871	0.1886	103559040.0
2004-01-28 16:00:00	NVDA	Stock	0.1876	0.1922	0.1873	0.1883	10691640.0
2004-01-28 17:00:00	NVDA	Stock	0.1883	0.1883	0.1876	0.1876	1054560.0
2004-01-28 18:00:00	NVDA	Stock	0.1885	0.1885	0.1885	0.1885	48000.0
2004-01-28 08:00:00	AMZN	Stock	2.694	2.775	2.6555	2.675	4790100.0
2004-01-28 09:00:00	AMZN	Stock	2.675	2.7225	2.6625	2.674	83996760.0
2004-01-28 10:00:00	AMZN	Stock	2.674	2.7125	2.6453	2.7065	71959980.0
2004-01-28 11:00:00	AMZN	Stock	2.708	2.71	2.6505	2.656	36210280.0
2004-01-28 12:00:00	AMZN	Stock	2.6545	2.665	2.622	2.6325	47955980.0
2004-01-28 13:00:00	AMZN	Stock	2.6325	2.6509	2.6265	2.642	29555280.0
2004-01-28 14:00:00	AMZN	Stock	2.642	2.65	2.606	2.617	62575520.0
2004-01-28 15:00:00	AMZN	Stock	2.6179	2.6179	2.581	2.598	70264680.0
2004-01-28 16:00:00	AMZN	Stock	2.5985	2.6075	2.5905	2.595	7503920.0
2004-01-28 17:00:00	AMZN	Stock	2.595	2.5985	2.593	2.5965	404720.0
2004-01-28 18:00:00	AMZN	Stock	2.5965	2.5965	2.591	2.594	40000.0
2004-01-28 09:00:00	CL	Stock	25.525	25.535	25.475	25.5	624800.0
2004-01-28 10:00:00	CL	Stock	25.505	25.505	25.395	25.475	1256600.0
2004-01-28 11:00:00	CL	Stock	25.475	25.545	25.455	25.505	847600.0
2004-01-28 12:00:00	CL	Stock	25.515	25.525	25.49	25.515	440200.0
2004-01-28 13:00:00	CL	Stock	25.51	25.6	25.5	25.595	480600.0
2004-01-28 14:00:00	CL	Stock	25.6	25.6	25.425	25.505	1664600.0
2004-01-28 15:00:00	CL	Stock	25.505	25.525	25.4	25.415	1998400.0

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

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