PREVIEW / stock_1hour / 2003-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-19.parquet
  size:    484 KB
  rows:    23,083
  symbols: 1,610

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
2003-09-19 08:00:00	AAPL	Stock	0.4086	0.4086	0.4086	0.4086	5600.0
2003-09-19 09:00:00	AAPL	Stock	0.4107	0.4116	0.402	0.4029	50346688.0
2003-09-19 10:00:00	AAPL	Stock	0.4027	0.407	0.4011	0.4014	22842736.0
2003-09-19 11:00:00	AAPL	Stock	0.4014	0.405	0.4005	0.4043	16814168.0
2003-09-19 12:00:00	AAPL	Stock	0.4043	0.4063	0.4041	0.4055	8737680.0
2003-09-19 13:00:00	AAPL	Stock	0.4057	0.4057	0.4023	0.4025	7177744.0
2003-09-19 14:00:00	AAPL	Stock	0.4023	0.4036	0.4013	0.4036	14535360.0
2003-09-19 15:00:00	AAPL	Stock	0.4034	0.4048	0.4014	0.4041	35177184.0
2003-09-19 16:00:00	AAPL	Stock	0.403	0.4061	0.402	0.4023	4594296.0
2003-09-19 17:00:00	AAPL	Stock	0.4023	0.4032	0.4021	0.4021	1405600.0
2003-09-19 18:00:00	AAPL	Stock	0.4021	0.4021	0.4021	0.4021	5600.0
2003-09-19 08:00:00	MSFT	Stock	29.55	29.77	29.38	29.77	343664.0
2003-09-19 09:00:00	MSFT	Stock	29.75	29.86	29.52	29.64	16247026.0
2003-09-19 10:00:00	MSFT	Stock	29.64	29.71	29.58	29.67	10799900.0
2003-09-19 11:00:00	MSFT	Stock	29.68	29.8	29.63	29.73	6421352.0
2003-09-19 12:00:00	MSFT	Stock	29.74	29.75	29.63	29.64	4784050.0
2003-09-19 13:00:00	MSFT	Stock	29.64	29.65	29.53	29.59	5546053.0
2003-09-19 14:00:00	MSFT	Stock	29.59	29.8	29.54	29.789	7721026.0
2003-09-19 15:00:00	MSFT	Stock	29.787	29.97	29.72	29.94	16589070.0
2003-09-19 16:00:00	MSFT	Stock	29.96	29.99	29.657	29.91	5124118.0
2003-09-19 17:00:00	MSFT	Stock	29.945	29.945	29.891	29.92	94280.0
2003-09-19 18:00:00	MSFT	Stock	29.95	29.95	29.9	29.94	24600.0
2003-09-19 09:00:00	NVDA	Stock	0.1659	0.1697	0.1659	0.1666	114924000.0
2003-09-19 10:00:00	NVDA	Stock	0.1665	0.1682	0.1658	0.1659	89709000.0
2003-09-19 11:00:00	NVDA	Stock	0.166	0.1672	0.1658	0.167	39099120.0
2003-09-19 12:00:00	NVDA	Stock	0.1669	0.1671	0.1663	0.1663	26184840.0
2003-09-19 13:00:00	NVDA	Stock	0.1663	0.1666	0.1651	0.1654	33909960.0
2003-09-19 14:00:00	NVDA	Stock	0.1652	0.1654	0.1638	0.1649	110970840.0
2003-09-19 15:00:00	NVDA	Stock	0.1649	0.1662	0.1646	0.165	134063160.0
2003-09-19 16:00:00	NVDA	Stock	0.1648	0.1663	0.1637	0.1663	14521200.0
2003-09-19 17:00:00	NVDA	Stock	0.1643	0.1648	0.1641	0.1648	612000.0
2003-09-19 18:00:00	NVDA	Stock	0.1647	0.1648	0.1647	0.1648	173040.0
2003-09-19 08:00:00	AMZN	Stock	2.3945	2.3965	2.39	2.3965	230000.0
2003-09-19 09:00:00	AMZN	Stock	2.396	2.4	2.3755	2.3815	18585080.0
2003-09-19 10:00:00	AMZN	Stock	2.381	2.395	2.3712	2.377	18778780.0
2003-09-19 11:00:00	AMZN	Stock	2.3775	2.3795	2.371	2.3725	11540940.0
2003-09-19 12:00:00	AMZN	Stock	2.3725	2.377	2.3715	2.376	9210120.0
2003-09-19 13:00:00	AMZN	Stock	2.375	2.377	2.369	2.3695	12019400.0
2003-09-19 14:00:00	AMZN	Stock	2.3695	2.377	2.3675	2.3745	9048540.0
2003-09-19 15:00:00	AMZN	Stock	2.3745	2.382	2.3708	2.3795	20383780.0
2003-09-19 16:00:00	AMZN	Stock	2.381	2.3822	2.375	2.379	4562000.0
2003-09-19 17:00:00	AMZN	Stock	2.3815	2.3815	2.3815	2.3815	366000.0
2003-09-19 18:00:00	AMZN	Stock	2.376	2.376	2.376	2.376	12000.0
2003-09-19 09:00:00	CL	Stock	27.35	27.525	27.35	27.525	491000.0
2003-09-19 10:00:00	CL	Stock	27.525	27.66	27.4	27.52	661400.0
2003-09-19 11:00:00	CL	Stock	27.52	27.665	27.52	27.665	346000.0
2003-09-19 12:00:00	CL	Stock	27.655	27.68	27.58	27.58	250400.0
2003-09-19 13:00:00	CL	Stock	27.58	27.61	27.465	27.49	263000.0
2003-09-19 14:00:00	CL	Stock	27.485	27.53	27.445	27.525	249600.0
2003-09-19 15:00:00	CL	Stock	27.525	27.65	27.51	27.65	683200.0

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

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