PREVIEW / stock_1hour / 2004-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-15.parquet
  size:    501 KB
  rows:    23,389
  symbols: 1,793

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
2004-07-15 08:00:00	AAPL	Stock	0.5796	0.5839	0.5634	0.58	30805040.0
2004-07-15 09:00:00	AAPL	Stock	0.5804	0.6005	0.5768	0.5889	545464976.0
2004-07-15 10:00:00	AAPL	Stock	0.5889	0.5911	0.5804	0.5818	367784088.0
2004-07-15 11:00:00	AAPL	Stock	0.5818	0.5852	0.5734	0.5802	233601424.0
2004-07-15 12:00:00	AAPL	Stock	0.5802	0.5932	0.58	0.5888	154686504.0
2004-07-15 13:00:00	AAPL	Stock	0.5889	0.592	0.5877	0.5902	110400584.0
2004-07-15 14:00:00	AAPL	Stock	0.5902	0.5934	0.5877	0.5904	103282928.0
2004-07-15 15:00:00	AAPL	Stock	0.5904	0.5911	0.5855	0.5884	159442528.0
2004-07-15 16:00:00	AAPL	Stock	0.5877	0.5884	0.5852	0.5864	15798328.0
2004-07-15 17:00:00	AAPL	Stock	0.5883	0.5883	0.5834	0.585	642880.0
2004-07-15 18:00:00	AAPL	Stock	0.5855	0.5855	0.5836	0.5836	134400.0
2004-07-15 08:00:00	MSFT	Stock	28.15	28.16	28.12	28.15	19560.0
2004-07-15 09:00:00	MSFT	Stock	28.19	28.19	27.99	28.01	6109943.0
2004-07-15 10:00:00	MSFT	Stock	28.01	28.05	27.8	27.9	7059883.0
2004-07-15 11:00:00	MSFT	Stock	27.9	28.05	27.86	27.979	6399211.0
2004-07-15 12:00:00	MSFT	Stock	27.98	28.2037	27.97	28.12	6406648.0
2004-07-15 13:00:00	MSFT	Stock	28.12	28.2	28.01	28.05	3872193.0
2004-07-15 14:00:00	MSFT	Stock	28.05	28.15	27.99	28.09	6031262.0
2004-07-15 15:00:00	MSFT	Stock	28.08	28.11	27.85	27.87	8674158.0
2004-07-15 16:00:00	MSFT	Stock	27.88	28.0189	27.67	27.86	595740.0
2004-07-15 17:00:00	MSFT	Stock	27.89	27.89	27.79	27.87	32712.0
2004-07-15 18:00:00	MSFT	Stock	27.89	27.89	27.89	27.89	400.0
2004-07-15 08:00:00	NVDA	Stock	0.1333	0.1333	0.1333	0.1333	48000.0
2004-07-15 09:00:00	NVDA	Stock	0.1333	0.134	0.1317	0.1325	64572840.0
2004-07-15 10:00:00	NVDA	Stock	0.1324	0.1331	0.131	0.1316	76324560.0
2004-07-15 11:00:00	NVDA	Stock	0.1317	0.132	0.13	0.1311	80964360.0
2004-07-15 12:00:00	NVDA	Stock	0.1312	0.1329	0.131	0.1327	94550520.0
2004-07-15 13:00:00	NVDA	Stock	0.1327	0.1327	0.1313	0.1319	53554320.0
2004-07-15 14:00:00	NVDA	Stock	0.1318	0.1322	0.1314	0.132	67707600.0
2004-07-15 15:00:00	NVDA	Stock	0.1318	0.1321	0.1295	0.1301	143202120.0
2004-07-15 16:00:00	NVDA	Stock	0.13	0.1303	0.1283	0.1283	24044040.0
2004-07-15 17:00:00	NVDA	Stock	0.1292	0.1292	0.1292	0.1292	732000.0
2004-07-15 18:00:00	NVDA	Stock	0.1292	0.1292	0.1292	0.1292	12000.0
2004-07-15 08:00:00	AMZN	Stock	2.45	2.4775	2.45	2.475	139200.0
2004-07-15 09:00:00	AMZN	Stock	2.48	2.4835	2.4265	2.434	18901760.0
2004-07-15 10:00:00	AMZN	Stock	2.434	2.442	2.406	2.42	25502540.0
2004-07-15 11:00:00	AMZN	Stock	2.42	2.422	2.408	2.4185	11163880.0
2004-07-15 12:00:00	AMZN	Stock	2.419	2.4425	2.4185	2.4325	11793500.0
2004-07-15 13:00:00	AMZN	Stock	2.4305	2.434	2.42	2.4275	10045760.0
2004-07-15 14:00:00	AMZN	Stock	2.426	2.4325	2.4195	2.4305	7161280.0
2004-07-15 15:00:00	AMZN	Stock	2.4315	2.4335	2.4215	2.4315	16703060.0
2004-07-15 16:00:00	AMZN	Stock	2.431	2.435	2.387	2.421	1507820.0
2004-07-15 17:00:00	AMZN	Stock	2.4305	2.4305	2.4195	2.4205	209980.0
2004-07-15 18:00:00	AMZN	Stock	2.422	2.422	2.42	2.42	36000.0
2004-07-15 09:00:00	CL	Stock	28.445	28.45	28.33	28.365	174200.0
2004-07-15 10:00:00	CL	Stock	28.355	28.375	28.26	28.335	447000.0
2004-07-15 11:00:00	CL	Stock	28.335	28.455	28.285	28.33	378200.0
2004-07-15 12:00:00	CL	Stock	28.31	28.435	28.28	28.375	471600.0
2004-07-15 13:00:00	CL	Stock	28.375	28.44	28.355	28.41	270000.0
2004-07-15 14:00:00	CL	Stock	28.405	28.48	28.36	28.45	283800.0

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

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