PREVIEW / stock_1hour / 2004-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-21.parquet
  size:    514 KB
  rows:    24,570
  symbols: 1,786

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-21 08:00:00	AAPL	Stock	0.5893	0.5964	0.5879	0.5879	1125600.0
2004-06-21 09:00:00	AAPL	Stock	0.592	0.5982	0.5852	0.5891	82218976.0
2004-06-21 10:00:00	AAPL	Stock	0.5891	0.5907	0.5875	0.5898	46012960.0
2004-06-21 11:00:00	AAPL	Stock	0.5898	0.59	0.5859	0.5866	35594776.0
2004-06-21 12:00:00	AAPL	Stock	0.5866	0.5875	0.5838	0.5839	21343448.0
2004-06-21 13:00:00	AAPL	Stock	0.5839	0.5839	0.5804	0.5809	47109216.0
2004-06-21 14:00:00	AAPL	Stock	0.5811	0.5839	0.5802	0.5816	51607696.0
2004-06-21 15:00:00	AAPL	Stock	0.5816	0.5825	0.5736	0.5759	84937944.0
2004-06-21 16:00:00	AAPL	Stock	0.5754	0.5775	0.5732	0.5773	14508088.0
2004-06-21 17:00:00	AAPL	Stock	0.5759	0.5773	0.5759	0.5773	728000.0
2004-06-21 08:00:00	MSFT	Stock	28.4	28.43	28.25	28.35	146444.0
2004-06-21 09:00:00	MSFT	Stock	28.35	28.41	28.12	28.29	10362458.0
2004-06-21 10:00:00	MSFT	Stock	28.28	28.48	28.28	28.4	20586319.0
2004-06-21 11:00:00	MSFT	Stock	28.4	28.5	28.35	28.47	11649789.0
2004-06-21 12:00:00	MSFT	Stock	28.46	28.51	28.44	28.49	11577442.0
2004-06-21 13:00:00	MSFT	Stock	28.499	28.61	28.47	28.61	13894703.0
2004-06-21 14:00:00	MSFT	Stock	28.6	28.66	28.52	28.581	15678158.0
2004-06-21 15:00:00	MSFT	Stock	28.59	28.62	28.21	28.34	24664006.0
2004-06-21 16:00:00	MSFT	Stock	28.34	28.4269	28.3	28.34	5902094.0
2004-06-21 17:00:00	MSFT	Stock	28.34	28.35	28.33	28.33	258144.0
2004-06-21 18:00:00	MSFT	Stock	28.34	28.36	28.33	28.36	1669.0
2004-06-21 09:00:00	NVDA	Stock	0.1666	0.1675	0.1644	0.1665	34743960.0
2004-06-21 10:00:00	NVDA	Stock	0.1665	0.1671	0.1649	0.1652	32918520.0
2004-06-21 11:00:00	NVDA	Stock	0.1652	0.1652	0.1643	0.1645	35748600.0
2004-06-21 12:00:00	NVDA	Stock	0.1646	0.165	0.1642	0.1642	20720400.0
2004-06-21 13:00:00	NVDA	Stock	0.1642	0.1655	0.1637	0.1651	15660480.0
2004-06-21 14:00:00	NVDA	Stock	0.1651	0.1653	0.1636	0.1636	26833440.0
2004-06-21 15:00:00	NVDA	Stock	0.1636	0.1642	0.1607	0.1618	96434160.0
2004-06-21 16:00:00	NVDA	Stock	0.1618	0.1624	0.1617	0.1621	1693440.0
2004-06-21 17:00:00	NVDA	Stock	0.1617	0.1617	0.1617	0.1617	468000.0
2004-06-21 18:00:00	NVDA	Stock	0.1616	0.1616	0.1616	0.1616	180000.0
2004-06-21 08:00:00	AMZN	Stock	2.49	2.4905	2.4805	2.4805	228000.0
2004-06-21 09:00:00	AMZN	Stock	2.49	2.5	2.4625	2.4985	13617420.0
2004-06-21 10:00:00	AMZN	Stock	2.4995	2.507	2.496	2.501	14174660.0
2004-06-21 11:00:00	AMZN	Stock	2.501	2.5095	2.498	2.5075	8462080.0
2004-06-21 12:00:00	AMZN	Stock	2.508	2.515	2.505	2.5075	9156920.0
2004-06-21 13:00:00	AMZN	Stock	2.507	2.5115	2.4985	2.5075	7048740.0
2004-06-21 14:00:00	AMZN	Stock	2.5075	2.5095	2.49	2.491	10345380.0
2004-06-21 15:00:00	AMZN	Stock	2.491	2.4945	2.4755	2.486	23080620.0
2004-06-21 16:00:00	AMZN	Stock	2.4885	2.496	2.487	2.496	994980.0
2004-06-21 17:00:00	AMZN	Stock	2.4885	2.4885	2.4885	2.4885	76120.0
2004-06-21 09:00:00	CL	Stock	29.1	29.215	29.1	29.2	194600.0
2004-06-21 10:00:00	CL	Stock	29.195	29.25	29.18	29.205	213800.0
2004-06-21 11:00:00	CL	Stock	29.21	29.22	29.125	29.16	174000.0
2004-06-21 12:00:00	CL	Stock	29.16	29.165	29.115	29.125	120000.0
2004-06-21 13:00:00	CL	Stock	29.125	29.145	29.1	29.115	155800.0
2004-06-21 14:00:00	CL	Stock	29.115	29.16	29.095	29.115	170800.0
2004-06-21 15:00:00	CL	Stock	29.12	29.16	29.075	29.14	688600.0
2004-06-21 16:00:00	CL	Stock	29.16	29.16	29.16	29.16	200.0
2004-06-21 17:00:00	CL	Stock	29.14	29.14	29.14	29.14	25400.0

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

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