PREVIEW / stock_1hour / 2003-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-05-01.parquet
  size:    423 KB
  rows:    20,479
  symbols: 1,568

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-05-01 08:00:00	AAPL	Stock	0.252	0.252	0.252	0.252	56000.0
2003-05-01 09:00:00	AAPL	Stock	0.253	0.2555	0.2523	0.2538	28651672.0
2003-05-01 10:00:00	AAPL	Stock	0.2538	0.2539	0.25	0.2516	56802816.0
2003-05-01 11:00:00	AAPL	Stock	0.2516	0.2525	0.2504	0.2513	28312032.0
2003-05-01 12:00:00	AAPL	Stock	0.2511	0.2518	0.2505	0.2509	17015936.0
2003-05-01 13:00:00	AAPL	Stock	0.2509	0.2529	0.25	0.252	36571248.0
2003-05-01 14:00:00	AAPL	Stock	0.252	0.2552	0.2518	0.2546	41265504.0
2003-05-01 15:00:00	AAPL	Stock	0.2546	0.257	0.2536	0.2566	76841240.0
2003-05-01 16:00:00	AAPL	Stock	0.2568	0.2588	0.2555	0.2577	31978184.0
2003-05-01 17:00:00	AAPL	Stock	0.2577	0.2577	0.2563	0.2564	56000.0
2003-05-01 08:00:00	MSFT	Stock	25.57	25.6	25.5	25.5	61600.0
2003-05-01 09:00:00	MSFT	Stock	25.52	25.67	25.498	25.57	4590436.0
2003-05-01 10:00:00	MSFT	Stock	25.56	25.57	25.34	25.44	9179082.0
2003-05-01 11:00:00	MSFT	Stock	25.43	25.55	25.354	25.51	3931458.0
2003-05-01 12:00:00	MSFT	Stock	25.51	25.54	25.43	25.44	2393374.0
2003-05-01 13:00:00	MSFT	Stock	25.44	25.66	25.4	25.61	4473852.0
2003-05-01 14:00:00	MSFT	Stock	25.61	25.95	25.61	25.8	7017980.0
2003-05-01 15:00:00	MSFT	Stock	25.8	25.87	25.649	25.73	6101284.0
2003-05-01 16:00:00	MSFT	Stock	25.727	25.819	25.709	25.75	413257.0
2003-05-01 17:00:00	MSFT	Stock	25.75	25.79	25.71	25.78	10923.0
2003-05-01 18:00:00	MSFT	Stock	25.77	25.8	25.77	25.79	5550.0
2003-05-01 08:00:00	NVDA	Stock	0.1188	0.1188	0.1183	0.1183	444000.0
2003-05-01 09:00:00	NVDA	Stock	0.118	0.1213	0.1179	0.121	92304840.0
2003-05-01 10:00:00	NVDA	Stock	0.1211	0.1213	0.1198	0.1207	110874600.0
2003-05-01 11:00:00	NVDA	Stock	0.1208	0.1213	0.1199	0.1199	88064880.0
2003-05-01 12:00:00	NVDA	Stock	0.1199	0.12	0.1187	0.1199	82672920.0
2003-05-01 13:00:00	NVDA	Stock	0.1198	0.1201	0.1189	0.1196	60418800.0
2003-05-01 14:00:00	NVDA	Stock	0.1196	0.1212	0.1195	0.1203	135652080.0
2003-05-01 15:00:00	NVDA	Stock	0.1202	0.121	0.1193	0.1203	107092920.0
2003-05-01 16:00:00	NVDA	Stock	0.1203	0.1206	0.1189	0.1202	14126400.0
2003-05-01 17:00:00	NVDA	Stock	0.1197	0.1201	0.1197	0.1197	444000.0
2003-05-01 18:00:00	NVDA	Stock	0.1199	0.1199	0.1199	0.1199	36000.0
2003-05-01 08:00:00	AMZN	Stock	1.4325	1.438	1.428	1.432	181000.0
2003-05-01 09:00:00	AMZN	Stock	1.432	1.4445	1.4135	1.4165	27614980.0
2003-05-01 10:00:00	AMZN	Stock	1.416	1.419	1.4075	1.4165	27053180.0
2003-05-01 11:00:00	AMZN	Stock	1.4165	1.419	1.412	1.4155	15265620.0
2003-05-01 12:00:00	AMZN	Stock	1.4155	1.419	1.4125	1.415	9408960.0
2003-05-01 13:00:00	AMZN	Stock	1.4145	1.4235	1.41	1.415	16505860.0
2003-05-01 14:00:00	AMZN	Stock	1.415	1.4252	1.4095	1.424	19681520.0
2003-05-01 15:00:00	AMZN	Stock	1.424	1.4345	1.4175	1.433	26188200.0
2003-05-01 16:00:00	AMZN	Stock	1.433	1.4375	1.422	1.422	1805920.0
2003-05-01 17:00:00	AMZN	Stock	1.437	1.437	1.4325	1.4325	66000.0
2003-05-01 18:00:00	AMZN	Stock	1.432	1.4325	1.4305	1.4325	19000.0
2003-05-01 09:00:00	CL	Stock	28.425	28.49	28.38	28.435	256400.0
2003-05-01 10:00:00	CL	Stock	28.41	28.41	28.135	28.175	438600.0
2003-05-01 11:00:00	CL	Stock	28.16	28.27	28.13	28.27	306800.0
2003-05-01 12:00:00	CL	Stock	28.265	28.275	28.19	28.19	156600.0
2003-05-01 13:00:00	CL	Stock	28.19	28.355	28.175	28.345	255800.0
2003-05-01 14:00:00	CL	Stock	28.35	28.575	28.345	28.555	489000.0
2003-05-01 15:00:00	CL	Stock	28.555	28.555	28.43	28.45	361400.0

> showing 50 of 20,479 rows — these rows as CSV

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