PREVIEW / stock_1hour / 2002-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-24.parquet
  size:    396 KB
  rows:    18,626
  symbols: 1,465

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-24 09:00:00	AAPL	Stock	0.2559	0.2654	0.2545	0.258	51886352.0
2002-07-24 10:00:00	AAPL	Stock	0.2582	0.2677	0.2573	0.262	54918920.0
2002-07-24 11:00:00	AAPL	Stock	0.2621	0.2668	0.2582	0.2638	46000864.0
2002-07-24 12:00:00	AAPL	Stock	0.2638	0.2667	0.2616	0.2643	54732664.0
2002-07-24 13:00:00	AAPL	Stock	0.2645	0.2666	0.2613	0.2652	42293496.0
2002-07-24 14:00:00	AAPL	Stock	0.2648	0.267	0.2627	0.2643	41295800.0
2002-07-24 15:00:00	AAPL	Stock	0.2643	0.2718	0.2634	0.2709	71778616.0
2002-07-24 16:00:00	AAPL	Stock	0.2707	0.2718	0.2707	0.2714	1226400.0
2002-07-24 09:00:00	MSFT	Stock	20.875	21.225	20.705	20.955	29299652.0
2002-07-24 10:00:00	MSFT	Stock	20.945	21.89	20.875	21.74	42042192.0
2002-07-24 11:00:00	MSFT	Stock	21.74	22.4015	21.375	21.905	33468290.0
2002-07-24 12:00:00	MSFT	Stock	21.88	22.125	21.46	21.675	23162920.0
2002-07-24 13:00:00	MSFT	Stock	21.71	22.21	21.605	22.025	15593068.0
2002-07-24 14:00:00	MSFT	Stock	22.0355	22.495	21.905	22.355	20773122.0
2002-07-24 15:00:00	MSFT	Stock	22.37	23.18	22.32	23.1	30435986.0
2002-07-24 16:00:00	MSFT	Stock	23.105	23.13	23.09	23.115	111000.0
2002-07-24 09:00:00	NVDA	Stock	0.1315	0.1396	0.1314	0.1358	203527440.0
2002-07-24 10:00:00	NVDA	Stock	0.1357	0.1404	0.1342	0.1385	220868640.0
2002-07-24 11:00:00	NVDA	Stock	0.1383	0.144	0.1371	0.1406	188691960.0
2002-07-24 12:00:00	NVDA	Stock	0.1404	0.1422	0.1367	0.1389	133740720.0
2002-07-24 13:00:00	NVDA	Stock	0.1389	0.1401	0.1375	0.1381	102583440.0
2002-07-24 14:00:00	NVDA	Stock	0.1386	0.14	0.1358	0.1375	99745920.0
2002-07-24 15:00:00	NVDA	Stock	0.1375	0.1427	0.1373	0.1418	191568120.0
2002-07-24 16:00:00	NVDA	Stock	0.1418	0.1421	0.1418	0.1418	528000.0
2002-07-24 09:00:00	AMZN	Stock	0.6185	0.673	0.613	0.654	78615500.0
2002-07-24 10:00:00	AMZN	Stock	0.6545	0.665	0.6315	0.65	73656780.0
2002-07-24 11:00:00	AMZN	Stock	0.6505	0.7075	0.6445	0.6915	45286520.0
2002-07-24 12:00:00	AMZN	Stock	0.694	0.702	0.674	0.6875	43136820.0
2002-07-24 13:00:00	AMZN	Stock	0.687	0.7005	0.68	0.6945	28028140.0
2002-07-24 14:00:00	AMZN	Stock	0.6925	0.699	0.6605	0.673	31094400.0
2002-07-24 15:00:00	AMZN	Stock	0.6725	0.708	0.6725	0.705	51635220.0
2002-07-24 16:00:00	AMZN	Stock	0.705	0.707	0.705	0.705	112000.0
2002-07-24 09:00:00	CL	Stock	23.51	23.75	23.455	23.635	1022400.0
2002-07-24 10:00:00	CL	Stock	23.625	23.95	23.5	23.655	1628200.0
2002-07-24 11:00:00	CL	Stock	23.645	24.055	23.645	24.055	984000.0
2002-07-24 12:00:00	CL	Stock	24.025	24.29	23.875	23.955	927800.0
2002-07-24 13:00:00	CL	Stock	23.955	24.3	23.855	24.1	888000.0
2002-07-24 14:00:00	CL	Stock	24.125	24.735	24.1	24.675	921000.0
2002-07-24 15:00:00	CL	Stock	24.625	25.25	24.525	24.99	1596800.0
2002-07-24 16:00:00	CL	Stock	25.0	25.0	24.995	24.995	128200.0

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

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