PREVIEW / stock_1hour / 2001-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-23.parquet
  size:    353 KB
  rows:    17,043
  symbols: 1,320

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-23 08:00:00	AAPL	Stock	0.3568	0.3607	0.3568	0.3584	1036000.0
2001-07-23 09:00:00	AAPL	Stock	0.3588	0.3661	0.3563	0.3586	37637600.0
2001-07-23 10:00:00	AAPL	Stock	0.3589	0.3605	0.3496	0.3507	51144800.0
2001-07-23 11:00:00	AAPL	Stock	0.3505	0.3545	0.3498	0.3536	36680000.0
2001-07-23 12:00:00	AAPL	Stock	0.3536	0.3568	0.3523	0.3554	18121600.0
2001-07-23 13:00:00	AAPL	Stock	0.3554	0.3588	0.3538	0.3571	25166400.0
2001-07-23 14:00:00	AAPL	Stock	0.3571	0.3586	0.3513	0.3554	19969600.0
2001-07-23 15:00:00	AAPL	Stock	0.3548	0.3563	0.3484	0.3486	24852800.0
2001-07-23 16:00:00	AAPL	Stock	0.3488	0.3554	0.3473	0.3489	17382400.0
2001-07-23 17:00:00	AAPL	Stock	0.3489	0.3489	0.3482	0.3482	84000.0
2001-07-23 08:00:00	MSFT	Stock	34.945	35.05	34.66	34.8	53200.0
2001-07-23 09:00:00	MSFT	Stock	34.8	34.875	34.095	34.14	8387000.0
2001-07-23 10:00:00	MSFT	Stock	34.13	34.215	33.35	33.41	18579600.0
2001-07-23 11:00:00	MSFT	Stock	33.41	33.8	33.36	33.77	13335000.0
2001-07-23 12:00:00	MSFT	Stock	33.765	33.88	33.505	33.795	6234600.0
2001-07-23 13:00:00	MSFT	Stock	33.795	33.935	33.725	33.81	5294800.0
2001-07-23 14:00:00	MSFT	Stock	33.81	33.875	33.425	33.66	8279800.0
2001-07-23 15:00:00	MSFT	Stock	33.66	33.675	33.395	33.575	12774400.0
2001-07-23 16:00:00	MSFT	Stock	33.55	34.49	33.45	33.545	3564200.0
2001-07-23 17:00:00	MSFT	Stock	33.745	33.745	33.575	33.575	22200.0
2001-07-23 18:00:00	MSFT	Stock	33.625	33.625	33.625	33.625	600.0
2001-07-23 08:00:00	NVDA	Stock	0.3125	0.3142	0.3124	0.3124	2472000.0
2001-07-23 09:00:00	NVDA	Stock	0.3129	0.3135	0.2953	0.2973	138576000.0
2001-07-23 10:00:00	NVDA	Stock	0.2969	0.3021	0.2878	0.2894	275304000.0
2001-07-23 11:00:00	NVDA	Stock	0.289	0.2958	0.2852	0.2946	313152000.0
2001-07-23 12:00:00	NVDA	Stock	0.2948	0.2948	0.2888	0.292	111192000.0
2001-07-23 13:00:00	NVDA	Stock	0.2921	0.2934	0.2898	0.2908	194328000.0
2001-07-23 14:00:00	NVDA	Stock	0.2908	0.2929	0.2897	0.2913	150552000.0
2001-07-23 15:00:00	NVDA	Stock	0.2901	0.2901	0.2821	0.2829	280680000.0
2001-07-23 16:00:00	NVDA	Stock	0.2825	0.2925	0.2823	0.2846	12024000.0
2001-07-23 17:00:00	NVDA	Stock	0.2825	0.2844	0.2823	0.2844	816000.0
2001-07-23 18:00:00	NVDA	Stock	0.2844	0.2863	0.2844	0.2863	432000.0
2001-07-23 08:00:00	AMZN	Stock	0.858	0.8625	0.85	0.852	280000.0
2001-07-23 09:00:00	AMZN	Stock	0.852	0.8575	0.8385	0.8455	20172000.0
2001-07-23 10:00:00	AMZN	Stock	0.845	0.8465	0.8065	0.8065	21254000.0
2001-07-23 11:00:00	AMZN	Stock	0.807	0.8075	0.799	0.804	18636000.0
2001-07-23 12:00:00	AMZN	Stock	0.804	0.82	0.802	0.8155	8246000.0
2001-07-23 13:00:00	AMZN	Stock	0.8145	0.825	0.814	0.8175	7694000.0
2001-07-23 14:00:00	AMZN	Stock	0.8185	0.8195	0.8045	0.8055	11502000.0
2001-07-23 15:00:00	AMZN	Stock	0.8055	0.815	0.798	0.802	35098000.0
2001-07-23 16:00:00	AMZN	Stock	0.8015	0.8565	0.7425	0.7525	44576000.0
2001-07-23 17:00:00	AMZN	Stock	0.752	0.76	0.75	0.7535	6560000.0
2001-07-23 18:00:00	AMZN	Stock	0.752	0.754	0.741	0.741	1700000.0
2001-07-23 09:00:00	CL	Stock	27.25	27.25	26.6	26.73	1448800.0
2001-07-23 10:00:00	CL	Stock	26.725	27.035	26.725	26.95	1705800.0
2001-07-23 11:00:00	CL	Stock	26.95	27.345	26.95	27.31	597400.0
2001-07-23 12:00:00	CL	Stock	27.335	27.42	27.175	27.3	480200.0
2001-07-23 13:00:00	CL	Stock	27.3	27.42	27.2	27.4	405400.0
2001-07-23 14:00:00	CL	Stock	27.395	27.475	27.23	27.4	453200.0
2001-07-23 15:00:00	CL	Stock	27.425	27.445	27.26	27.325	382600.0

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

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