PREVIEW / stock_1hour / 2002-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-06-04.parquet
  size:    415 KB
  rows:    19,311
  symbols: 1,432

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-06-04 08:00:00	AAPL	Stock	0.4084	0.4091	0.4084	0.4091	89600.0
2002-06-04 09:00:00	AAPL	Stock	0.4082	0.4114	0.4036	0.407	49946400.0
2002-06-04 10:00:00	AAPL	Stock	0.407	0.4098	0.402	0.4055	53877600.0
2002-06-04 11:00:00	AAPL	Stock	0.4055	0.4098	0.4039	0.405	40454400.0
2002-06-04 12:00:00	AAPL	Stock	0.405	0.4054	0.3991	0.4002	33236000.0
2002-06-04 13:00:00	AAPL	Stock	0.4005	0.4063	0.3991	0.4054	40712000.0
2002-06-04 14:00:00	AAPL	Stock	0.405	0.41	0.4007	0.4013	34171200.0
2002-06-04 15:00:00	AAPL	Stock	0.4018	0.4068	0.3961	0.4068	50859200.0
2002-06-04 16:00:00	AAPL	Stock	0.4063	0.407	0.4052	0.4068	7364000.0
2002-06-04 18:00:00	AAPL	Stock	0.4068	0.4068	0.4068	0.4068	16800.0
2002-06-04 08:00:00	MSFT	Stock	24.8	24.8	24.645	24.705	50800.0
2002-06-04 09:00:00	MSFT	Stock	24.705	25.2025	24.62	25.2025	12424400.0
2002-06-04 10:00:00	MSFT	Stock	25.2	25.4	24.86	24.96	15000200.0
2002-06-04 11:00:00	MSFT	Stock	24.97	25.17	24.815	24.985	9310400.0
2002-06-04 12:00:00	MSFT	Stock	24.99	25.045	24.845	24.9	5168200.0
2002-06-04 13:00:00	MSFT	Stock	24.9	25.42	24.875	25.35	9897000.0
2002-06-04 14:00:00	MSFT	Stock	25.355	25.615	25.075	25.125	11855800.0
2002-06-04 15:00:00	MSFT	Stock	25.12	25.165	24.719	24.99	16804200.0
2002-06-04 16:00:00	MSFT	Stock	24.985	25.2095	24.94	25.04	2427800.0
2002-06-04 17:00:00	MSFT	Stock	25.025	25.09	24.98	25.005	56000.0
2002-06-04 18:00:00	MSFT	Stock	25.0	25.0	24.99	24.99	47200.0
2002-06-04 08:00:00	NVDA	Stock	0.2618	0.2641	0.2567	0.2599	2748000.0
2002-06-04 09:00:00	NVDA	Stock	0.2602	0.2684	0.2587	0.2663	123096000.0
2002-06-04 10:00:00	NVDA	Stock	0.2665	0.2693	0.2654	0.2667	192168000.0
2002-06-04 11:00:00	NVDA	Stock	0.2669	0.2685	0.2647	0.2659	97608000.0
2002-06-04 12:00:00	NVDA	Stock	0.266	0.2665	0.2641	0.265	80784000.0
2002-06-04 13:00:00	NVDA	Stock	0.2651	0.2724	0.2643	0.2706	129048000.0
2002-06-04 14:00:00	NVDA	Stock	0.2707	0.2771	0.27	0.271	167424000.0
2002-06-04 15:00:00	NVDA	Stock	0.2711	0.2759	0.2687	0.2757	186648000.0
2002-06-04 16:00:00	NVDA	Stock	0.2757	0.2783	0.2691	0.2781	50964000.0
2002-06-04 17:00:00	NVDA	Stock	0.2785	0.2812	0.2783	0.2792	4176000.0
2002-06-04 18:00:00	NVDA	Stock	0.2796	0.2804	0.2757	0.28	300000.0
2002-06-04 08:00:00	AMZN	Stock	0.8995	0.8995	0.8935	0.8985	80000.0
2002-06-04 09:00:00	AMZN	Stock	0.8975	0.907	0.882	0.8895	18450000.0
2002-06-04 10:00:00	AMZN	Stock	0.8895	0.8945	0.8755	0.881	26908000.0
2002-06-04 11:00:00	AMZN	Stock	0.881	0.885	0.876	0.8762	11066000.0
2002-06-04 12:00:00	AMZN	Stock	0.8775	0.8795	0.8735	0.875	10064000.0
2002-06-04 13:00:00	AMZN	Stock	0.875	0.884	0.874	0.881	17320000.0
2002-06-04 14:00:00	AMZN	Stock	0.881	0.8994	0.877	0.888	21144000.0
2002-06-04 15:00:00	AMZN	Stock	0.8885	0.901	0.886	0.8985	20396000.0
2002-06-04 16:00:00	AMZN	Stock	0.898	0.9	0.8831	0.8831	1128000.0
2002-06-04 17:00:00	AMZN	Stock	0.9	0.901	0.8995	0.901	50000.0
2002-06-04 18:00:00	AMZN	Stock	0.8985	0.9015	0.8985	0.9015	50000.0
2002-06-04 09:00:00	CL	Stock	27.025	27.125	26.955	27.025	434600.0
2002-06-04 10:00:00	CL	Stock	27.035	27.1	26.9	26.99	695200.0
2002-06-04 11:00:00	CL	Stock	26.995	27.01	26.875	26.9	469800.0
2002-06-04 12:00:00	CL	Stock	26.93	26.99	26.89	26.935	279400.0
2002-06-04 13:00:00	CL	Stock	26.94	27.2	26.935	27.15	459200.0
2002-06-04 14:00:00	CL	Stock	27.15	27.31	27.045	27.13	610200.0
2002-06-04 15:00:00	CL	Stock	27.125	27.135	26.895	26.965	863200.0

> showing 50 of 19,311 rows — these rows as CSV

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