PREVIEW / stock_1hour / 2002-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-04.parquet
  size:    403 KB
  rows:    18,616
  symbols: 1,364

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-01-04 08:00:00	AAPL	Stock	0.4196	0.4216	0.4196	0.4202	341600.0
2002-01-04 09:00:00	AAPL	Stock	0.4196	0.4259	0.4159	0.4232	42470400.0
2002-01-04 10:00:00	AAPL	Stock	0.4238	0.4241	0.4125	0.4139	59287200.0
2002-01-04 11:00:00	AAPL	Stock	0.4138	0.4196	0.4134	0.415	54538400.0
2002-01-04 12:00:00	AAPL	Stock	0.4148	0.4166	0.4105	0.4161	55854400.0
2002-01-04 13:00:00	AAPL	Stock	0.4161	0.4195	0.4152	0.4184	32636800.0
2002-01-04 14:00:00	AAPL	Stock	0.4184	0.4236	0.4173	0.4227	43036000.0
2002-01-04 15:00:00	AAPL	Stock	0.4225	0.4277	0.4214	0.423	90272000.0
2002-01-04 16:00:00	AAPL	Stock	0.423	0.4236	0.4194	0.4223	3119200.0
2002-01-04 17:00:00	AAPL	Stock	0.4218	0.425	0.4218	0.4246	280000.0
2002-01-04 18:00:00	AAPL	Stock	0.4223	0.425	0.4223	0.4248	162400.0
2002-01-04 08:00:00	MSFT	Stock	34.6	34.714	34.575	34.635	49600.0
2002-01-04 09:00:00	MSFT	Stock	34.636	34.955	34.48	34.8595	10748400.0
2002-01-04 10:00:00	MSFT	Stock	34.855	34.95	34.335	34.5899	12756400.0
2002-01-04 11:00:00	MSFT	Stock	34.5845	34.75	34.43	34.515	5810800.0
2002-01-04 12:00:00	MSFT	Stock	34.52	34.665	34.355	34.575	4622200.0
2002-01-04 13:00:00	MSFT	Stock	34.59	34.665	34.425	34.6005	3814800.0
2002-01-04 14:00:00	MSFT	Stock	34.605	34.675	34.415	34.57	4919600.0
2002-01-04 15:00:00	MSFT	Stock	34.57	34.725	34.35	34.45	6942000.0
2002-01-04 16:00:00	MSFT	Stock	34.45	34.665	34.375	34.5	1988400.0
2002-01-04 17:00:00	MSFT	Stock	34.475	34.475	34.45	34.45	76400.0
2002-01-04 18:00:00	MSFT	Stock	34.475	34.475	34.46	34.46	2200.0
2002-01-04 08:00:00	NVDA	Stock	0.6	0.6042	0.6	0.6041	1260000.0
2002-01-04 09:00:00	NVDA	Stock	0.6041	0.6055	0.5876	0.5917	147396000.0
2002-01-04 10:00:00	NVDA	Stock	0.5927	0.5963	0.5772	0.5838	267360000.0
2002-01-04 11:00:00	NVDA	Stock	0.5833	0.5862	0.5731	0.5737	136260000.0
2002-01-04 12:00:00	NVDA	Stock	0.5733	0.5811	0.57	0.5809	90108000.0
2002-01-04 13:00:00	NVDA	Stock	0.5809	0.5874	0.58	0.5867	88068000.0
2002-01-04 14:00:00	NVDA	Stock	0.5872	0.588	0.5792	0.5843	85536000.0
2002-01-04 15:00:00	NVDA	Stock	0.5849	0.5894	0.5783	0.5803	110916000.0
2002-01-04 16:00:00	NVDA	Stock	0.5801	0.5827	0.5772	0.58	7224000.0
2002-01-04 17:00:00	NVDA	Stock	0.5802	0.5802	0.5792	0.5792	156000.0
2002-01-04 18:00:00	NVDA	Stock	0.5796	0.5796	0.5796	0.5796	36000.0
2002-01-04 08:00:00	AMZN	Stock	0.585	0.6051	0.585	0.605	642000.0
2002-01-04 09:00:00	AMZN	Stock	0.605	0.6175	0.596	0.6135	47674000.0
2002-01-04 10:00:00	AMZN	Stock	0.6135	0.62	0.6006	0.611	48928000.0
2002-01-04 11:00:00	AMZN	Stock	0.611	0.616	0.607	0.607	22572000.0
2002-01-04 12:00:00	AMZN	Stock	0.607	0.6075	0.5975	0.6045	21072000.0
2002-01-04 13:00:00	AMZN	Stock	0.6045	0.61	0.601	0.6075	20994000.0
2002-01-04 14:00:00	AMZN	Stock	0.6075	0.612	0.605	0.6066	21168000.0
2002-01-04 15:00:00	AMZN	Stock	0.607	0.614	0.607	0.6125	28598000.0
2002-01-04 16:00:00	AMZN	Stock	0.612	0.615	0.6075	0.6075	24100000.0
2002-01-04 17:00:00	AMZN	Stock	0.6125	0.6125	0.606	0.6075	436000.0
2002-01-04 18:00:00	AMZN	Stock	0.606	0.6075	0.606	0.6065	98000.0
2002-01-04 09:00:00	CL	Stock	28.585	28.59	28.48	28.5	268200.0
2002-01-04 10:00:00	CL	Stock	28.49	28.565	27.95	28.05	690800.0
2002-01-04 11:00:00	CL	Stock	28.045	28.14	27.975	28.055	404200.0
2002-01-04 12:00:00	CL	Stock	28.06	28.2	28.025	28.075	545800.0
2002-01-04 13:00:00	CL	Stock	28.07	28.095	27.93	28.05	255000.0
2002-01-04 14:00:00	CL	Stock	28.055	28.135	27.815	27.92	951800.0

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

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