PREVIEW / stock_1hour / 2002-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-01.parquet
  size:    405 KB
  rows:    18,731
  symbols: 1,410

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-04-01 09:00:00	AAPL	Stock	0.4194	0.4214	0.4157	0.4188	19308800.0
2002-04-01 10:00:00	AAPL	Stock	0.4195	0.4232	0.417	0.4205	52220000.0
2002-04-01 11:00:00	AAPL	Stock	0.4207	0.4221	0.4195	0.4218	6837600.0
2002-04-01 12:00:00	AAPL	Stock	0.422	0.4279	0.4214	0.4263	16665600.0
2002-04-01 13:00:00	AAPL	Stock	0.4264	0.4339	0.4263	0.433	23363200.0
2002-04-01 14:00:00	AAPL	Stock	0.433	0.4375	0.4314	0.4375	20781600.0
2002-04-01 15:00:00	AAPL	Stock	0.4375	0.4411	0.4334	0.4368	43047200.0
2002-04-01 16:00:00	AAPL	Stock	0.4368	0.438	0.4265	0.4368	9475200.0
2002-04-01 17:00:00	AAPL	Stock	0.4368	0.4368	0.433	0.433	683200.0
2002-04-01 08:00:00	MSFT	Stock	30.095	30.095	29.945	30.05	44800.0
2002-04-01 09:00:00	MSFT	Stock	30.11	30.11	29.715	29.805	5771800.0
2002-04-01 10:00:00	MSFT	Stock	29.807	29.8905	29.625	29.7451	7359800.0
2002-04-01 11:00:00	MSFT	Stock	29.75	29.795	29.65	29.661	4664200.0
2002-04-01 12:00:00	MSFT	Stock	29.66	29.775	29.6	29.7445	4628600.0
2002-04-01 13:00:00	MSFT	Stock	29.74	29.89	29.705	29.8195	4176400.0
2002-04-01 14:00:00	MSFT	Stock	29.82	29.8685	29.675	29.85	6342800.0
2002-04-01 15:00:00	MSFT	Stock	29.854	30.2	29.835	30.195	8637000.0
2002-04-01 16:00:00	MSFT	Stock	30.19	30.245	29.8015	30.245	3300600.0
2002-04-01 17:00:00	MSFT	Stock	29.8266	30.2	29.8266	30.18	104400.0
2002-04-01 18:00:00	MSFT	Stock	30.18	30.18	30.14	30.14	600.0
2002-04-01 08:00:00	NVDA	Stock	0.345	0.3707	0.3416	0.3517	43980000.0
2002-04-01 09:00:00	NVDA	Stock	0.3517	0.3688	0.3437	0.3506	437676000.0
2002-04-01 10:00:00	NVDA	Stock	0.3504	0.352	0.338	0.3462	592968000.0
2002-04-01 11:00:00	NVDA	Stock	0.3461	0.3492	0.3438	0.3464	161340000.0
2002-04-01 12:00:00	NVDA	Stock	0.3465	0.3582	0.3458	0.355	307356000.0
2002-04-01 13:00:00	NVDA	Stock	0.3548	0.3606	0.3542	0.3577	181452000.0
2002-04-01 14:00:00	NVDA	Stock	0.3574	0.3598	0.3512	0.3582	202488000.0
2002-04-01 15:00:00	NVDA	Stock	0.3582	0.3664	0.3562	0.3632	354612000.0
2002-04-01 16:00:00	NVDA	Stock	0.3636	0.3636	0.3514	0.3636	15360000.0
2002-04-01 17:00:00	NVDA	Stock	0.3623	0.3642	0.3621	0.3637	1272000.0
2002-04-01 18:00:00	NVDA	Stock	0.3642	0.3658	0.3642	0.3646	1428000.0
2002-04-01 08:00:00	AMZN	Stock	0.715	0.7182	0.715	0.715	82000.0
2002-04-01 09:00:00	AMZN	Stock	0.7135	0.7175	0.7085	0.715	10136000.0
2002-04-01 10:00:00	AMZN	Stock	0.714	0.7165	0.707	0.7125	12744000.0
2002-04-01 11:00:00	AMZN	Stock	0.7115	0.7144	0.711	0.7135	5612000.0
2002-04-01 12:00:00	AMZN	Stock	0.7135	0.7265	0.713	0.7235	6546000.0
2002-04-01 13:00:00	AMZN	Stock	0.724	0.736	0.723	0.7355	9660000.0
2002-04-01 14:00:00	AMZN	Stock	0.7355	0.7375	0.7285	0.7365	34218000.0
2002-04-01 15:00:00	AMZN	Stock	0.7365	0.74	0.7336	0.74	13302000.0
2002-04-01 16:00:00	AMZN	Stock	0.7385	0.742	0.7265	0.7395	2206000.0
2002-04-01 17:00:00	AMZN	Stock	0.74	0.74	0.74	0.74	164000.0
2002-04-01 18:00:00	AMZN	Stock	0.74	0.74	0.74	0.74	4000.0
2002-04-01 09:00:00	CL	Stock	28.45	28.485	28.36	28.4	234400.0
2002-04-01 10:00:00	CL	Stock	28.4	28.495	28.275	28.295	519000.0
2002-04-01 11:00:00	CL	Stock	28.275	28.305	28.22	28.235	209200.0
2002-04-01 12:00:00	CL	Stock	28.23	28.27	28.13	28.18	206000.0
2002-04-01 13:00:00	CL	Stock	28.18	28.23	28.125	28.185	195400.0
2002-04-01 14:00:00	CL	Stock	28.185	28.26	28.15	28.26	143800.0
2002-04-01 15:00:00	CL	Stock	28.26	28.34	28.205	28.295	447400.0
2002-04-01 16:00:00	CL	Stock	28.285	28.3	28.285	28.3	6116400.0

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

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