PREVIEW / stock_1hour / 2002-03-04

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-03-04.parquet
  size:    405 KB
  rows:    18,896
  symbols: 1,404

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-03-04 08:00:00	AAPL	Stock	0.4188	0.4188	0.4171	0.4188	431200.0
2002-03-04 09:00:00	AAPL	Stock	0.4184	0.4188	0.4064	0.4095	33448800.0
2002-03-04 10:00:00	AAPL	Stock	0.4098	0.4223	0.4095	0.4186	47544000.0
2002-03-04 11:00:00	AAPL	Stock	0.4184	0.422	0.4134	0.4163	29848000.0
2002-03-04 12:00:00	AAPL	Stock	0.4161	0.4234	0.415	0.423	24612000.0
2002-03-04 13:00:00	AAPL	Stock	0.4223	0.423	0.4191	0.4221	43932000.0
2002-03-04 14:00:00	AAPL	Stock	0.4221	0.433	0.4202	0.4321	60816000.0
2002-03-04 15:00:00	AAPL	Stock	0.4321	0.4382	0.4291	0.4341	64114400.0
2002-03-04 16:00:00	AAPL	Stock	0.4341	0.4384	0.4171	0.4171	13524000.0
2002-03-04 17:00:00	AAPL	Stock	0.4337	0.4338	0.4337	0.4338	403200.0
2002-03-04 18:00:00	AAPL	Stock	0.4363	0.4363	0.4357	0.4357	84000.0
2002-03-04 08:00:00	MSFT	Stock	30.65	30.7	30.375	30.525	153000.0
2002-03-04 09:00:00	MSFT	Stock	30.55	30.895	30.4395	30.775	10947000.0
2002-03-04 10:00:00	MSFT	Stock	30.775	31.515	30.75	31.375	17962800.0
2002-03-04 11:00:00	MSFT	Stock	31.37	31.65	31.205	31.42	8452000.0
2002-03-04 12:00:00	MSFT	Stock	31.425	31.72	31.3645	31.6255	7074200.0
2002-03-04 13:00:00	MSFT	Stock	31.6252	31.645	31.3	31.4505	4830000.0
2002-03-04 14:00:00	MSFT	Stock	31.455	31.735	31.375	31.475	7629600.0
2002-03-04 15:00:00	MSFT	Stock	31.49	31.65	31.375	31.65	11157400.0
2002-03-04 16:00:00	MSFT	Stock	31.64	31.695	29.83	31.65	3135200.0
2002-03-04 17:00:00	MSFT	Stock	31.67	31.675	31.25	31.645	173600.0
2002-03-04 18:00:00	MSFT	Stock	31.745	31.745	31.61	31.61	2600.0
2002-03-04 08:00:00	NVDA	Stock	0.4667	0.475	0.4667	0.4667	1584000.0
2002-03-04 09:00:00	NVDA	Stock	0.4667	0.4758	0.4631	0.4713	160392000.0
2002-03-04 10:00:00	NVDA	Stock	0.4716	0.4833	0.4702	0.4802	304380000.0
2002-03-04 11:00:00	NVDA	Stock	0.48	0.4817	0.4759	0.4783	137004000.0
2002-03-04 12:00:00	NVDA	Stock	0.4786	0.4905	0.4775	0.4887	207180000.0
2002-03-04 13:00:00	NVDA	Stock	0.4887	0.4897	0.4823	0.4875	127236000.0
2002-03-04 14:00:00	NVDA	Stock	0.4875	0.4975	0.4864	0.4945	216540000.0
2002-03-04 15:00:00	NVDA	Stock	0.4954	0.4974	0.4883	0.4917	234300000.0
2002-03-04 16:00:00	NVDA	Stock	0.4918	0.4922	0.4836	0.4921	18300000.0
2002-03-04 17:00:00	NVDA	Stock	0.4921	0.4929	0.4921	0.4929	408000.0
2002-03-04 18:00:00	NVDA	Stock	0.4945	0.4946	0.4942	0.4942	192000.0
2002-03-04 08:00:00	AMZN	Stock	0.77	0.7775	0.7695	0.775	300000.0
2002-03-04 09:00:00	AMZN	Stock	0.7775	0.7925	0.77	0.7825	41742000.0
2002-03-04 10:00:00	AMZN	Stock	0.782	0.7905	0.7782	0.78	40750000.0
2002-03-04 11:00:00	AMZN	Stock	0.7805	0.79	0.7785	0.7875	20206000.0
2002-03-04 12:00:00	AMZN	Stock	0.7885	0.811	0.787	0.8055	46140000.0
2002-03-04 13:00:00	AMZN	Stock	0.8055	0.81	0.79	0.8036	31166000.0
2002-03-04 14:00:00	AMZN	Stock	0.8035	0.8125	0.8	0.8085	25322000.0
2002-03-04 15:00:00	AMZN	Stock	0.8085	0.8245	0.804	0.8235	46966000.0
2002-03-04 16:00:00	AMZN	Stock	0.8225	0.8265	0.82	0.824	7432000.0
2002-03-04 17:00:00	AMZN	Stock	0.825	0.8275	0.8239	0.824	354000.0
2002-03-04 18:00:00	AMZN	Stock	0.825	0.825	0.825	0.825	2000.0
2002-03-04 09:00:00	CL	Stock	28.475	28.475	28.29	28.33	292800.0
2002-03-04 10:00:00	CL	Stock	28.35	28.375	28.115	28.115	459400.0
2002-03-04 11:00:00	CL	Stock	28.11	28.2	28.065	28.15	377600.0
2002-03-04 12:00:00	CL	Stock	28.14	28.22	28.11	28.11	141000.0
2002-03-04 13:00:00	CL	Stock	28.105	28.115	27.975	27.995	330400.0
2002-03-04 14:00:00	CL	Stock	27.995	28.04	27.925	28.01	443400.0

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

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