PREVIEW / stock_1hour / 2002-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-12.parquet
  size:    382 KB
  rows:    18,052
  symbols: 1,460

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-08-12 08:00:00	AAPL	Stock	0.2661	0.2661	0.2661	0.2661	5600.0
2002-08-12 09:00:00	AAPL	Stock	0.2661	0.267	0.263	0.2661	24256400.0
2002-08-12 10:00:00	AAPL	Stock	0.267	0.267	0.263	0.2638	29038240.0
2002-08-12 11:00:00	AAPL	Stock	0.2638	0.2639	0.2629	0.2634	16081520.0
2002-08-12 12:00:00	AAPL	Stock	0.2634	0.2643	0.2625	0.2638	15171576.0
2002-08-12 13:00:00	AAPL	Stock	0.2639	0.2641	0.2623	0.263	21210840.0
2002-08-12 14:00:00	AAPL	Stock	0.2632	0.2652	0.2629	0.2652	17145072.0
2002-08-12 15:00:00	AAPL	Stock	0.2652	0.2682	0.2643	0.2663	39631816.0
2002-08-12 16:00:00	AAPL	Stock	0.2664	0.2677	0.2661	0.2677	11033400.0
2002-08-12 17:00:00	AAPL	Stock	0.2677	0.2677	0.2677	0.2677	56000.0
2002-08-12 08:00:00	MSFT	Stock	24.1	24.145	23.781	23.825	95192.0
2002-08-12 09:00:00	MSFT	Stock	24.065	24.25	23.8	24.205	8896982.0
2002-08-12 10:00:00	MSFT	Stock	24.23	24.25	23.825	23.975	10102410.0
2002-08-12 11:00:00	MSFT	Stock	23.98	24.12	23.855	24.025	5357894.0
2002-08-12 12:00:00	MSFT	Stock	24.035	24.35	23.96	24.225	6218484.0
2002-08-12 13:00:00	MSFT	Stock	24.225	24.25	23.945	24.0	5714454.0
2002-08-12 14:00:00	MSFT	Stock	23.99	24.205	23.955	24.2	5975590.0
2002-08-12 15:00:00	MSFT	Stock	24.2	24.375	24.1005	24.2345	11375828.0
2002-08-12 16:00:00	MSFT	Stock	24.22	24.255	24.165	24.25	983010.0
2002-08-12 17:00:00	MSFT	Stock	24.25	24.26	24.22	24.235	42400.0
2002-08-12 18:00:00	MSFT	Stock	24.235	24.235	24.2	24.2	13860.0
2002-08-12 08:00:00	NVDA	Stock	0.075	0.0774	0.075	0.075	654000.0
2002-08-12 09:00:00	NVDA	Stock	0.0753	0.0791	0.0738	0.0789	136824240.0
2002-08-12 10:00:00	NVDA	Stock	0.079	0.0796	0.078	0.0783	133462920.0
2002-08-12 11:00:00	NVDA	Stock	0.0782	0.0784	0.0766	0.0773	60505800.0
2002-08-12 12:00:00	NVDA	Stock	0.0773	0.0785	0.0767	0.0778	46413120.0
2002-08-12 13:00:00	NVDA	Stock	0.0778	0.0781	0.0768	0.0776	34976160.0
2002-08-12 14:00:00	NVDA	Stock	0.0777	0.0782	0.0773	0.0779	41740320.0
2002-08-12 15:00:00	NVDA	Stock	0.078	0.0787	0.0763	0.0766	119795520.0
2002-08-12 16:00:00	NVDA	Stock	0.0767	0.0771	0.0764	0.0767	10039920.0
2002-08-12 17:00:00	NVDA	Stock	0.0766	0.0767	0.0763	0.0767	801600.0
2002-08-12 08:00:00	AMZN	Stock	0.7115	0.7115	0.7	0.7	248000.0
2002-08-12 09:00:00	AMZN	Stock	0.7025	0.711	0.6975	0.7075	10296660.0
2002-08-12 10:00:00	AMZN	Stock	0.7065	0.7125	0.699	0.702	12723300.0
2002-08-12 11:00:00	AMZN	Stock	0.702	0.705	0.6985	0.705	5844100.0
2002-08-12 12:00:00	AMZN	Stock	0.704	0.7125	0.704	0.7105	5542280.0
2002-08-12 13:00:00	AMZN	Stock	0.7105	0.713	0.709	0.7105	5820660.0
2002-08-12 14:00:00	AMZN	Stock	0.7105	0.717	0.708	0.713	5980000.0
2002-08-12 15:00:00	AMZN	Stock	0.713	0.7205	0.709	0.7205	13680040.0
2002-08-12 16:00:00	AMZN	Stock	0.7205	0.725	0.719	0.725	6266000.0
2002-08-12 17:00:00	AMZN	Stock	0.725	0.7255	0.723	0.7255	344000.0
2002-08-12 18:00:00	AMZN	Stock	0.725	0.725	0.725	0.725	22000.0
2002-08-12 09:00:00	CL	Stock	26.75	26.8	26.63	26.705	320200.0
2002-08-12 10:00:00	CL	Stock	26.7	26.75	26.605	26.725	455400.0
2002-08-12 11:00:00	CL	Stock	26.69	26.895	26.69	26.855	199000.0
2002-08-12 12:00:00	CL	Stock	26.85	26.9	26.775	26.81	216400.0
2002-08-12 13:00:00	CL	Stock	26.83	26.84	26.685	26.715	302400.0
2002-08-12 14:00:00	CL	Stock	26.7	26.88	26.685	26.86	241600.0
2002-08-12 15:00:00	CL	Stock	26.88	26.975	26.84	26.865	307800.0
2002-08-12 16:00:00	CL	Stock	26.855	26.855	26.85	26.855	81600.0

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

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