PREVIEW / stock_1hour / 2003-09-04

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-04.parquet
  size:    469 KB
  rows:    22,068
  symbols: 1,617

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-04 08:00:00	AAPL	Stock	0.4125	0.4125	0.4125	0.4125	28000.0
2003-09-04 09:00:00	AAPL	Stock	0.4098	0.4152	0.4085	0.4123	37577400.0
2003-09-04 10:00:00	AAPL	Stock	0.4125	0.4152	0.4066	0.4075	23920344.0
2003-09-04 11:00:00	AAPL	Stock	0.4075	0.4107	0.4071	0.4079	23949128.0
2003-09-04 12:00:00	AAPL	Stock	0.4079	0.4111	0.4075	0.4096	20519912.0
2003-09-04 13:00:00	AAPL	Stock	0.4096	0.4114	0.4088	0.4111	13555920.0
2003-09-04 14:00:00	AAPL	Stock	0.4113	0.4116	0.4093	0.4102	14065744.0
2003-09-04 15:00:00	AAPL	Stock	0.4104	0.4111	0.408	0.408	37809800.0
2003-09-04 16:00:00	AAPL	Stock	0.4082	0.4091	0.4039	0.408	6783224.0
2003-09-04 17:00:00	AAPL	Stock	0.4077	0.408	0.4077	0.408	8232000.0
2003-09-04 18:00:00	AAPL	Stock	0.408	0.408	0.408	0.408	11200.0
2003-09-04 08:00:00	MSFT	Stock	28.29	28.32	28.05	28.2	91494.0
2003-09-04 09:00:00	MSFT	Stock	28.2	28.3	28.03	28.3	7796109.0
2003-09-04 10:00:00	MSFT	Stock	28.3	28.4	28.24	28.27	9536659.0
2003-09-04 11:00:00	MSFT	Stock	28.27	28.43	28.259	28.35	7028989.0
2003-09-04 12:00:00	MSFT	Stock	28.355	28.45	28.33	28.41	5293537.0
2003-09-04 13:00:00	MSFT	Stock	28.41	28.43	28.37	28.4	4214265.0
2003-09-04 14:00:00	MSFT	Stock	28.41	28.42	28.29	28.32	5619924.0
2003-09-04 15:00:00	MSFT	Stock	28.32	28.44	28.3	28.42	9986459.0
2003-09-04 16:00:00	MSFT	Stock	28.43	28.69	28.31	28.67	3514800.0
2003-09-04 17:00:00	MSFT	Stock	28.67	28.79	28.2008	28.76	513676.0
2003-09-04 18:00:00	MSFT	Stock	28.75	28.75	28.71	28.71	3532.0
2003-09-04 08:00:00	NVDA	Stock	0.1483	0.1483	0.1475	0.1475	349800.0
2003-09-04 09:00:00	NVDA	Stock	0.1479	0.1504	0.1467	0.1482	98519400.0
2003-09-04 10:00:00	NVDA	Stock	0.1482	0.1488	0.1481	0.1481	112900800.0
2003-09-04 11:00:00	NVDA	Stock	0.148	0.1494	0.1476	0.1488	57265440.0
2003-09-04 12:00:00	NVDA	Stock	0.1487	0.1518	0.1487	0.1512	65986320.0
2003-09-04 13:00:00	NVDA	Stock	0.1512	0.1514	0.15	0.1512	58499880.0
2003-09-04 14:00:00	NVDA	Stock	0.1512	0.1521	0.1502	0.1502	120283800.0
2003-09-04 15:00:00	NVDA	Stock	0.1502	0.1505	0.1483	0.1485	121216200.0
2003-09-04 16:00:00	NVDA	Stock	0.1484	0.1506	0.1484	0.1502	17867160.0
2003-09-04 17:00:00	NVDA	Stock	0.1501	0.1506	0.1486	0.1506	6330600.0
2003-09-04 18:00:00	NVDA	Stock	0.1506	0.1506	0.1504	0.1504	269400.0
2003-09-04 08:00:00	AMZN	Stock	2.3095	2.3095	2.3095	2.3095	22000.0
2003-09-04 09:00:00	AMZN	Stock	2.305	2.32	2.302	2.3125	26122420.0
2003-09-04 10:00:00	AMZN	Stock	2.3125	2.324	2.3045	2.317	33250260.0
2003-09-04 11:00:00	AMZN	Stock	2.3165	2.3615	2.3125	2.3465	37689340.0
2003-09-04 12:00:00	AMZN	Stock	2.3465	2.3625	2.345	2.3565	18955800.0
2003-09-04 13:00:00	AMZN	Stock	2.3565	2.3675	2.3525	2.3625	11416160.0
2003-09-04 14:00:00	AMZN	Stock	2.3665	2.3695	2.356	2.359	14267200.0
2003-09-04 15:00:00	AMZN	Stock	2.359	2.368	2.3575	2.3655	24548380.0
2003-09-04 16:00:00	AMZN	Stock	2.365	2.3745	2.3635	2.3735	1189380.0
2003-09-04 17:00:00	AMZN	Stock	2.3725	2.374	2.3148	2.3725	159140.0
2003-09-04 18:00:00	AMZN	Stock	2.371	2.374	2.371	2.374	38100.0
2003-09-04 09:00:00	CL	Stock	28.28	28.5	28.28	28.45	210400.0
2003-09-04 10:00:00	CL	Stock	28.445	28.55	28.21	28.245	469800.0
2003-09-04 11:00:00	CL	Stock	28.255	28.255	28.14	28.15	191200.0
2003-09-04 12:00:00	CL	Stock	28.155	28.275	28.155	28.235	211000.0
2003-09-04 13:00:00	CL	Stock	28.235	28.37	28.195	28.365	218000.0
2003-09-04 14:00:00	CL	Stock	28.36	28.36	28.175	28.2005	317600.0

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

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