PREVIEW / stock_1hour / 2002-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-26.parquet
  size:    368 KB
  rows:    17,689
  symbols: 1,450

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
2002-07-26 09:00:00	AAPL	Stock	0.2582	0.2595	0.2545	0.2584	18713968.0
2002-07-26 10:00:00	AAPL	Stock	0.2579	0.2588	0.2518	0.2571	34062000.0
2002-07-26 11:00:00	AAPL	Stock	0.2571	0.2586	0.255	0.2555	16510872.0
2002-07-26 12:00:00	AAPL	Stock	0.2555	0.2568	0.25	0.2509	27830040.0
2002-07-26 13:00:00	AAPL	Stock	0.2511	0.2536	0.2482	0.2502	29858080.0
2002-07-26 14:00:00	AAPL	Stock	0.2504	0.2518	0.2464	0.2509	26900496.0
2002-07-26 15:00:00	AAPL	Stock	0.2509	0.257	0.2509	0.257	35443352.0
2002-07-26 16:00:00	AAPL	Stock	0.2568	0.2568	0.2561	0.2561	369600.0
2002-07-26 09:00:00	MSFT	Stock	21.87	22.45	21.84	22.415	23902224.0
2002-07-26 10:00:00	MSFT	Stock	22.415	22.51	21.98	22.39	27343448.0
2002-07-26 11:00:00	MSFT	Stock	22.38	22.705	22.25	22.45	16478232.0
2002-07-26 12:00:00	MSFT	Stock	22.45	22.55	22.2	22.38	10436668.0
2002-07-26 13:00:00	MSFT	Stock	22.39	22.5	22.225	22.4	10407100.0
2002-07-26 14:00:00	MSFT	Stock	22.4	22.45	22.015	22.295	12548402.0
2002-07-26 15:00:00	MSFT	Stock	22.29	22.69	22.24	22.675	16606690.0
2002-07-26 16:00:00	MSFT	Stock	22.675	22.685	22.655	22.675	186400.0
2002-07-26 09:00:00	NVDA	Stock	0.1292	0.1322	0.1258	0.1277	161205000.0
2002-07-26 10:00:00	NVDA	Stock	0.1273	0.1287	0.1213	0.1258	329614320.0
2002-07-26 11:00:00	NVDA	Stock	0.1257	0.1282	0.1244	0.1247	146566560.0
2002-07-26 12:00:00	NVDA	Stock	0.1249	0.1257	0.1227	0.1233	106702080.0
2002-07-26 13:00:00	NVDA	Stock	0.1227	0.1239	0.1212	0.1218	164266320.0
2002-07-26 14:00:00	NVDA	Stock	0.122	0.1227	0.1192	0.1221	137592720.0
2002-07-26 15:00:00	NVDA	Stock	0.1222	0.1233	0.1203	0.1225	152706600.0
2002-07-26 16:00:00	NVDA	Stock	0.1225	0.1226	0.1224	0.1226	1128000.0
2002-07-26 09:00:00	AMZN	Stock	0.636	0.6415	0.625	0.6345	21820260.0
2002-07-26 10:00:00	AMZN	Stock	0.6345	0.65	0.6255	0.6456	23400820.0
2002-07-26 11:00:00	AMZN	Stock	0.647	0.6555	0.6435	0.645	16158000.0
2002-07-26 12:00:00	AMZN	Stock	0.645	0.65	0.633	0.635	10895280.0
2002-07-26 13:00:00	AMZN	Stock	0.635	0.645	0.629	0.643	6655960.0
2002-07-26 14:00:00	AMZN	Stock	0.6435	0.648	0.6366	0.647	8083520.0
2002-07-26 15:00:00	AMZN	Stock	0.6456	0.655	0.64	0.6495	17884680.0
2002-07-26 16:00:00	AMZN	Stock	0.647	0.6495	0.647	0.6495	30000.0
2002-07-26 09:00:00	CL	Stock	25.5	25.5	25.125	25.33	572800.0
2002-07-26 10:00:00	CL	Stock	25.33	25.43	25.0	25.2	859000.0
2002-07-26 11:00:00	CL	Stock	25.18	25.45	25.145	25.305	748200.0
2002-07-26 12:00:00	CL	Stock	25.305	25.31	25.08	25.29	640800.0
2002-07-26 13:00:00	CL	Stock	25.295	25.3	25.175	25.23	649800.0
2002-07-26 14:00:00	CL	Stock	25.265	25.3	24.95	25.0	2169000.0
2002-07-26 15:00:00	CL	Stock	25.0	25.125	24.9	25.125	1209800.0
2002-07-26 16:00:00	CL	Stock	25.12	25.125	25.12	25.125	116800.0

> showing 40 of 17,689 rows — these rows as CSV

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