PREVIEW / stock_1hour / 2001-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-17.parquet
  size:    375 KB
  rows:    18,887
  symbols: 1,344

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-09-17 08:00:00	AAPL	Stock	0.2768	0.3125	0.2768	0.3	666400.0
2001-09-17 09:00:00	AAPL	Stock	0.2911	0.2946	0.2813	0.292	48479200.0
2001-09-17 10:00:00	AAPL	Stock	0.293	0.3036	0.2884	0.2993	56257600.0
2001-09-17 11:00:00	AAPL	Stock	0.2991	0.3027	0.2982	0.3009	108757600.0
2001-09-17 12:00:00	AAPL	Stock	0.3009	0.3014	0.2923	0.297	45600800.0
2001-09-17 13:00:00	AAPL	Stock	0.297	0.297	0.2916	0.2963	32222400.0
2001-09-17 14:00:00	AAPL	Stock	0.2964	0.3018	0.2959	0.2995	36780800.0
2001-09-17 15:00:00	AAPL	Stock	0.2995	0.3048	0.2982	0.3036	61073600.0
2001-09-17 16:00:00	AAPL	Stock	0.3034	0.3041	0.2946	0.3034	25900000.0
2001-09-17 17:00:00	AAPL	Stock	0.3034	0.3034	0.3034	0.3034	50400.0
2001-09-17 18:00:00	AAPL	Stock	0.3034	0.3034	0.3034	0.3034	711200.0
2001-09-17 08:00:00	MSFT	Stock	27.0155	28.73	26.5	27.255	1553000.0
2001-09-17 09:00:00	MSFT	Stock	27.275	27.775	26.95	27.23	21208200.0
2001-09-17 10:00:00	MSFT	Stock	27.235	27.5	26.995	27.445	23135600.0
2001-09-17 11:00:00	MSFT	Stock	27.445	27.54	27.1	27.154	14705000.0
2001-09-17 12:00:00	MSFT	Stock	27.15	27.225	26.53	26.63	10764000.0
2001-09-17 13:00:00	MSFT	Stock	26.63	26.775	26.45	26.685	9609200.0
2001-09-17 14:00:00	MSFT	Stock	26.695	26.7305	26.4	26.525	11372000.0
2001-09-17 15:00:00	MSFT	Stock	26.52	26.8775	26.45	26.455	19403400.0
2001-09-17 16:00:00	MSFT	Stock	26.46	26.9686	26.25	26.45	6911400.0
2001-09-17 17:00:00	MSFT	Stock	26.46	26.75	26.43	26.62	163000.0
2001-09-17 18:00:00	MSFT	Stock	26.5	26.64	26.455	26.455	573000.0
2001-09-17 08:00:00	NVDA	Stock	0.3009	0.3225	0.3008	0.3079	13956000.0
2001-09-17 09:00:00	NVDA	Stock	0.3075	0.3082	0.2883	0.2883	174900000.0
2001-09-17 10:00:00	NVDA	Stock	0.2892	0.3029	0.2833	0.2985	285576000.0
2001-09-17 11:00:00	NVDA	Stock	0.2985	0.2985	0.291	0.2929	149604000.0
2001-09-17 12:00:00	NVDA	Stock	0.2929	0.2952	0.2883	0.2907	86568000.0
2001-09-17 13:00:00	NVDA	Stock	0.29	0.2929	0.2862	0.2926	70464000.0
2001-09-17 14:00:00	NVDA	Stock	0.2919	0.2933	0.2841	0.2847	84624000.0
2001-09-17 15:00:00	NVDA	Stock	0.2854	0.2875	0.2818	0.2832	153588000.0
2001-09-17 16:00:00	NVDA	Stock	0.2832	0.2852	0.2824	0.2837	9516000.0
2001-09-17 17:00:00	NVDA	Stock	0.2841	0.2842	0.2833	0.2842	276000.0
2001-09-17 18:00:00	NVDA	Stock	0.2832	0.2832	0.2832	0.2832	492000.0
2001-09-17 08:00:00	AMZN	Stock	0.4	0.417	0.3925	0.4	398000.0
2001-09-17 09:00:00	AMZN	Stock	0.4005	0.4005	0.3525	0.395	41176000.0
2001-09-17 10:00:00	AMZN	Stock	0.395	0.4025	0.3835	0.393	30974000.0
2001-09-17 11:00:00	AMZN	Stock	0.3925	0.3955	0.375	0.3875	17338000.0
2001-09-17 12:00:00	AMZN	Stock	0.3851	0.3875	0.3675	0.3695	25292000.0
2001-09-17 13:00:00	AMZN	Stock	0.3705	0.372	0.357	0.367	15814000.0
2001-09-17 14:00:00	AMZN	Stock	0.366	0.37	0.3525	0.355	20398000.0
2001-09-17 15:00:00	AMZN	Stock	0.355	0.3775	0.3545	0.375	30212000.0
2001-09-17 16:00:00	AMZN	Stock	0.375	0.3755	0.37	0.3725	4250000.0
2001-09-17 17:00:00	AMZN	Stock	0.3785	0.3785	0.37	0.37	66000.0
2001-09-17 18:00:00	AMZN	Stock	0.3745	0.375	0.3745	0.3745	130000.0
2001-09-17 09:00:00	CL	Stock	28.375	28.45	28.125	28.13	339000.0
2001-09-17 10:00:00	CL	Stock	28.13	28.575	28.0	28.28	679400.0
2001-09-17 11:00:00	CL	Stock	28.28	28.295	27.925	27.95	729800.0
2001-09-17 12:00:00	CL	Stock	27.955	28.5	27.94	28.485	457600.0
2001-09-17 13:00:00	CL	Stock	28.48	28.5	28.0	28.0	361400.0
2001-09-17 14:00:00	CL	Stock	28.0	28.125	27.975	28.04	940200.0

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

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