PREVIEW / stock_1hour / 2002-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-09.parquet
  size:    388 KB
  rows:    18,317
  symbols: 1,449

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-09 08:00:00	AAPL	Stock	0.2714	0.2721	0.2714	0.2721	453600.0
2002-08-09 09:00:00	AAPL	Stock	0.2704	0.2723	0.2671	0.2679	20060208.0
2002-08-09 10:00:00	AAPL	Stock	0.2673	0.2696	0.2652	0.2663	45220504.0
2002-08-09 11:00:00	AAPL	Stock	0.2661	0.2688	0.2654	0.2673	42051520.0
2002-08-09 12:00:00	AAPL	Stock	0.2673	0.2677	0.2652	0.2657	14899528.0
2002-08-09 13:00:00	AAPL	Stock	0.2654	0.2686	0.2645	0.2679	22515024.0
2002-08-09 14:00:00	AAPL	Stock	0.2677	0.2714	0.267	0.2695	24833648.0
2002-08-09 15:00:00	AAPL	Stock	0.2693	0.2705	0.2663	0.2677	27058528.0
2002-08-09 16:00:00	AAPL	Stock	0.2664	0.2679	0.2661	0.2679	3091200.0
2002-08-09 17:00:00	AAPL	Stock	0.2679	0.2679	0.2679	0.2679	2178400.0
2002-08-09 08:00:00	MSFT	Stock	24.165	24.4525	24.069	24.1	125516.0
2002-08-09 09:00:00	MSFT	Stock	24.0755	24.45	24.005	24.1	7456318.0
2002-08-09 10:00:00	MSFT	Stock	24.1	24.32	23.83	24.135	13591290.0
2002-08-09 11:00:00	MSFT	Stock	24.135	24.45	24.085	24.325	9320974.0
2002-08-09 12:00:00	MSFT	Stock	24.3205	24.36	24.065	24.155	5725140.0
2002-08-09 13:00:00	MSFT	Stock	24.15	24.3565	23.95	24.295	8016220.0
2002-08-09 14:00:00	MSFT	Stock	24.295	24.575	24.185	24.405	11642670.0
2002-08-09 15:00:00	MSFT	Stock	24.415	24.485	24.045	24.06	11164446.0
2002-08-09 16:00:00	MSFT	Stock	24.0565	24.1	24.055	24.07	972694.0
2002-08-09 17:00:00	MSFT	Stock	24.065	24.075	24.06	24.07	298780.0
2002-08-09 18:00:00	MSFT	Stock	24.07	24.07	24.061	24.065	800.0
2002-08-09 08:00:00	NVDA	Stock	0.0767	0.0785	0.0764	0.0767	2628600.0
2002-08-09 09:00:00	NVDA	Stock	0.0767	0.0775	0.0756	0.0764	89778240.0
2002-08-09 10:00:00	NVDA	Stock	0.0765	0.0774	0.0751	0.0765	90792840.0
2002-08-09 11:00:00	NVDA	Stock	0.0765	0.0792	0.0758	0.0776	93653160.0
2002-08-09 12:00:00	NVDA	Stock	0.0776	0.0787	0.0767	0.0771	77980200.0
2002-08-09 13:00:00	NVDA	Stock	0.0771	0.0772	0.0758	0.077	67012920.0
2002-08-09 14:00:00	NVDA	Stock	0.0771	0.0786	0.0762	0.0773	73042200.0
2002-08-09 15:00:00	NVDA	Stock	0.0773	0.0781	0.0765	0.0767	77688480.0
2002-08-09 16:00:00	NVDA	Stock	0.0767	0.0779	0.0766	0.0767	8580000.0
2002-08-09 17:00:00	NVDA	Stock	0.0767	0.0775	0.0767	0.0775	1914000.0
2002-08-09 18:00:00	NVDA	Stock	0.0772	0.0772	0.0772	0.0772	102000.0
2002-08-09 08:00:00	AMZN	Stock	0.6905	0.695	0.6831	0.6831	83400.0
2002-08-09 09:00:00	AMZN	Stock	0.6829	0.695	0.675	0.6945	10497680.0
2002-08-09 10:00:00	AMZN	Stock	0.695	0.7121	0.6915	0.71	14351140.0
2002-08-09 11:00:00	AMZN	Stock	0.709	0.7145	0.703	0.7075	8620740.0
2002-08-09 12:00:00	AMZN	Stock	0.7075	0.711	0.7035	0.7075	4115420.0
2002-08-09 13:00:00	AMZN	Stock	0.7073	0.7265	0.703	0.7256	13487780.0
2002-08-09 14:00:00	AMZN	Stock	0.7255	0.7375	0.72	0.7326	19543740.0
2002-08-09 15:00:00	AMZN	Stock	0.733	0.734	0.716	0.7165	17992340.0
2002-08-09 16:00:00	AMZN	Stock	0.7165	0.719	0.71	0.713	1660460.0
2002-08-09 17:00:00	AMZN	Stock	0.71	0.713	0.71	0.713	706000.0
2002-08-09 09:00:00	CL	Stock	27.025	27.03	26.755	26.825	300400.0
2002-08-09 10:00:00	CL	Stock	26.825	26.835	26.605	26.71	804000.0
2002-08-09 11:00:00	CL	Stock	26.705	26.875	26.685	26.77	643400.0
2002-08-09 12:00:00	CL	Stock	26.775	26.9	26.72	26.76	348200.0
2002-08-09 13:00:00	CL	Stock	26.755	26.95	26.65	26.88	358000.0
2002-08-09 14:00:00	CL	Stock	26.88	27.025	26.805	27.015	536200.0
2002-08-09 15:00:00	CL	Stock	27.01	27.1	27.0	27.06	759800.0
2002-08-09 16:00:00	CL	Stock	27.035	27.035	27.035	27.035	37200.0

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

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