PREVIEW / stock_1hour / 2003-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-22.parquet
  size:    465 KB
  rows:    22,135
  symbols: 1,618

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-22 08:00:00	AAPL	Stock	0.4016	0.4016	0.3973	0.3973	100800.0
2003-09-22 09:00:00	AAPL	Stock	0.3973	0.4005	0.393	0.3939	21902944.0
2003-09-22 10:00:00	AAPL	Stock	0.3938	0.398	0.3927	0.3971	23620520.0
2003-09-22 11:00:00	AAPL	Stock	0.3971	0.4018	0.3968	0.3989	25204088.0
2003-09-22 12:00:00	AAPL	Stock	0.3988	0.3998	0.3971	0.3975	10271184.0
2003-09-22 13:00:00	AAPL	Stock	0.3977	0.3982	0.3952	0.3961	14207928.0
2003-09-22 14:00:00	AAPL	Stock	0.3963	0.3971	0.393	0.3938	19328120.0
2003-09-22 15:00:00	AAPL	Stock	0.3939	0.3954	0.3914	0.3938	32386200.0
2003-09-22 16:00:00	AAPL	Stock	0.393	0.395	0.3929	0.3943	2720088.0
2003-09-22 17:00:00	AAPL	Stock	0.3944	0.3945	0.3944	0.3945	812000.0
2003-09-22 08:00:00	MSFT	Stock	29.55	39.5	29.44	29.44	192430.0
2003-09-22 09:00:00	MSFT	Stock	29.48	29.55	29.26	29.28	12097523.0
2003-09-22 10:00:00	MSFT	Stock	29.27	29.39	29.11	29.3	9560193.0
2003-09-22 11:00:00	MSFT	Stock	29.29	29.37	29.23	29.27	6268532.0
2003-09-22 12:00:00	MSFT	Stock	29.28	29.28	29.16	29.24	5905923.0
2003-09-22 13:00:00	MSFT	Stock	29.24	29.27	29.11	29.14	3964862.0
2003-09-22 14:00:00	MSFT	Stock	29.14	29.15	28.98	29.03	8571993.0
2003-09-22 15:00:00	MSFT	Stock	29.02	29.1	28.81	29.08	11301004.0
2003-09-22 16:00:00	MSFT	Stock	29.07	29.1963	29.05	29.07	1539414.0
2003-09-22 17:00:00	MSFT	Stock	29.0685	29.17	29.0685	29.12	133900.0
2003-09-22 18:00:00	MSFT	Stock	29.1	29.14	29.07	29.12	26000.0
2003-09-22 08:00:00	NVDA	Stock	0.1646	0.1647	0.1615	0.1615	1935720.0
2003-09-22 09:00:00	NVDA	Stock	0.1615	0.1647	0.159	0.1593	126500760.0
2003-09-22 10:00:00	NVDA	Stock	0.1593	0.1601	0.1575	0.1596	178442160.0
2003-09-22 11:00:00	NVDA	Stock	0.1597	0.1599	0.1588	0.1592	82996680.0
2003-09-22 12:00:00	NVDA	Stock	0.1592	0.1593	0.1585	0.1589	53651880.0
2003-09-22 13:00:00	NVDA	Stock	0.1588	0.1594	0.1588	0.159	51407520.0
2003-09-22 14:00:00	NVDA	Stock	0.159	0.1592	0.1583	0.1587	57145920.0
2003-09-22 15:00:00	NVDA	Stock	0.1587	0.1594	0.1581	0.159	91741080.0
2003-09-22 16:00:00	NVDA	Stock	0.1585	0.159	0.1577	0.1588	22661280.0
2003-09-22 17:00:00	NVDA	Stock	0.1588	0.1588	0.1577	0.1583	1554000.0
2003-09-22 18:00:00	NVDA	Stock	0.1583	0.1588	0.1583	0.1587	144000.0
2003-09-22 08:00:00	AMZN	Stock	2.3817	2.3817	2.33	2.34	1387620.0
2003-09-22 09:00:00	AMZN	Stock	2.337	2.344	2.313	2.3225	29582260.0
2003-09-22 10:00:00	AMZN	Stock	2.3225	2.3745	2.3205	2.353	34591700.0
2003-09-22 11:00:00	AMZN	Stock	2.353	2.3645	2.3495	2.3525	18709440.0
2003-09-22 12:00:00	AMZN	Stock	2.3525	2.357	2.3405	2.3555	20030720.0
2003-09-22 13:00:00	AMZN	Stock	2.3565	2.3725	2.354	2.3655	15718540.0
2003-09-22 14:00:00	AMZN	Stock	2.366	2.3765	2.36	2.3645	23703060.0
2003-09-22 15:00:00	AMZN	Stock	2.3645	2.3735	2.3625	2.3735	21226340.0
2003-09-22 16:00:00	AMZN	Stock	2.3735	2.3765	2.3595	2.372	2015880.0
2003-09-22 17:00:00	AMZN	Stock	2.3719	2.372	2.3719	2.372	216000.0
2003-09-22 18:00:00	AMZN	Stock	2.3725	2.3745	2.372	2.3745	46000.0
2003-09-22 09:00:00	CL	Stock	27.625	27.625	27.375	27.375	177000.0
2003-09-22 10:00:00	CL	Stock	27.375	27.48	27.315	27.39	305600.0
2003-09-22 11:00:00	CL	Stock	27.395	27.45	27.34	27.395	212600.0
2003-09-22 12:00:00	CL	Stock	27.4	27.4	27.25	27.32	313400.0
2003-09-22 13:00:00	CL	Stock	27.33	27.565	27.32	27.485	285400.0
2003-09-22 14:00:00	CL	Stock	27.485	27.485	27.34	27.375	583000.0
2003-09-22 15:00:00	CL	Stock	27.38	27.455	27.355	27.415	470200.0

> showing 50 of 22,135 rows — these rows as CSV

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