PREVIEW / stock_1hour / 2004-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-21.parquet
  size:    522 KB
  rows:    24,974
  symbols: 1,805

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-21 08:00:00	AAPL	Stock	0.5782	0.5804	0.5782	0.5786	392000.0
2004-07-21 09:00:00	AAPL	Stock	0.5795	0.5841	0.575	0.5805	45916920.0
2004-07-21 10:00:00	AAPL	Stock	0.5804	0.5836	0.5741	0.5746	40584656.0
2004-07-21 11:00:00	AAPL	Stock	0.5745	0.5766	0.5714	0.5732	21594608.0
2004-07-21 12:00:00	AAPL	Stock	0.5732	0.5757	0.5714	0.575	18726960.0
2004-07-21 13:00:00	AAPL	Stock	0.5748	0.575	0.5696	0.5723	20336344.0
2004-07-21 14:00:00	AAPL	Stock	0.5721	0.5732	0.5679	0.5682	46587912.0
2004-07-21 15:00:00	AAPL	Stock	0.568	0.5684	0.5596	0.5648	83095600.0
2004-07-21 16:00:00	AAPL	Stock	0.565	0.5664	0.5598	0.5602	6984544.0
2004-07-21 17:00:00	AAPL	Stock	0.5611	0.5646	0.5611	0.5625	2095296.0
2004-07-21 08:00:00	MSFT	Stock	29.78	30.65	29.25	29.4	3661298.0
2004-07-21 09:00:00	MSFT	Stock	29.42	30.75	29.02	29.13	43761406.0
2004-07-21 10:00:00	MSFT	Stock	29.13	29.29	29.04	29.26	30795406.0
2004-07-21 11:00:00	MSFT	Stock	29.25	29.37	29.16	29.3	20667406.0
2004-07-21 12:00:00	MSFT	Stock	29.3	29.32	29.15	29.18	15748529.0
2004-07-21 13:00:00	MSFT	Stock	29.19	29.2	28.86	28.94	24025620.0
2004-07-21 14:00:00	MSFT	Stock	28.94	29.12	28.87	29.03	18844510.0
2004-07-21 15:00:00	MSFT	Stock	29.03	29.05	28.82	28.86	25389468.0
2004-07-21 16:00:00	MSFT	Stock	28.86	28.96	28.76	28.8	13928324.0
2004-07-21 17:00:00	MSFT	Stock	28.8	28.86	28.75	28.83	268753.0
2004-07-21 18:00:00	MSFT	Stock	28.83	28.89	28.83	28.87	33031.0
2004-07-21 08:00:00	NVDA	Stock	0.1329	0.1329	0.1311	0.1317	747000.0
2004-07-21 09:00:00	NVDA	Stock	0.1317	0.1327	0.131	0.1316	55667040.0
2004-07-21 10:00:00	NVDA	Stock	0.1317	0.1327	0.1294	0.1296	72155160.0
2004-07-21 11:00:00	NVDA	Stock	0.1295	0.1297	0.1246	0.125	164806440.0
2004-07-21 12:00:00	NVDA	Stock	0.1248	0.1262	0.1234	0.1256	78142920.0
2004-07-21 13:00:00	NVDA	Stock	0.1256	0.1257	0.1242	0.1247	52695000.0
2004-07-21 14:00:00	NVDA	Stock	0.1247	0.1252	0.124	0.1241	43596960.0
2004-07-21 15:00:00	NVDA	Stock	0.1241	0.1241	0.1222	0.123	114659640.0
2004-07-21 16:00:00	NVDA	Stock	0.123	0.1231	0.1208	0.1212	3402000.0
2004-07-21 17:00:00	NVDA	Stock	0.1213	0.1226	0.1213	0.1226	408000.0
2004-07-21 08:00:00	AMZN	Stock	2.382	2.382	2.355	2.3695	184000.0
2004-07-21 09:00:00	AMZN	Stock	2.3725	2.38	2.313	2.3325	25075500.0
2004-07-21 10:00:00	AMZN	Stock	2.331	2.3465	2.3205	2.324	21756620.0
2004-07-21 11:00:00	AMZN	Stock	2.324	2.334	2.305	2.3095	20437540.0
2004-07-21 12:00:00	AMZN	Stock	2.309	2.31	2.273	2.285	20959200.0
2004-07-21 13:00:00	AMZN	Stock	2.285	2.2885	2.254	2.254	17763520.0
2004-07-21 14:00:00	AMZN	Stock	2.253	2.2635	2.2455	2.2515	20362780.0
2004-07-21 15:00:00	AMZN	Stock	2.251	2.252	2.226	2.2465	39219200.0
2004-07-21 16:00:00	AMZN	Stock	2.2395	2.2595	2.125	2.1415	14260560.0
2004-07-21 17:00:00	AMZN	Stock	2.1425	2.238	2.1425	2.19	1978880.0
2004-07-21 18:00:00	AMZN	Stock	2.175	2.2	2.175	2.18	42000.0
2004-07-21 09:00:00	CL	Stock	27.65	27.65	27.185	27.185	1371600.0
2004-07-21 10:00:00	CL	Stock	27.25	27.375	27.125	27.345	3260600.0
2004-07-21 11:00:00	CL	Stock	27.345	27.9	27.325	27.9	2321200.0
2004-07-21 12:00:00	CL	Stock	27.92	27.96	27.745	27.765	1225200.0
2004-07-21 13:00:00	CL	Stock	27.765	27.815	27.7	27.72	727400.0
2004-07-21 14:00:00	CL	Stock	27.715	27.755	27.61	27.615	1032000.0
2004-07-21 15:00:00	CL	Stock	27.615	27.655	27.4	27.5	2273400.0
2004-07-21 16:00:00	CL	Stock	27.4995	27.5	27.4995	27.5	11800.0

> showing 50 of 24,974 rows — these rows as CSV

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