PREVIEW / stock_1hour / 2001-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-25.parquet
  size:    313 KB
  rows:    15,971
  symbols: 1,253

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-01-25 08:00:00	AAPL	Stock	0.3672	0.3672	0.3661	0.3672	112000.0
2001-01-25 09:00:00	AAPL	Stock	0.3672	0.3683	0.3583	0.3605	23760800.0
2001-01-25 10:00:00	AAPL	Stock	0.3616	0.3627	0.3594	0.3616	63991200.0
2001-01-25 11:00:00	AAPL	Stock	0.3616	0.3638	0.3571	0.3616	74737600.0
2001-01-25 12:00:00	AAPL	Stock	0.3616	0.3616	0.356	0.3571	30447200.0
2001-01-25 13:00:00	AAPL	Stock	0.3571	0.3583	0.3538	0.356	43584800.0
2001-01-25 14:00:00	AAPL	Stock	0.3549	0.3571	0.3527	0.356	85909600.0
2001-01-25 15:00:00	AAPL	Stock	0.3549	0.356	0.3527	0.3549	58279200.0
2001-01-25 16:00:00	AAPL	Stock	0.356	0.3571	0.3549	0.356	14246400.0
2001-01-25 17:00:00	AAPL	Stock	0.356	0.3571	0.3549	0.3549	660800.0
2001-01-25 18:00:00	AAPL	Stock	0.3527	0.356	0.3527	0.3527	100800.0
2001-01-25 08:00:00	MSFT	Stock	31.5	31.6562	31.25	31.4062	59800.0
2001-01-25 09:00:00	MSFT	Stock	31.4062	32.5	31.3125	31.9062	10138800.0
2001-01-25 10:00:00	MSFT	Stock	31.9062	32.0	31.4062	31.5	15305000.0
2001-01-25 11:00:00	MSFT	Stock	31.4688	31.875	31.3438	31.75	12531000.0
2001-01-25 12:00:00	MSFT	Stock	31.75	31.75	31.4062	31.5	5435600.0
2001-01-25 13:00:00	MSFT	Stock	31.5	31.7812	31.4062	31.4688	7465400.0
2001-01-25 14:00:00	MSFT	Stock	31.5	31.5	30.7812	30.9375	12665000.0
2001-01-25 15:00:00	MSFT	Stock	30.9375	31.0938	30.8438	30.9688	9986800.0
2001-01-25 16:00:00	MSFT	Stock	30.9062	31.9688	30.75	30.9062	2404800.0
2001-01-25 17:00:00	MSFT	Stock	30.8438	30.9062	30.4375	30.4688	100800.0
2001-01-25 18:00:00	MSFT	Stock	30.5	30.5	29.9062	30.0	100000.0
2001-01-25 09:00:00	NVDA	Stock	0.225	0.2263	0.2151	0.2188	32880000.0
2001-01-25 10:00:00	NVDA	Stock	0.219	0.2208	0.2125	0.213	59880000.0
2001-01-25 11:00:00	NVDA	Stock	0.2128	0.218	0.2104	0.2159	47856000.0
2001-01-25 12:00:00	NVDA	Stock	0.2156	0.2167	0.2126	0.2146	14064000.0
2001-01-25 13:00:00	NVDA	Stock	0.2146	0.2182	0.2128	0.2141	36648000.0
2001-01-25 14:00:00	NVDA	Stock	0.2141	0.2151	0.2042	0.2052	88464000.0
2001-01-25 15:00:00	NVDA	Stock	0.2052	0.2068	0.2005	0.2044	114552000.0
2001-01-25 16:00:00	NVDA	Stock	0.2052	0.2055	0.2042	0.2052	2232000.0
2001-01-25 17:00:00	NVDA	Stock	0.2042	0.2042	0.2036	0.2042	240000.0
2001-01-25 18:00:00	NVDA	Stock	0.2042	0.2063	0.2042	0.2063	240000.0
2001-01-25 08:00:00	AMZN	Stock	1.075	1.0938	1.075	1.0812	78000.0
2001-01-25 09:00:00	AMZN	Stock	1.075	1.0906	1.0375	1.05	16682000.0
2001-01-25 10:00:00	AMZN	Stock	1.05	1.0531	1.0031	1.0062	25474000.0
2001-01-25 11:00:00	AMZN	Stock	1.0062	1.025	1.0062	1.0188	10452000.0
2001-01-25 12:00:00	AMZN	Stock	1.0188	1.0188	1.0062	1.0125	12214000.0
2001-01-25 13:00:00	AMZN	Stock	1.0156	1.0156	0.9938	0.9969	13370000.0
2001-01-25 14:00:00	AMZN	Stock	0.9969	1.0031	0.9625	0.975	19984000.0
2001-01-25 15:00:00	AMZN	Stock	0.975	0.9875	0.95	0.9531	23000000.0
2001-01-25 16:00:00	AMZN	Stock	0.95	0.9719	0.9438	0.9438	2432000.0
2001-01-25 17:00:00	AMZN	Stock	0.9625	0.9625	0.9438	0.9469	114000.0
2001-01-25 18:00:00	AMZN	Stock	0.9438	0.9438	0.925	0.925	30000.0
2001-01-25 09:00:00	CL	Stock	28.65	28.7	28.53	28.53	240000.0
2001-01-25 10:00:00	CL	Stock	28.545	28.59	28.13	28.24	459400.0
2001-01-25 11:00:00	CL	Stock	28.235	28.75	28.215	28.75	292600.0
2001-01-25 12:00:00	CL	Stock	28.725	28.775	28.475	28.535	147000.0
2001-01-25 13:00:00	CL	Stock	28.54	28.99	28.535	28.915	479600.0
2001-01-25 14:00:00	CL	Stock	28.94	29.09	28.875	29.075	308000.0
2001-01-25 15:00:00	CL	Stock	29.085	29.375	29.075	29.22	728200.0

> showing 50 of 15,971 rows — these rows as CSV

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