PREVIEW / stock_1hour / 2002-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-13.parquet
  size:    383 KB
  rows:    18,283
  symbols: 1,464

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
2002-09-13 08:00:00	AAPL	Stock	0.2525	0.2527	0.2525	0.2527	487200.0
2002-09-13 09:00:00	AAPL	Stock	0.2532	0.2559	0.2521	0.2546	44186296.0
2002-09-13 10:00:00	AAPL	Stock	0.2546	0.2561	0.2523	0.253	52565240.0
2002-09-13 11:00:00	AAPL	Stock	0.2529	0.2552	0.2513	0.2539	52151568.0
2002-09-13 12:00:00	AAPL	Stock	0.2538	0.2543	0.2518	0.2525	36437352.0
2002-09-13 13:00:00	AAPL	Stock	0.2525	0.2536	0.2518	0.252	12913936.0
2002-09-13 14:00:00	AAPL	Stock	0.2521	0.2536	0.2509	0.2529	24939936.0
2002-09-13 15:00:00	AAPL	Stock	0.253	0.2545	0.252	0.2532	44635920.0
2002-09-13 16:00:00	AAPL	Stock	0.2536	0.2538	0.2527	0.2534	4373600.0
2002-09-13 17:00:00	AAPL	Stock	0.253	0.253	0.2521	0.2521	1075200.0
2002-09-13 08:00:00	MSFT	Stock	23.5	23.59	23.25	23.425	266598.0
2002-09-13 09:00:00	MSFT	Stock	23.425	23.845	23.38	23.8	9990736.0
2002-09-13 10:00:00	MSFT	Stock	23.8	24.13	23.68	23.785	14669252.0
2002-09-13 11:00:00	MSFT	Stock	23.79	23.875	23.525	23.85	8269490.0
2002-09-13 12:00:00	MSFT	Stock	23.8505	23.965	23.745	23.935	4142462.0
2002-09-13 13:00:00	MSFT	Stock	23.94	24.025	23.83	23.855	5148088.0
2002-09-13 14:00:00	MSFT	Stock	23.855	23.95	23.71	23.87	5500780.0
2002-09-13 15:00:00	MSFT	Stock	23.87	24.025	23.805	23.95	9022946.0
2002-09-13 16:00:00	MSFT	Stock	23.9445	24.01	23.45	23.965	1472620.0
2002-09-13 17:00:00	MSFT	Stock	23.975	24.005	23.95	23.97	164750.0
2002-09-13 18:00:00	MSFT	Stock	23.95	23.97	23.95	23.97	3308.0
2002-09-13 08:00:00	NVDA	Stock	0.0886	0.0894	0.0875	0.0884	2739120.0
2002-09-13 09:00:00	NVDA	Stock	0.0883	0.0904	0.0881	0.0903	146221080.0
2002-09-13 10:00:00	NVDA	Stock	0.0902	0.0928	0.0894	0.0901	232640640.0
2002-09-13 11:00:00	NVDA	Stock	0.09	0.09	0.0888	0.0897	65756280.0
2002-09-13 12:00:00	NVDA	Stock	0.0896	0.0904	0.0892	0.0898	40207080.0
2002-09-13 13:00:00	NVDA	Stock	0.0898	0.0907	0.089	0.089	59974200.0
2002-09-13 14:00:00	NVDA	Stock	0.0891	0.0894	0.0876	0.088	70169400.0
2002-09-13 15:00:00	NVDA	Stock	0.088	0.089	0.0877	0.088	161652600.0
2002-09-13 16:00:00	NVDA	Stock	0.0882	0.0918	0.0877	0.0884	10506000.0
2002-09-13 17:00:00	NVDA	Stock	0.0881	0.0887	0.0881	0.0886	3665400.0
2002-09-13 08:00:00	AMZN	Stock	0.8255	0.8364	0.825	0.831	40000.0
2002-09-13 09:00:00	AMZN	Stock	0.8274	0.84	0.8274	0.84	11466140.0
2002-09-13 10:00:00	AMZN	Stock	0.8396	0.8495	0.8355	0.8375	17858080.0
2002-09-13 11:00:00	AMZN	Stock	0.8375	0.841	0.8315	0.8395	10146900.0
2002-09-13 12:00:00	AMZN	Stock	0.8395	0.841	0.835	0.8405	5084580.0
2002-09-13 13:00:00	AMZN	Stock	0.8405	0.8415	0.8325	0.836	6059720.0
2002-09-13 14:00:00	AMZN	Stock	0.8365	0.8375	0.8305	0.8316	4809740.0
2002-09-13 15:00:00	AMZN	Stock	0.832	0.834	0.825	0.834	14008180.0
2002-09-13 16:00:00	AMZN	Stock	0.834	0.8375	0.8305	0.8365	1331000.0
2002-09-13 17:00:00	AMZN	Stock	0.8305	0.8305	0.8305	0.8305	718000.0
2002-09-13 18:00:00	AMZN	Stock	0.833	0.8365	0.833	0.8365	6000.0
2002-09-13 09:00:00	CL	Stock	27.3	27.325	27.1	27.12	277600.0
2002-09-13 10:00:00	CL	Stock	27.12	27.425	27.05	27.375	602800.0
2002-09-13 11:00:00	CL	Stock	27.385	27.61	27.38	27.61	335800.0
2002-09-13 12:00:00	CL	Stock	27.605	27.65	27.5	27.625	222000.0
2002-09-13 13:00:00	CL	Stock	27.64	27.75	27.545	27.585	227800.0
2002-09-13 14:00:00	CL	Stock	27.595	27.63	27.45	27.525	378000.0
2002-09-13 15:00:00	CL	Stock	27.525	27.875	27.5	27.66	576800.0
2002-09-13 16:00:00	CL	Stock	27.66	27.75	27.66	27.75	84200.0

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

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