PREVIEW / stock_1hour / 2002-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-29.parquet
  size:    399 KB
  rows:    18,307
  symbols: 1,359

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-29 08:00:00	AAPL	Stock	0.4164	0.4164	0.4164	0.4164	39200.0
2002-01-29 09:00:00	AAPL	Stock	0.4155	0.4204	0.4146	0.4182	23660000.0
2002-01-29 10:00:00	AAPL	Stock	0.418	0.4189	0.4123	0.4129	29400000.0
2002-01-29 11:00:00	AAPL	Stock	0.4136	0.4168	0.4125	0.4143	26376000.0
2002-01-29 12:00:00	AAPL	Stock	0.4138	0.4145	0.4113	0.413	34927200.0
2002-01-29 13:00:00	AAPL	Stock	0.4129	0.4161	0.4113	0.4121	23704800.0
2002-01-29 14:00:00	AAPL	Stock	0.4121	0.4132	0.408	0.4116	45483200.0
2002-01-29 15:00:00	AAPL	Stock	0.4114	0.4125	0.4093	0.412	34708800.0
2002-01-29 16:00:00	AAPL	Stock	0.412	0.4134	0.4114	0.412	8321600.0
2002-01-29 17:00:00	AAPL	Stock	0.4134	0.4134	0.4134	0.4134	5600.0
2002-01-29 08:00:00	MSFT	Stock	32.0	32.075	32.0	32.075	45200.0
2002-01-29 09:00:00	MSFT	Stock	32.01	32.25	31.915	32.2	7803800.0
2002-01-29 10:00:00	MSFT	Stock	32.2	32.225	31.8	31.83	8658600.0
2002-01-29 11:00:00	MSFT	Stock	31.83	31.93	31.735	31.745	5681600.0
2002-01-29 12:00:00	MSFT	Stock	31.75	31.75	31.375	31.57	7375400.0
2002-01-29 13:00:00	MSFT	Stock	31.57	31.66	31.46	31.525	4770800.0
2002-01-29 14:00:00	MSFT	Stock	31.525	31.5795	31.25	31.355	7387800.0
2002-01-29 15:00:00	MSFT	Stock	31.34	31.37	30.995	31.165	14399600.0
2002-01-29 16:00:00	MSFT	Stock	31.165	31.66	31.04	31.16	2169600.0
2002-01-29 17:00:00	MSFT	Stock	31.17	31.606	31.145	31.145	30200.0
2002-01-29 18:00:00	MSFT	Stock	31.2	31.225	31.175	31.225	3400.0
2002-01-29 08:00:00	NVDA	Stock	0.5665	0.5712	0.5665	0.5704	5376000.0
2002-01-29 09:00:00	NVDA	Stock	0.5708	0.5708	0.5617	0.5628	112752000.0
2002-01-29 10:00:00	NVDA	Stock	0.5627	0.5664	0.5558	0.5567	222756000.0
2002-01-29 11:00:00	NVDA	Stock	0.5568	0.5582	0.5497	0.55	208992000.0
2002-01-29 12:00:00	NVDA	Stock	0.5498	0.55	0.5417	0.5465	142224000.0
2002-01-29 13:00:00	NVDA	Stock	0.5462	0.5477	0.5377	0.54	144672000.0
2002-01-29 14:00:00	NVDA	Stock	0.54	0.5428	0.53	0.5363	212184000.0
2002-01-29 15:00:00	NVDA	Stock	0.5358	0.5412	0.5325	0.5388	256800000.0
2002-01-29 16:00:00	NVDA	Stock	0.5387	0.5485	0.5383	0.5383	35580000.0
2002-01-29 17:00:00	NVDA	Stock	0.5382	0.5387	0.5382	0.5383	240000.0
2002-01-29 18:00:00	NVDA	Stock	0.5399	0.54	0.5396	0.5396	156000.0
2002-01-29 08:00:00	AMZN	Stock	0.775	0.7825	0.775	0.78	1142000.0
2002-01-29 09:00:00	AMZN	Stock	0.78	0.781	0.755	0.7585	54276000.0
2002-01-29 10:00:00	AMZN	Stock	0.7585	0.7585	0.735	0.7425	72104000.0
2002-01-29 11:00:00	AMZN	Stock	0.7425	0.743	0.7134	0.733	47456000.0
2002-01-29 12:00:00	AMZN	Stock	0.7326	0.7365	0.7175	0.727	52996000.0
2002-01-29 13:00:00	AMZN	Stock	0.727	0.727	0.706	0.709	45800000.0
2002-01-29 14:00:00	AMZN	Stock	0.709	0.7146	0.7	0.708	37820000.0
2002-01-29 15:00:00	AMZN	Stock	0.708	0.717	0.6985	0.709	57464000.0
2002-01-29 16:00:00	AMZN	Stock	0.711	0.7302	0.7065	0.7095	10588000.0
2002-01-29 17:00:00	AMZN	Stock	0.7095	0.7125	0.709	0.7125	138000.0
2002-01-29 18:00:00	AMZN	Stock	0.711	0.711	0.709	0.7095	80000.0
2002-01-29 09:00:00	CL	Stock	28.075	28.175	28.075	28.105	269200.0
2002-01-29 10:00:00	CL	Stock	28.105	28.175	28.015	28.12	370800.0
2002-01-29 11:00:00	CL	Stock	28.11	28.2	28.06	28.095	781400.0
2002-01-29 12:00:00	CL	Stock	28.09	28.135	28.0	28.1	217400.0
2002-01-29 13:00:00	CL	Stock	28.11	28.125	27.91	28.025	270600.0
2002-01-29 14:00:00	CL	Stock	28.045	28.045	27.755	27.91	372000.0
2002-01-29 15:00:00	CL	Stock	27.895	27.95	27.74	27.8	564600.0

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

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