PREVIEW / stock_1hour / 2001-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-03-07.parquet
  size:    351 KB
  rows:    16,475
  symbols: 1,266

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-03-07 08:00:00	AAPL	Stock	0.3817	0.3929	0.3817	0.3929	1030400.0
2001-03-07 09:00:00	AAPL	Stock	0.3906	0.3917	0.375	0.3806	52264800.0
2001-03-07 10:00:00	AAPL	Stock	0.3795	0.3828	0.375	0.3795	48742400.0
2001-03-07 11:00:00	AAPL	Stock	0.3806	0.3828	0.3761	0.3772	35218400.0
2001-03-07 12:00:00	AAPL	Stock	0.3772	0.3772	0.3705	0.3728	67373600.0
2001-03-07 13:00:00	AAPL	Stock	0.3728	0.3806	0.3728	0.3783	107816800.0
2001-03-07 14:00:00	AAPL	Stock	0.3783	0.3817	0.375	0.3761	37542400.0
2001-03-07 15:00:00	AAPL	Stock	0.3761	0.3795	0.3705	0.3795	46166400.0
2001-03-07 16:00:00	AAPL	Stock	0.3783	0.3795	0.375	0.3761	4911200.0
2001-03-07 17:00:00	AAPL	Stock	0.3795	0.3795	0.3739	0.3739	347200.0
2001-03-07 18:00:00	AAPL	Stock	0.375	0.375	0.375	0.375	11200.0
2001-03-07 08:00:00	MSFT	Stock	29.5	30.125	29.5	30.0625	134600.0
2001-03-07 09:00:00	MSFT	Stock	30.0625	30.125	29.6562	29.7188	8750800.0
2001-03-07 10:00:00	MSFT	Stock	29.7188	30.2656	29.6875	30.125	13057600.0
2001-03-07 11:00:00	MSFT	Stock	30.1562	30.25	29.8125	29.9375	7552600.0
2001-03-07 12:00:00	MSFT	Stock	29.9375	30.3125	29.9062	30.1875	5240600.0
2001-03-07 13:00:00	MSFT	Stock	30.2188	30.5	30.1875	30.3438	5560800.0
2001-03-07 14:00:00	MSFT	Stock	30.3438	30.375	30.0938	30.2812	3165400.0
2001-03-07 15:00:00	MSFT	Stock	30.2812	30.5625	30.1562	30.3125	12028800.0
2001-03-07 16:00:00	MSFT	Stock	30.3125	30.3438	30.125	30.3438	1367400.0
2001-03-07 17:00:00	MSFT	Stock	30.3438	30.3438	29.9688	30.1875	206000.0
2001-03-07 18:00:00	MSFT	Stock	30.1875	30.3125	30.1875	30.25	5600.0
2001-03-07 09:00:00	NVDA	Stock	0.2033	0.2073	0.2033	0.2052	143952000.0
2001-03-07 10:00:00	NVDA	Stock	0.2052	0.2125	0.2018	0.2073	187152000.0
2001-03-07 11:00:00	NVDA	Stock	0.2081	0.2104	0.2018	0.2044	83088000.0
2001-03-07 12:00:00	NVDA	Stock	0.2044	0.2156	0.2042	0.213	89544000.0
2001-03-07 13:00:00	NVDA	Stock	0.213	0.2174	0.2125	0.2159	93480000.0
2001-03-07 14:00:00	NVDA	Stock	0.2159	0.2161	0.2104	0.2128	154152000.0
2001-03-07 15:00:00	NVDA	Stock	0.2128	0.2177	0.2125	0.2177	153648000.0
2001-03-07 16:00:00	NVDA	Stock	0.2174	0.2174	0.2138	0.2172	3768000.0
2001-03-07 17:00:00	NVDA	Stock	0.2156	0.2156	0.2156	0.2156	24000.0
2001-03-07 18:00:00	NVDA	Stock	0.2167	0.2167	0.2167	0.2167	360000.0
2001-03-07 08:00:00	AMZN	Stock	0.5875	0.6125	0.5594	0.6125	916000.0
2001-03-07 09:00:00	AMZN	Stock	0.6109	0.6109	0.5719	0.5969	41024000.0
2001-03-07 10:00:00	AMZN	Stock	0.5969	0.6281	0.5875	0.5938	37230000.0
2001-03-07 11:00:00	AMZN	Stock	0.5938	0.6094	0.5906	0.6	25418000.0
2001-03-07 12:00:00	AMZN	Stock	0.6	0.6063	0.5969	0.6	14350000.0
2001-03-07 13:00:00	AMZN	Stock	0.6	0.6063	0.5953	0.6031	20508000.0
2001-03-07 14:00:00	AMZN	Stock	0.6047	0.625	0.5969	0.6063	27878000.0
2001-03-07 15:00:00	AMZN	Stock	0.6063	0.6125	0.6	0.6094	30946000.0
2001-03-07 16:00:00	AMZN	Stock	0.6094	0.6188	0.5844	0.6016	7158000.0
2001-03-07 17:00:00	AMZN	Stock	0.6125	0.6125	0.5938	0.6109	426000.0
2001-03-07 18:00:00	AMZN	Stock	0.6125	0.6125	0.6063	0.6063	54000.0
2001-03-07 09:00:00	CL	Stock	28.6	28.95	28.6	28.925	241200.0
2001-03-07 10:00:00	CL	Stock	28.93	29.55	28.905	29.365	811800.0
2001-03-07 11:00:00	CL	Stock	29.355	29.355	29.025	29.26	511000.0
2001-03-07 12:00:00	CL	Stock	29.265	29.33	29.2	29.225	287400.0
2001-03-07 13:00:00	CL	Stock	29.2	29.25	29.15	29.17	241400.0
2001-03-07 14:00:00	CL	Stock	29.17	29.19	28.935	28.975	433000.0
2001-03-07 15:00:00	CL	Stock	28.975	29.11	28.875	29.08	729000.0

> showing 50 of 16,475 rows — these rows as CSV

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