PREVIEW / stock_1hour / 2002-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-03-18.parquet
  size:    392 KB
  rows:    18,645
  symbols: 1,405

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-18 08:00:00	AAPL	Stock	0.4464	0.4473	0.4464	0.4468	134400.0
2002-03-18 09:00:00	AAPL	Stock	0.4484	0.4484	0.4425	0.4455	18110400.0
2002-03-18 10:00:00	AAPL	Stock	0.4454	0.4455	0.4402	0.4411	20972000.0
2002-03-18 11:00:00	AAPL	Stock	0.4414	0.4418	0.4357	0.4373	41003200.0
2002-03-18 12:00:00	AAPL	Stock	0.4373	0.44	0.4373	0.4386	27165600.0
2002-03-18 13:00:00	AAPL	Stock	0.4386	0.4396	0.4361	0.4363	34025600.0
2002-03-18 14:00:00	AAPL	Stock	0.4364	0.4382	0.4343	0.4366	48753600.0
2002-03-18 15:00:00	AAPL	Stock	0.4366	0.4429	0.4364	0.4416	44945600.0
2002-03-18 16:00:00	AAPL	Stock	0.4418	0.4438	0.4395	0.4417	7985600.0
2002-03-18 17:00:00	AAPL	Stock	0.4402	0.4402	0.4402	0.4402	56000.0
2002-03-18 08:00:00	MSFT	Stock	31.475	31.75	31.24	31.44	199200.0
2002-03-18 09:00:00	MSFT	Stock	31.45	31.5	31.1485	31.165	6266600.0
2002-03-18 10:00:00	MSFT	Stock	31.165	31.26	31.031	31.16	7424000.0
2002-03-18 11:00:00	MSFT	Stock	31.17	31.175	30.8	30.86	7149000.0
2002-03-18 12:00:00	MSFT	Stock	30.86	30.945	30.8	30.825	2964600.0
2002-03-18 13:00:00	MSFT	Stock	30.82	30.925	30.6	30.665	4520800.0
2002-03-18 14:00:00	MSFT	Stock	30.66	30.845	30.61	30.82	4138800.0
2002-03-18 15:00:00	MSFT	Stock	30.825	31.125	30.8025	31.07	6480400.0
2002-03-18 16:00:00	MSFT	Stock	31.08	31.125	30.9402	31.05	2352000.0
2002-03-18 17:00:00	MSFT	Stock	31.05	31.05	30.7755	31.045	10000.0
2002-03-18 18:00:00	MSFT	Stock	31.035	31.035	31.01	31.01	1800.0
2002-03-18 08:00:00	NVDA	Stock	0.4417	0.4479	0.4392	0.445	3600000.0
2002-03-18 09:00:00	NVDA	Stock	0.445	0.4574	0.4425	0.4531	142908000.0
2002-03-18 10:00:00	NVDA	Stock	0.4529	0.455	0.4426	0.4449	213072000.0
2002-03-18 11:00:00	NVDA	Stock	0.4454	0.4471	0.4377	0.4402	141432000.0
2002-03-18 12:00:00	NVDA	Stock	0.4402	0.4407	0.4347	0.4367	79392000.0
2002-03-18 13:00:00	NVDA	Stock	0.4367	0.441	0.4348	0.4392	81996000.0
2002-03-18 14:00:00	NVDA	Stock	0.4392	0.4408	0.4368	0.4384	86640000.0
2002-03-18 15:00:00	NVDA	Stock	0.4384	0.4404	0.4373	0.4398	170004000.0
2002-03-18 16:00:00	NVDA	Stock	0.4397	0.4452	0.4389	0.4406	28236000.0
2002-03-18 17:00:00	NVDA	Stock	0.4438	0.4438	0.4396	0.4402	432000.0
2002-03-18 18:00:00	NVDA	Stock	0.4402	0.4405	0.4396	0.4405	228000.0
2002-03-18 08:00:00	AMZN	Stock	0.705	0.71	0.705	0.71	170000.0
2002-03-18 09:00:00	AMZN	Stock	0.709	0.738	0.707	0.731	27826000.0
2002-03-18 10:00:00	AMZN	Stock	0.73	0.7385	0.725	0.734	22190000.0
2002-03-18 11:00:00	AMZN	Stock	0.733	0.736	0.726	0.7316	14918000.0
2002-03-18 12:00:00	AMZN	Stock	0.732	0.7566	0.729	0.7515	26018000.0
2002-03-18 13:00:00	AMZN	Stock	0.7525	0.764	0.7495	0.751	18964000.0
2002-03-18 14:00:00	AMZN	Stock	0.751	0.753	0.74	0.7505	15098000.0
2002-03-18 15:00:00	AMZN	Stock	0.7508	0.7574	0.7475	0.7505	19992000.0
2002-03-18 16:00:00	AMZN	Stock	0.7525	0.7602	0.74	0.7515	3714000.0
2002-03-18 17:00:00	AMZN	Stock	0.752	0.752	0.7505	0.7505	30000.0
2002-03-18 18:00:00	AMZN	Stock	0.7515	0.7515	0.7515	0.7515	2000.0
2002-03-18 09:00:00	CL	Stock	28.0	28.075	27.9	27.95	596800.0
2002-03-18 10:00:00	CL	Stock	27.955	28.13	27.955	28.05	475600.0
2002-03-18 11:00:00	CL	Stock	28.05	28.05	27.83	27.915	445200.0
2002-03-18 12:00:00	CL	Stock	27.95	28.115	27.925	28.09	260800.0
2002-03-18 13:00:00	CL	Stock	28.1	28.145	28.05	28.09	183200.0
2002-03-18 14:00:00	CL	Stock	28.075	28.25	28.05	28.16	351000.0
2002-03-18 15:00:00	CL	Stock	28.16	28.325	28.125	28.22	897000.0

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

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