PREVIEW / stock_1hour / 2003-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-01-17.parquet
  size:    405 KB
  rows:    19,593
  symbols: 1,522

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
2003-01-17 08:00:00	AAPL	Stock	0.2575	0.2604	0.2575	0.2589	369600.0
2003-01-17 09:00:00	AAPL	Stock	0.2596	0.2602	0.2543	0.255	55196904.0
2003-01-17 10:00:00	AAPL	Stock	0.255	0.2577	0.2545	0.2554	46867296.0
2003-01-17 11:00:00	AAPL	Stock	0.2555	0.2557	0.2538	0.2539	26251400.0
2003-01-17 12:00:00	AAPL	Stock	0.2541	0.2554	0.253	0.2548	17309992.0
2003-01-17 13:00:00	AAPL	Stock	0.255	0.2554	0.2525	0.2529	23810248.0
2003-01-17 14:00:00	AAPL	Stock	0.253	0.2562	0.2527	0.2557	28483224.0
2003-01-17 15:00:00	AAPL	Stock	0.2555	0.2557	0.2516	0.252	34820464.0
2003-01-17 16:00:00	AAPL	Stock	0.2514	0.2563	0.2514	0.2545	7016800.0
2003-01-17 17:00:00	AAPL	Stock	0.2518	0.2518	0.2518	0.2518	5196800.0
2003-01-17 08:00:00	MSFT	Stock	26.385	27.67	26.125	26.335	4598668.0
2003-01-17 09:00:00	MSFT	Stock	26.325	26.8	26.25	26.325	30300910.0
2003-01-17 10:00:00	MSFT	Stock	26.325	26.47	26.265	26.29	24281586.0
2003-01-17 11:00:00	MSFT	Stock	26.29	26.31	26.2	26.22	15673036.0
2003-01-17 12:00:00	MSFT	Stock	26.22	26.355	26.215	26.34	11888776.0
2003-01-17 13:00:00	MSFT	Stock	26.34	26.35	26.11	26.12	13987062.0
2003-01-17 14:00:00	MSFT	Stock	26.12	26.125	25.95	26.09	16339760.0
2003-01-17 15:00:00	MSFT	Stock	26.09	26.09	25.655	25.725	24954050.0
2003-01-17 16:00:00	MSFT	Stock	25.73	26.435	25.67	25.74	2556502.0
2003-01-17 17:00:00	MSFT	Stock	25.735	25.775	25.73	25.76	829712.0
2003-01-17 18:00:00	MSFT	Stock	25.76	25.775	25.725	25.725	31934.0
2003-01-17 08:00:00	NVDA	Stock	0.0896	0.0896	0.0882	0.0889	4884840.0
2003-01-17 09:00:00	NVDA	Stock	0.0892	0.0927	0.0892	0.0912	220244880.0
2003-01-17 10:00:00	NVDA	Stock	0.0912	0.0918	0.0901	0.0903	158448720.0
2003-01-17 11:00:00	NVDA	Stock	0.0903	0.0904	0.0896	0.0904	99928200.0
2003-01-17 12:00:00	NVDA	Stock	0.0904	0.091	0.0895	0.0899	134461200.0
2003-01-17 13:00:00	NVDA	Stock	0.09	0.09	0.0893	0.0895	59587920.0
2003-01-17 14:00:00	NVDA	Stock	0.0894	0.09	0.0894	0.0899	53301000.0
2003-01-17 15:00:00	NVDA	Stock	0.0898	0.0904	0.0884	0.0897	216638160.0
2003-01-17 16:00:00	NVDA	Stock	0.0897	0.0903	0.0894	0.09	24680040.0
2003-01-17 17:00:00	NVDA	Stock	0.0898	0.0902	0.0896	0.09	5005200.0
2003-01-17 18:00:00	NVDA	Stock	0.0899	0.0899	0.0898	0.0898	744000.0
2003-01-17 08:00:00	AMZN	Stock	1.075	1.092	1.0725	1.075	242000.0
2003-01-17 09:00:00	AMZN	Stock	1.0756	1.087	1.0615	1.067	23463400.0
2003-01-17 10:00:00	AMZN	Stock	1.067	1.0855	1.066	1.076	21587800.0
2003-01-17 11:00:00	AMZN	Stock	1.0765	1.0795	1.069	1.0735	15508600.0
2003-01-17 12:00:00	AMZN	Stock	1.073	1.081	1.073	1.08	6408600.0
2003-01-17 13:00:00	AMZN	Stock	1.08	1.0801	1.074	1.078	10589260.0
2003-01-17 14:00:00	AMZN	Stock	1.079	1.0815	1.0755	1.079	7670380.0
2003-01-17 15:00:00	AMZN	Stock	1.079	1.08	1.0705	1.073	14867740.0
2003-01-17 16:00:00	AMZN	Stock	1.0725	1.075	1.0605	1.072	2229540.0
2003-01-17 17:00:00	AMZN	Stock	1.0675	1.07	1.0675	1.07	1078000.0
2003-01-17 18:00:00	AMZN	Stock	1.0715	1.072	1.07	1.07	40000.0
2003-01-17 09:00:00	CL	Stock	27.005	27.31	27.005	27.24	462200.0
2003-01-17 10:00:00	CL	Stock	27.235	27.24	26.8	26.8	457400.0
2003-01-17 11:00:00	CL	Stock	26.8	26.875	26.775	26.87	343200.0
2003-01-17 12:00:00	CL	Stock	26.875	27.0	26.86	26.985	192200.0
2003-01-17 13:00:00	CL	Stock	26.985	27.08	26.925	26.95	555600.0
2003-01-17 14:00:00	CL	Stock	26.95	26.95	26.86	26.915	500400.0
2003-01-17 15:00:00	CL	Stock	26.915	26.95	26.9	26.9	740400.0

> showing 50 of 19,593 rows — these rows as CSV

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