PREVIEW / stock_1hour / 2003-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-16.parquet
  size:    475 KB
  rows:    22,207
  symbols: 1,624

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-16 09:00:00	AAPL	Stock	0.4009	0.402	0.3964	0.4013	14611408.0
2003-09-16 10:00:00	AAPL	Stock	0.4013	0.4053	0.3991	0.4003	43296960.0
2003-09-16 11:00:00	AAPL	Stock	0.4004	0.4018	0.3991	0.4002	32760728.0
2003-09-16 12:00:00	AAPL	Stock	0.4004	0.4021	0.3989	0.3998	25041184.0
2003-09-16 13:00:00	AAPL	Stock	0.3998	0.4012	0.3984	0.3984	14781144.0
2003-09-16 14:00:00	AAPL	Stock	0.3986	0.4027	0.397	0.4013	45013528.0
2003-09-16 15:00:00	AAPL	Stock	0.4013	0.4027	0.3982	0.4014	57305416.0
2003-09-16 16:00:00	AAPL	Stock	0.4018	0.4023	0.3979	0.3993	3994424.0
2003-09-16 17:00:00	AAPL	Stock	0.3991	0.4018	0.3991	0.4018	369600.0
2003-09-16 18:00:00	AAPL	Stock	0.4009	0.4009	0.4009	0.4009	11200.0
2003-09-16 08:00:00	MSFT	Stock	28.36	28.5	26.5	28.44	54759.0
2003-09-16 09:00:00	MSFT	Stock	28.44	28.6	28.32	28.59	5901562.0
2003-09-16 10:00:00	MSFT	Stock	28.6	28.61	28.48	28.5	6034541.0
2003-09-16 11:00:00	MSFT	Stock	28.49	28.53	28.4	28.48	4883579.0
2003-09-16 12:00:00	MSFT	Stock	28.47	28.52	28.41	28.46	2892022.0
2003-09-16 13:00:00	MSFT	Stock	28.47	28.532	28.42	28.46	2446289.0
2003-09-16 14:00:00	MSFT	Stock	28.46	28.7	28.41	28.64	8568319.0
2003-09-16 15:00:00	MSFT	Stock	28.65	28.95	28.57	28.92	13418964.0
2003-09-16 16:00:00	MSFT	Stock	28.93	29.4	28.55	28.95	922681.0
2003-09-16 17:00:00	MSFT	Stock	28.93	28.94	28.62	28.79	304600.0
2003-09-16 18:00:00	MSFT	Stock	28.73	28.8	28.73	28.73	5600.0
2003-09-16 08:00:00	NVDA	Stock	0.1592	0.1592	0.1592	0.1592	12000.0
2003-09-16 09:00:00	NVDA	Stock	0.1592	0.1608	0.1588	0.1607	74124480.0
2003-09-16 10:00:00	NVDA	Stock	0.1607	0.1623	0.1599	0.1614	126807600.0
2003-09-16 11:00:00	NVDA	Stock	0.1613	0.1619	0.1611	0.1618	36364800.0
2003-09-16 12:00:00	NVDA	Stock	0.1618	0.1623	0.1613	0.1621	37418520.0
2003-09-16 13:00:00	NVDA	Stock	0.1621	0.1628	0.1612	0.1616	61295880.0
2003-09-16 14:00:00	NVDA	Stock	0.1616	0.1628	0.1608	0.1624	89250840.0
2003-09-16 15:00:00	NVDA	Stock	0.1624	0.164	0.1622	0.1639	128673360.0
2003-09-16 16:00:00	NVDA	Stock	0.1637	0.1641	0.1633	0.1639	13807200.0
2003-09-16 17:00:00	NVDA	Stock	0.1637	0.1643	0.1617	0.1643	1524000.0
2003-09-16 18:00:00	NVDA	Stock	0.1642	0.1645	0.1642	0.1645	468000.0
2003-09-16 08:00:00	AMZN	Stock	2.25	2.275	2.25	2.275	56000.0
2003-09-16 09:00:00	AMZN	Stock	2.2745	2.2775	2.2555	2.2705	16099900.0
2003-09-16 10:00:00	AMZN	Stock	2.2705	2.272	2.2525	2.268	21732040.0
2003-09-16 11:00:00	AMZN	Stock	2.2675	2.284	2.2635	2.2825	16645640.0
2003-09-16 12:00:00	AMZN	Stock	2.283	2.286	2.278	2.2785	7696200.0
2003-09-16 13:00:00	AMZN	Stock	2.279	2.2825	2.27	2.2705	9663000.0
2003-09-16 14:00:00	AMZN	Stock	2.2705	2.2875	2.2605	2.283	19823000.0
2003-09-16 15:00:00	AMZN	Stock	2.284	2.3105	2.2765	2.3095	39556340.0
2003-09-16 16:00:00	AMZN	Stock	2.3105	2.322	2.306	2.32	1352000.0
2003-09-16 17:00:00	AMZN	Stock	2.32	2.32	2.3122	2.3175	98000.0
2003-09-16 18:00:00	AMZN	Stock	2.3125	2.3125	2.3125	2.3125	216000.0
2003-09-16 09:00:00	CL	Stock	27.675	27.7	27.575	27.6	291200.0
2003-09-16 10:00:00	CL	Stock	27.61	27.655	27.5	27.51	466400.0
2003-09-16 11:00:00	CL	Stock	27.52	27.585	27.51	27.57	356000.0
2003-09-16 12:00:00	CL	Stock	27.56	27.64	27.56	27.625	385400.0
2003-09-16 13:00:00	CL	Stock	27.625	27.675	27.62	27.66	297400.0
2003-09-16 14:00:00	CL	Stock	27.655	27.75	27.58	27.745	352400.0
2003-09-16 15:00:00	CL	Stock	27.74	27.88	27.725	27.8	695400.0

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

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