PREVIEW / stock_1hour / 2002-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-25.parquet
  size:    390 KB
  rows:    18,172
  symbols: 1,455

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-25 09:00:00	AAPL	Stock	0.2666	0.267	0.2557	0.258	44983680.0
2002-07-25 10:00:00	AAPL	Stock	0.258	0.2607	0.2536	0.2557	78424192.0
2002-07-25 11:00:00	AAPL	Stock	0.2555	0.2596	0.2523	0.2563	61795552.0
2002-07-25 12:00:00	AAPL	Stock	0.2563	0.2577	0.2536	0.2554	37818424.0
2002-07-25 13:00:00	AAPL	Stock	0.2564	0.2588	0.2509	0.2521	60272352.0
2002-07-25 14:00:00	AAPL	Stock	0.2514	0.2557	0.2502	0.2545	67029200.0
2002-07-25 15:00:00	AAPL	Stock	0.2545	0.2634	0.2543	0.2564	109013016.0
2002-07-25 16:00:00	AAPL	Stock	0.2566	0.2566	0.2564	0.2564	442400.0
2002-07-25 09:00:00	MSFT	Stock	22.725	22.8575	22.305	22.62	15097254.0
2002-07-25 10:00:00	MSFT	Stock	22.615	22.78	22.2	22.23	30576844.0
2002-07-25 11:00:00	MSFT	Stock	22.23	22.525	21.91	22.195	25036746.0
2002-07-25 12:00:00	MSFT	Stock	22.19	22.3	21.51	21.825	20980208.0
2002-07-25 13:00:00	MSFT	Stock	21.825	22.05	21.55	21.67	12422428.0
2002-07-25 14:00:00	MSFT	Stock	21.668	21.787	21.22	21.48	22493666.0
2002-07-25 15:00:00	MSFT	Stock	21.485	22.255	21.26	21.425	28538984.0
2002-07-25 16:00:00	MSFT	Stock	21.41	21.45	21.4	21.41	405590.0
2002-07-25 09:00:00	NVDA	Stock	0.1363	0.1367	0.1284	0.1327	225981840.0
2002-07-25 10:00:00	NVDA	Stock	0.1325	0.133	0.1292	0.1297	297478560.0
2002-07-25 11:00:00	NVDA	Stock	0.1296	0.1312	0.1259	0.1273	257805240.0
2002-07-25 12:00:00	NVDA	Stock	0.1274	0.1278	0.121	0.1267	292499640.0
2002-07-25 13:00:00	NVDA	Stock	0.1267	0.1296	0.1232	0.1233	205225200.0
2002-07-25 14:00:00	NVDA	Stock	0.1237	0.1279	0.1225	0.1257	152949840.0
2002-07-25 15:00:00	NVDA	Stock	0.1258	0.1287	0.1234	0.126	274812240.0
2002-07-25 16:00:00	NVDA	Stock	0.1255	0.1256	0.1255	0.1256	1614000.0
2002-07-25 09:00:00	AMZN	Stock	0.6855	0.693	0.6705	0.692	22749540.0
2002-07-25 10:00:00	AMZN	Stock	0.6925	0.7005	0.663	0.6665	27235800.0
2002-07-25 11:00:00	AMZN	Stock	0.667	0.6675	0.645	0.6535	35875000.0
2002-07-25 12:00:00	AMZN	Stock	0.653	0.6566	0.6455	0.6485	27654420.0
2002-07-25 13:00:00	AMZN	Stock	0.6485	0.653	0.6385	0.6415	12684740.0
2002-07-25 14:00:00	AMZN	Stock	0.642	0.645	0.631	0.64	18458240.0
2002-07-25 15:00:00	AMZN	Stock	0.64	0.65	0.62	0.6225	28601980.0
2002-07-25 16:00:00	AMZN	Stock	0.6255	0.6255	0.62	0.6245	230000.0
2002-07-25 09:00:00	CL	Stock	25.12	25.12	24.83	24.945	597800.0
2002-07-25 10:00:00	CL	Stock	24.945	25.175	24.84	25.0	831000.0
2002-07-25 11:00:00	CL	Stock	25.0	25.245	24.875	25.175	933400.0
2002-07-25 12:00:00	CL	Stock	25.13	25.2	24.95	25.0	574600.0
2002-07-25 13:00:00	CL	Stock	25.0	25.09	24.7	24.725	466400.0
2002-07-25 14:00:00	CL	Stock	24.725	24.875	24.425	24.785	880400.0
2002-07-25 15:00:00	CL	Stock	24.78	25.375	24.7	25.29	939400.0
2002-07-25 16:00:00	CL	Stock	25.29	25.295	25.29	25.295	142200.0

> showing 40 of 18,172 rows — these rows as CSV

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