PREVIEW / stock_1hour / 2001-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-25.parquet
  size:    360 KB
  rows:    17,047
  symbols: 1,319

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
2001-07-25 08:00:00	AAPL	Stock	0.3429	0.3438	0.3409	0.3409	134400.0
2001-07-25 09:00:00	AAPL	Stock	0.3414	0.3432	0.3346	0.3348	36702400.0
2001-07-25 10:00:00	AAPL	Stock	0.3346	0.3438	0.3313	0.3334	71198400.0
2001-07-25 11:00:00	AAPL	Stock	0.3334	0.3339	0.3234	0.3268	87606400.0
2001-07-25 12:00:00	AAPL	Stock	0.3273	0.328	0.3214	0.3223	42929600.0
2001-07-25 13:00:00	AAPL	Stock	0.3229	0.3275	0.3214	0.3257	61241600.0
2001-07-25 14:00:00	AAPL	Stock	0.3259	0.3311	0.325	0.3304	36069600.0
2001-07-25 15:00:00	AAPL	Stock	0.3304	0.3348	0.3259	0.33	67160800.0
2001-07-25 16:00:00	AAPL	Stock	0.33	0.3432	0.3295	0.3432	10981600.0
2001-07-25 17:00:00	AAPL	Stock	0.3268	0.333	0.3268	0.3286	599200.0
2001-07-25 18:00:00	AAPL	Stock	0.3318	0.3332	0.3318	0.3332	11200.0
2001-07-25 08:00:00	MSFT	Stock	33.37	33.4	33.225	33.305	57400.0
2001-07-25 09:00:00	MSFT	Stock	33.305	33.35	32.89	33.04	8603400.0
2001-07-25 10:00:00	MSFT	Stock	33.04	33.6	32.95	33.5	13829000.0
2001-07-25 11:00:00	MSFT	Stock	33.5	33.52	33.235	33.36	5469400.0
2001-07-25 12:00:00	MSFT	Stock	33.37	33.4	32.95	33.075	7682600.0
2001-07-25 13:00:00	MSFT	Stock	33.07	33.21	32.805	33.11	7323800.0
2001-07-25 14:00:00	MSFT	Stock	33.11	33.49	33.05	33.435	9866200.0
2001-07-25 15:00:00	MSFT	Stock	33.435	33.75	33.105	33.75	14472800.0
2001-07-25 16:00:00	MSFT	Stock	33.755	33.91	33.25	33.78	2029000.0
2001-07-25 17:00:00	MSFT	Stock	33.435	33.825	33.435	33.75	328400.0
2001-07-25 18:00:00	MSFT	Stock	33.75	33.75	33.705	33.715	16400.0
2001-07-25 08:00:00	NVDA	Stock	0.3016	0.3018	0.3016	0.3016	96000.0
2001-07-25 09:00:00	NVDA	Stock	0.3002	0.3011	0.2887	0.2895	172752000.0
2001-07-25 10:00:00	NVDA	Stock	0.2899	0.3007	0.2888	0.2987	287280000.0
2001-07-25 11:00:00	NVDA	Stock	0.2988	0.2988	0.2941	0.2953	90504000.0
2001-07-25 12:00:00	NVDA	Stock	0.2953	0.2958	0.2915	0.2943	144672000.0
2001-07-25 13:00:00	NVDA	Stock	0.2943	0.2948	0.2904	0.2925	139920000.0
2001-07-25 14:00:00	NVDA	Stock	0.2923	0.2966	0.2917	0.295	114384000.0
2001-07-25 15:00:00	NVDA	Stock	0.295	0.3017	0.292	0.2988	208800000.0
2001-07-25 16:00:00	NVDA	Stock	0.2987	0.2996	0.2983	0.2987	9912000.0
2001-07-25 17:00:00	NVDA	Stock	0.3004	0.3008	0.3	0.3008	120000.0
2001-07-25 18:00:00	NVDA	Stock	0.3004	0.3004	0.3	0.3	72000.0
2001-07-25 08:00:00	AMZN	Stock	0.6175	0.625	0.61	0.615	1268220.0
2001-07-25 09:00:00	AMZN	Stock	0.615	0.63	0.5535	0.5645	55176000.0
2001-07-25 10:00:00	AMZN	Stock	0.5645	0.59	0.559	0.5795	70708000.0
2001-07-25 11:00:00	AMZN	Stock	0.5805	0.5885	0.575	0.5825	16740000.0
2001-07-25 12:00:00	AMZN	Stock	0.5825	0.5835	0.573	0.5765	16196000.0
2001-07-25 13:00:00	AMZN	Stock	0.577	0.578	0.5575	0.57	29492000.0
2001-07-25 14:00:00	AMZN	Stock	0.5695	0.583	0.5695	0.578	19040000.0
2001-07-25 15:00:00	AMZN	Stock	0.578	0.585	0.574	0.576	26212000.0
2001-07-25 16:00:00	AMZN	Stock	0.576	0.578	0.5605	0.575	3288000.0
2001-07-25 17:00:00	AMZN	Stock	0.575	0.578	0.5705	0.5705	74000.0
2001-07-25 18:00:00	AMZN	Stock	0.579	0.5815	0.579	0.5815	66000.0
2001-07-25 09:00:00	CL	Stock	27.025	27.13	26.975	27.075	301600.0
2001-07-25 10:00:00	CL	Stock	27.08	27.3	27.075	27.15	335400.0
2001-07-25 11:00:00	CL	Stock	27.15	27.16	27.0	27.065	295800.0
2001-07-25 12:00:00	CL	Stock	27.03	27.05	26.98	27.0	333800.0
2001-07-25 13:00:00	CL	Stock	27.005	27.05	27.0	27.01	182400.0
2001-07-25 14:00:00	CL	Stock	27.015	27.125	26.98	27.105	419600.0

> showing 50 of 17,047 rows — these rows as CSV

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