PREVIEW / stock_1hour / 2002-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-18.parquet
  size:    395 KB
  rows:    18,805
  symbols: 1,484

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-18 08:00:00	AAPL	Stock	0.262	0.2625	0.2602	0.2618	60200.0
2002-09-18 09:00:00	AAPL	Stock	0.2611	0.2634	0.2604	0.2618	44102072.0
2002-09-18 10:00:00	AAPL	Stock	0.2618	0.263	0.2593	0.2621	42793184.0
2002-09-18 11:00:00	AAPL	Stock	0.2625	0.2641	0.2623	0.263	40961760.0
2002-09-18 12:00:00	AAPL	Stock	0.263	0.2643	0.2625	0.2627	19568696.0
2002-09-18 13:00:00	AAPL	Stock	0.2634	0.2663	0.2629	0.2661	38911936.0
2002-09-18 14:00:00	AAPL	Stock	0.2663	0.2688	0.2652	0.2686	57402968.0
2002-09-18 15:00:00	AAPL	Stock	0.2686	0.2695	0.2666	0.268	80725344.0
2002-09-18 16:00:00	AAPL	Stock	0.268	0.2688	0.2646	0.2657	2571856.0
2002-09-18 17:00:00	AAPL	Stock	0.2643	0.2687	0.2638	0.2682	1596000.0
2002-09-18 18:00:00	AAPL	Stock	0.2613	0.2682	0.2589	0.2682	122752.0
2002-09-18 08:00:00	MSFT	Stock	23.4	23.5	23.115	23.32	217400.0
2002-09-18 09:00:00	MSFT	Stock	23.3	23.75	23.3	23.66	13604214.0
2002-09-18 10:00:00	MSFT	Stock	23.665	23.675	23.33	23.355	17541700.0
2002-09-18 11:00:00	MSFT	Stock	23.36	23.55	23.35	23.505	7520928.0
2002-09-18 12:00:00	MSFT	Stock	23.51	23.685	23.483	23.495	6064210.0
2002-09-18 13:00:00	MSFT	Stock	23.5	23.775	23.49	23.735	7724470.0
2002-09-18 14:00:00	MSFT	Stock	23.7345	24.025	23.679	23.975	13194556.0
2002-09-18 15:00:00	MSFT	Stock	23.975	24.12	23.685	23.895	15397118.0
2002-09-18 16:00:00	MSFT	Stock	23.88	23.9	23.0	23.62	1451270.0
2002-09-18 17:00:00	MSFT	Stock	23.625	23.875	23.475	23.49	309612.0
2002-09-18 18:00:00	MSFT	Stock	23.495	23.875	23.45	23.5	88822.0
2002-09-18 08:00:00	NVDA	Stock	0.0792	0.0792	0.0791	0.0791	1250400.0
2002-09-18 09:00:00	NVDA	Stock	0.079	0.0816	0.0788	0.0806	90447360.0
2002-09-18 10:00:00	NVDA	Stock	0.0806	0.0806	0.0776	0.0782	136341000.0
2002-09-18 11:00:00	NVDA	Stock	0.0782	0.079	0.0767	0.0774	133593840.0
2002-09-18 12:00:00	NVDA	Stock	0.0775	0.0787	0.0769	0.0772	64258680.0
2002-09-18 13:00:00	NVDA	Stock	0.0772	0.0787	0.0771	0.0782	86233320.0
2002-09-18 14:00:00	NVDA	Stock	0.0783	0.0804	0.078	0.0799	113373120.0
2002-09-18 15:00:00	NVDA	Stock	0.0799	0.0811	0.0787	0.079	112902960.0
2002-09-18 16:00:00	NVDA	Stock	0.0789	0.0792	0.0775	0.0776	20328240.0
2002-09-18 17:00:00	NVDA	Stock	0.0776	0.079	0.0772	0.0777	2796000.0
2002-09-18 18:00:00	NVDA	Stock	0.0778	0.079	0.0776	0.079	648000.0
2002-09-18 08:00:00	AMZN	Stock	0.86	0.86	0.8586	0.8586	40000.0
2002-09-18 09:00:00	AMZN	Stock	0.8655	0.885	0.86	0.877	24478520.0
2002-09-18 10:00:00	AMZN	Stock	0.8765	0.8785	0.8686	0.869	27392620.0
2002-09-18 11:00:00	AMZN	Stock	0.869	0.874	0.867	0.8686	14452640.0
2002-09-18 12:00:00	AMZN	Stock	0.8686	0.87	0.8645	0.8675	15734480.0
2002-09-18 13:00:00	AMZN	Stock	0.8675	0.875	0.867	0.8725	14207800.0
2002-09-18 14:00:00	AMZN	Stock	0.8725	0.895	0.8725	0.889	25923960.0
2002-09-18 15:00:00	AMZN	Stock	0.889	0.8965	0.875	0.8841	30128220.0
2002-09-18 16:00:00	AMZN	Stock	0.884	0.8875	0.8655	0.875	10510560.0
2002-09-18 17:00:00	AMZN	Stock	0.875	0.8775	0.873	0.8775	225040.0
2002-09-18 18:00:00	AMZN	Stock	0.8745	0.8865	0.8745	0.8865	586000.0
2002-09-18 09:00:00	CL	Stock	27.125	27.32	27.125	27.29	266600.0
2002-09-18 10:00:00	CL	Stock	27.285	27.435	27.2	27.21	496600.0
2002-09-18 11:00:00	CL	Stock	27.21	27.225	26.97	26.975	406600.0
2002-09-18 12:00:00	CL	Stock	26.97	27.16	26.955	27.11	371800.0
2002-09-18 13:00:00	CL	Stock	27.11	27.24	27.005	27.095	215400.0
2002-09-18 14:00:00	CL	Stock	27.1	27.275	27.09	27.265	351600.0

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

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