PREVIEW / stock_1hour / 2001-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-03-19.parquet
  size:    351 KB
  rows:    16,443
  symbols: 1,275

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-19 08:00:00	AAPL	Stock	0.3482	0.3516	0.3482	0.3516	11200.0
2001-03-19 09:00:00	AAPL	Stock	0.3583	0.3583	0.3482	0.3521	37604000.0
2001-03-19 10:00:00	AAPL	Stock	0.3527	0.3627	0.3504	0.3616	66012800.0
2001-03-19 11:00:00	AAPL	Stock	0.3627	0.3638	0.356	0.356	40292000.0
2001-03-19 12:00:00	AAPL	Stock	0.356	0.3594	0.3527	0.3583	24292800.0
2001-03-19 13:00:00	AAPL	Stock	0.3594	0.3605	0.3571	0.3605	19028800.0
2001-03-19 14:00:00	AAPL	Stock	0.3594	0.3627	0.356	0.3627	91134400.0
2001-03-19 15:00:00	AAPL	Stock	0.3627	0.3683	0.3583	0.3672	51161600.0
2001-03-19 16:00:00	AAPL	Stock	0.3683	0.375	0.3638	0.3672	8820000.0
2001-03-19 17:00:00	AAPL	Stock	0.3672	0.3672	0.3672	0.3672	868000.0
2001-03-19 18:00:00	AAPL	Stock	0.365	0.365	0.365	0.365	56000.0
2001-03-19 08:00:00	MSFT	Stock	27.0	27.4062	27.0	27.3438	71400.0
2001-03-19 09:00:00	MSFT	Stock	27.3438	27.5	27.125	27.375	6766200.0
2001-03-19 10:00:00	MSFT	Stock	27.375	27.75	27.1562	27.3125	9902400.0
2001-03-19 11:00:00	MSFT	Stock	27.2812	27.375	26.5625	26.5938	9085800.0
2001-03-19 12:00:00	MSFT	Stock	26.625	26.8438	26.5938	26.7188	5566800.0
2001-03-19 13:00:00	MSFT	Stock	26.7188	27.0625	26.7188	26.8125	4874000.0
2001-03-19 14:00:00	MSFT	Stock	26.8438	27.3125	26.8125	27.3125	7296800.0
2001-03-19 15:00:00	MSFT	Stock	27.2812	27.4062	27.0938	27.1875	12215400.0
2001-03-19 16:00:00	MSFT	Stock	27.1875	27.3438	27.0938	27.3438	2366800.0
2001-03-19 17:00:00	MSFT	Stock	27.3438	27.4062	27.1562	27.3125	263800.0
2001-03-19 18:00:00	MSFT	Stock	27.375	27.4062	27.2812	27.4062	2000.0
2001-03-19 08:00:00	NVDA	Stock	0.2487	0.2521	0.2479	0.25	912000.0
2001-03-19 09:00:00	NVDA	Stock	0.2521	0.2521	0.2419	0.2469	106416000.0
2001-03-19 10:00:00	NVDA	Stock	0.2473	0.25	0.2344	0.2372	209352000.0
2001-03-19 11:00:00	NVDA	Stock	0.2378	0.2396	0.2336	0.2346	60408000.0
2001-03-19 12:00:00	NVDA	Stock	0.2349	0.2375	0.2346	0.2354	44448000.0
2001-03-19 13:00:00	NVDA	Stock	0.2354	0.2366	0.2339	0.2365	61752000.0
2001-03-19 14:00:00	NVDA	Stock	0.2365	0.2477	0.2359	0.2469	123864000.0
2001-03-19 15:00:00	NVDA	Stock	0.2471	0.2643	0.2453	0.2625	295608000.0
2001-03-19 16:00:00	NVDA	Stock	0.2626	0.2635	0.2604	0.2604	9672000.0
2001-03-19 17:00:00	NVDA	Stock	0.263	0.263	0.2625	0.2625	120000.0
2001-03-19 18:00:00	NVDA	Stock	0.2625	0.2625	0.2625	0.2625	24000.0
2001-03-19 08:00:00	AMZN	Stock	0.5594	0.5625	0.55	0.5625	118000.0
2001-03-19 09:00:00	AMZN	Stock	0.5625	0.5656	0.5438	0.55	11904000.0
2001-03-19 10:00:00	AMZN	Stock	0.55	0.5594	0.5375	0.5375	15512000.0
2001-03-19 11:00:00	AMZN	Stock	0.5406	0.5406	0.5094	0.5188	21592000.0
2001-03-19 12:00:00	AMZN	Stock	0.5156	0.5219	0.5125	0.5188	12802000.0
2001-03-19 13:00:00	AMZN	Stock	0.5188	0.5188	0.5062	0.5156	11934000.0
2001-03-19 14:00:00	AMZN	Stock	0.5188	0.5219	0.5062	0.5156	14984000.0
2001-03-19 15:00:00	AMZN	Stock	0.5188	0.5281	0.5156	0.5219	32306000.0
2001-03-19 16:00:00	AMZN	Stock	0.5219	0.55	0.5094	0.5219	8712000.0
2001-03-19 17:00:00	AMZN	Stock	0.5219	0.525	0.5219	0.5219	72000.0
2001-03-19 18:00:00	AMZN	Stock	0.5219	0.5219	0.5219	0.5219	4000.0
2001-03-19 09:00:00	CL	Stock	27.0	27.005	26.75	26.86	247000.0
2001-03-19 10:00:00	CL	Stock	26.87	27.0	26.74	27.0	402600.0
2001-03-19 11:00:00	CL	Stock	26.99	27.165	26.85	26.895	371800.0
2001-03-19 12:00:00	CL	Stock	26.895	27.0	26.875	26.94	229800.0
2001-03-19 13:00:00	CL	Stock	26.94	26.965	26.83	26.83	265000.0
2001-03-19 14:00:00	CL	Stock	26.825	26.9	26.69	26.85	532600.0

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

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