PREVIEW / stock_1hour / 2003-09-02

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-02.parquet
  size:    503 KB
  rows:    23,118
  symbols: 1,619

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-02 08:00:00	AAPL	Stock	0.4045	0.4046	0.4045	0.4045	84896.0
2003-09-02 09:00:00	AAPL	Stock	0.4043	0.4054	0.4027	0.4048	29431864.0
2003-09-02 10:00:00	AAPL	Stock	0.4048	0.4061	0.4018	0.4027	34417208.0
2003-09-02 11:00:00	AAPL	Stock	0.4029	0.4038	0.4	0.4013	28289632.0
2003-09-02 12:00:00	AAPL	Stock	0.4013	0.4054	0.4013	0.4043	14514472.0
2003-09-02 13:00:00	AAPL	Stock	0.4045	0.4048	0.4018	0.4023	14594888.0
2003-09-02 14:00:00	AAPL	Stock	0.4021	0.4064	0.4021	0.4055	28986832.0
2003-09-02 15:00:00	AAPL	Stock	0.4055	0.4089	0.4052	0.408	63817208.0
2003-09-02 16:00:00	AAPL	Stock	0.4079	0.4088	0.4073	0.4088	1993544.0
2003-09-02 17:00:00	AAPL	Stock	0.4046	0.4081	0.4046	0.4081	4541600.0
2003-09-02 08:00:00	MSFT	Stock	26.74	26.85	26.52	26.79	195820.0
2003-09-02 09:00:00	MSFT	Stock	26.78	26.87	26.65	26.76	10010994.0
2003-09-02 10:00:00	MSFT	Stock	26.77	26.79	26.47	26.71	10548065.0
2003-09-02 11:00:00	MSFT	Stock	26.711	26.8	26.68	26.7	6558512.0
2003-09-02 12:00:00	MSFT	Stock	26.7	26.84	26.695	26.76	4877896.0
2003-09-02 13:00:00	MSFT	Stock	26.76	26.82	26.73	26.76	3963259.0
2003-09-02 14:00:00	MSFT	Stock	26.76	27.016	26.75	26.99	9071541.0
2003-09-02 15:00:00	MSFT	Stock	26.986	27.28	26.97	27.25	20006788.0
2003-09-02 16:00:00	MSFT	Stock	27.25	27.28	26.74	27.28	1921586.0
2003-09-02 17:00:00	MSFT	Stock	27.23	27.25	26.8882	27.22	649300.0
2003-09-02 18:00:00	MSFT	Stock	26.8942	27.26	26.8942	27.22	112000.0
2003-09-02 08:00:00	NVDA	Stock	0.1504	0.1542	0.1421	0.1541	3684000.0
2003-09-02 09:00:00	NVDA	Stock	0.1537	0.1554	0.1503	0.1516	133711560.0
2003-09-02 10:00:00	NVDA	Stock	0.1517	0.1522	0.1493	0.1508	129279840.0
2003-09-02 11:00:00	NVDA	Stock	0.1508	0.151	0.15	0.15	54534960.0
2003-09-02 12:00:00	NVDA	Stock	0.15	0.1512	0.1498	0.1504	61317000.0
2003-09-02 13:00:00	NVDA	Stock	0.1504	0.1504	0.1493	0.1496	44562960.0
2003-09-02 14:00:00	NVDA	Stock	0.1496	0.1508	0.1495	0.1507	65718000.0
2003-09-02 15:00:00	NVDA	Stock	0.1507	0.1512	0.1497	0.15	147809400.0
2003-09-02 16:00:00	NVDA	Stock	0.1502	0.1504	0.1497	0.1498	10872840.0
2003-09-02 17:00:00	NVDA	Stock	0.1498	0.1503	0.1498	0.1501	3816000.0
2003-09-02 18:00:00	NVDA	Stock	0.1509	0.1509	0.1503	0.1503	1740000.0
2003-09-02 08:00:00	AMZN	Stock	2.325	2.33	2.3225	2.33	118000.0
2003-09-02 09:00:00	AMZN	Stock	2.3285	2.3438	2.316	2.3255	22405060.0
2003-09-02 10:00:00	AMZN	Stock	2.325	2.332	2.3005	2.3165	20490820.0
2003-09-02 11:00:00	AMZN	Stock	2.3165	2.34	2.316	2.3325	22587760.0
2003-09-02 12:00:00	AMZN	Stock	2.3325	2.364	2.3305	2.3525	29685580.0
2003-09-02 13:00:00	AMZN	Stock	2.3525	2.3725	2.35	2.3625	18303880.0
2003-09-02 14:00:00	AMZN	Stock	2.362	2.3715	2.362	2.3694	22155700.0
2003-09-02 15:00:00	AMZN	Stock	2.3694	2.3725	2.3575	2.37	32583860.0
2003-09-02 16:00:00	AMZN	Stock	2.3695	2.3725	2.3605	2.3675	2641520.0
2003-09-02 17:00:00	AMZN	Stock	2.368	2.37	2.3675	2.3695	506000.0
2003-09-02 18:00:00	AMZN	Stock	2.3695	2.371	2.3695	2.371	48000.0
2003-09-02 08:00:00	CL	Stock	27.625	27.625	27.625	27.625	200.0
2003-09-02 09:00:00	CL	Stock	27.75	27.825	27.7025	27.815	263000.0
2003-09-02 10:00:00	CL	Stock	27.795	27.845	27.675	27.75	404000.0
2003-09-02 11:00:00	CL	Stock	27.75	27.9	27.75	27.785	239600.0
2003-09-02 12:00:00	CL	Stock	27.79	28.075	27.785	27.91	327200.0
2003-09-02 13:00:00	CL	Stock	27.92	28.015	27.89	27.92	212800.0
2003-09-02 14:00:00	CL	Stock	27.93	28.135	27.93	28.07	417800.0

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

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