PREVIEW / stock_1hour / 2002-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-09.parquet
  size:    390 KB
  rows:    18,591
  symbols: 1,469

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-09-09 09:00:00	AAPL	Stock	0.2552	0.2557	0.2529	0.2541	13332760.0
2002-09-09 10:00:00	AAPL	Stock	0.2541	0.2541	0.2527	0.2536	25208064.0
2002-09-09 11:00:00	AAPL	Stock	0.2538	0.2539	0.2529	0.2531	13351688.0
2002-09-09 12:00:00	AAPL	Stock	0.2532	0.2548	0.2527	0.2543	11617200.0
2002-09-09 13:00:00	AAPL	Stock	0.2543	0.2564	0.2539	0.255	14234416.0
2002-09-09 14:00:00	AAPL	Stock	0.2548	0.2573	0.2548	0.257	22675576.0
2002-09-09 15:00:00	AAPL	Stock	0.2568	0.2595	0.255	0.2563	34231400.0
2002-09-09 16:00:00	AAPL	Stock	0.2561	0.257	0.2561	0.2566	3343200.0
2002-09-09 17:00:00	AAPL	Stock	0.2566	0.2566	0.2566	0.2566	1836800.0
2002-09-09 08:00:00	MSFT	Stock	23.74	23.91	23.65	23.67	47000.0
2002-09-09 09:00:00	MSFT	Stock	23.67	23.91	23.44	23.45	9183802.0
2002-09-09 10:00:00	MSFT	Stock	23.455	23.525	23.315	23.49	12239506.0
2002-09-09 11:00:00	MSFT	Stock	23.495	23.575	23.445	23.52	7004872.0
2002-09-09 12:00:00	MSFT	Stock	23.52	23.7665	23.515	23.755	7009976.0
2002-09-09 13:00:00	MSFT	Stock	23.75	24.125	23.72	24.025	10971038.0
2002-09-09 14:00:00	MSFT	Stock	24.02	24.4	23.9915	24.325	14218450.0
2002-09-09 15:00:00	MSFT	Stock	24.325	24.475	24.185	24.375	16068454.0
2002-09-09 16:00:00	MSFT	Stock	24.345	24.385	24.315	24.345	2107324.0
2002-09-09 17:00:00	MSFT	Stock	24.34	24.35	24.32	24.325	274120.0
2002-09-09 18:00:00	MSFT	Stock	24.325	24.345	24.32	24.325	9972.0
2002-09-09 08:00:00	NVDA	Stock	0.0771	0.0771	0.0757	0.0757	432000.0
2002-09-09 09:00:00	NVDA	Stock	0.0757	0.0767	0.0751	0.0755	81736080.0
2002-09-09 10:00:00	NVDA	Stock	0.0755	0.0761	0.0742	0.076	87480360.0
2002-09-09 11:00:00	NVDA	Stock	0.076	0.0763	0.0756	0.0761	48282960.0
2002-09-09 12:00:00	NVDA	Stock	0.0761	0.0778	0.0758	0.0777	61551120.0
2002-09-09 13:00:00	NVDA	Stock	0.0778	0.0787	0.077	0.0783	97174800.0
2002-09-09 14:00:00	NVDA	Stock	0.0784	0.0792	0.0778	0.0782	65094000.0
2002-09-09 15:00:00	NVDA	Stock	0.0782	0.0784	0.0768	0.0771	86815800.0
2002-09-09 16:00:00	NVDA	Stock	0.0771	0.0771	0.075	0.0756	22209840.0
2002-09-09 17:00:00	NVDA	Stock	0.0757	0.0771	0.0752	0.076	3796200.0
2002-09-09 18:00:00	NVDA	Stock	0.076	0.076	0.0759	0.0759	76200.0
2002-09-09 08:00:00	AMZN	Stock	0.7645	0.7645	0.7501	0.7565	50000.0
2002-09-09 09:00:00	AMZN	Stock	0.7549	0.7655	0.7525	0.756	10099300.0
2002-09-09 10:00:00	AMZN	Stock	0.7565	0.765	0.7535	0.764	13776400.0
2002-09-09 11:00:00	AMZN	Stock	0.763	0.765	0.7591	0.761	7487600.0
2002-09-09 12:00:00	AMZN	Stock	0.762	0.7905	0.761	0.7865	22072980.0
2002-09-09 13:00:00	AMZN	Stock	0.7865	0.804	0.786	0.803	26769380.0
2002-09-09 14:00:00	AMZN	Stock	0.8035	0.8175	0.7985	0.816	26384840.0
2002-09-09 15:00:00	AMZN	Stock	0.8162	0.8325	0.813	0.826	59968780.0
2002-09-09 16:00:00	AMZN	Stock	0.826	0.828	0.8235	0.8255	3584580.0
2002-09-09 17:00:00	AMZN	Stock	0.8255	0.8255	0.823	0.823	491940.0
2002-09-09 18:00:00	AMZN	Stock	0.823	0.8235	0.823	0.823	38620.0
2002-09-09 09:00:00	CL	Stock	27.25	27.375	27.23	27.345	404000.0
2002-09-09 10:00:00	CL	Stock	27.345	27.875	27.285	27.86	595600.0
2002-09-09 11:00:00	CL	Stock	27.855	27.965	27.8	27.955	698200.0
2002-09-09 12:00:00	CL	Stock	27.95	28.0	27.92	27.975	378000.0
2002-09-09 13:00:00	CL	Stock	27.97	28.025	27.93	28.0	383800.0
2002-09-09 14:00:00	CL	Stock	27.995	28.075	27.985	28.03	702000.0
2002-09-09 15:00:00	CL	Stock	28.03	28.035	27.915	27.925	601400.0
2002-09-09 16:00:00	CL	Stock	27.925	27.925	27.92	27.925	38800.0

> showing 50 of 18,591 rows — these rows as CSV

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