PREVIEW / stock_1hour / 2002-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-12.parquet
  size:    390 KB
  rows:    18,570
  symbols: 1,462

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-12 08:00:00	AAPL	Stock	0.2511	0.2511	0.2502	0.2502	21784.0
2002-09-12 09:00:00	AAPL	Stock	0.2538	0.2554	0.2521	0.2548	27556088.0
2002-09-12 10:00:00	AAPL	Stock	0.2548	0.2563	0.2532	0.255	48140680.0
2002-09-12 11:00:00	AAPL	Stock	0.255	0.257	0.2546	0.2564	15336608.0
2002-09-12 12:00:00	AAPL	Stock	0.2564	0.2564	0.2539	0.2552	26170704.0
2002-09-12 13:00:00	AAPL	Stock	0.2552	0.2561	0.253	0.2541	28659848.0
2002-09-12 14:00:00	AAPL	Stock	0.2541	0.2545	0.253	0.2536	49152656.0
2002-09-12 15:00:00	AAPL	Stock	0.2534	0.2538	0.2523	0.2523	57891232.0
2002-09-12 16:00:00	AAPL	Stock	0.2523	0.2554	0.2513	0.2525	10333624.0
2002-09-12 17:00:00	AAPL	Stock	0.2525	0.2552	0.2525	0.2525	548800.0
2002-09-12 08:00:00	MSFT	Stock	24.29	24.29	24.01	24.075	112764.0
2002-09-12 09:00:00	MSFT	Stock	24.07	24.2	23.895	23.985	11700164.0
2002-09-12 10:00:00	MSFT	Stock	23.98	23.985	23.645	23.7	12981804.0
2002-09-12 11:00:00	MSFT	Stock	23.71	23.99	23.7	23.975	7669580.0
2002-09-12 12:00:00	MSFT	Stock	23.975	23.99	23.7	23.815	5226914.0
2002-09-12 13:00:00	MSFT	Stock	23.815	23.89	23.71	23.855	4325064.0
2002-09-12 14:00:00	MSFT	Stock	23.845	23.87	23.605	23.63	7239380.0
2002-09-12 15:00:00	MSFT	Stock	23.655	23.67	23.51	23.599	11536824.0
2002-09-12 16:00:00	MSFT	Stock	23.6	23.72	23.57	23.7	1460482.0
2002-09-12 17:00:00	MSFT	Stock	23.7	23.745	23.575	23.71	127340.0
2002-09-12 18:00:00	MSFT	Stock	23.705	23.71	23.695	23.71	8010.0
2002-09-12 08:00:00	NVDA	Stock	0.0915	0.0918	0.0887	0.0908	2572080.0
2002-09-12 09:00:00	NVDA	Stock	0.0907	0.0928	0.0885	0.0927	228752880.0
2002-09-12 10:00:00	NVDA	Stock	0.0928	0.0949	0.091	0.0932	338323800.0
2002-09-12 11:00:00	NVDA	Stock	0.0932	0.0951	0.0929	0.0947	141292920.0
2002-09-12 12:00:00	NVDA	Stock	0.095	0.095	0.0923	0.0932	138887160.0
2002-09-12 13:00:00	NVDA	Stock	0.0932	0.0937	0.0923	0.0932	82939560.0
2002-09-12 14:00:00	NVDA	Stock	0.0932	0.0932	0.091	0.0912	95289240.0
2002-09-12 15:00:00	NVDA	Stock	0.0912	0.0922	0.0886	0.0894	228833160.0
2002-09-12 16:00:00	NVDA	Stock	0.0895	0.0899	0.0889	0.0895	16135680.0
2002-09-12 17:00:00	NVDA	Stock	0.0892	0.0908	0.0892	0.0895	3420000.0
2002-09-12 18:00:00	NVDA	Stock	0.0898	0.0898	0.0898	0.0898	228000.0
2002-09-12 08:00:00	AMZN	Stock	0.845	0.845	0.8435	0.8435	22000.0
2002-09-12 09:00:00	AMZN	Stock	0.8435	0.847	0.8332	0.839	10569800.0
2002-09-12 10:00:00	AMZN	Stock	0.839	0.856	0.8305	0.847	33476520.0
2002-09-12 11:00:00	AMZN	Stock	0.847	0.855	0.845	0.8545	17741880.0
2002-09-12 12:00:00	AMZN	Stock	0.855	0.855	0.8465	0.8505	14751400.0
2002-09-12 13:00:00	AMZN	Stock	0.8505	0.8565	0.8475	0.85	10788700.0
2002-09-12 14:00:00	AMZN	Stock	0.85	0.852	0.845	0.846	14468860.0
2002-09-12 15:00:00	AMZN	Stock	0.8465	0.8555	0.838	0.839	30057180.0
2002-09-12 16:00:00	AMZN	Stock	0.8385	0.84	0.8375	0.84	5132000.0
2002-09-12 17:00:00	AMZN	Stock	0.8375	0.8445	0.8375	0.838	28000.0
2002-09-12 09:00:00	CL	Stock	27.7	27.7	27.515	27.54	478000.0
2002-09-12 10:00:00	CL	Stock	27.525	27.745	27.47	27.71	496600.0
2002-09-12 11:00:00	CL	Stock	27.71	27.825	27.67	27.75	417600.0
2002-09-12 12:00:00	CL	Stock	27.735	27.75	27.4	27.615	257600.0
2002-09-12 13:00:00	CL	Stock	27.615	27.675	27.5	27.54	180800.0
2002-09-12 14:00:00	CL	Stock	27.55	27.575	27.325	27.345	281600.0
2002-09-12 15:00:00	CL	Stock	27.34	27.525	27.285	27.41	596200.0
2002-09-12 16:00:00	CL	Stock	27.425	27.45	27.42	27.45	175000.0

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

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