PREVIEW / stock_1hour / 2001-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-31.parquet
  size:    369 KB
  rows:    17,032
  symbols: 1,280

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
2001-01-31 08:00:00	AAPL	Stock	0.3873	0.3873	0.3817	0.385	28000.0
2001-01-31 09:00:00	AAPL	Stock	0.3873	0.3984	0.3828	0.3951	81384800.0
2001-01-31 10:00:00	AAPL	Stock	0.3951	0.4018	0.3873	0.3906	146871200.0
2001-01-31 11:00:00	AAPL	Stock	0.3895	0.394	0.3884	0.3917	42240800.0
2001-01-31 12:00:00	AAPL	Stock	0.3906	0.394	0.3895	0.3929	28565600.0
2001-01-31 13:00:00	AAPL	Stock	0.3929	0.4007	0.3917	0.3984	84145600.0
2001-01-31 14:00:00	AAPL	Stock	0.3984	0.4018	0.3906	0.3929	122908800.0
2001-01-31 15:00:00	AAPL	Stock	0.3929	0.3951	0.385	0.3873	100632000.0
2001-01-31 16:00:00	AAPL	Stock	0.3873	0.3962	0.3839	0.3884	22008000.0
2001-01-31 17:00:00	AAPL	Stock	0.3862	0.3873	0.3817	0.3817	386400.0
2001-01-31 18:00:00	AAPL	Stock	0.3839	0.3839	0.3795	0.3795	196000.0
2001-01-31 08:00:00	MSFT	Stock	31.5625	31.7188	31.4688	31.625	85200.0
2001-01-31 09:00:00	MSFT	Stock	31.5	31.875	31.4688	31.5938	5264800.0
2001-01-31 10:00:00	MSFT	Stock	31.625	31.6875	31.375	31.5625	8227400.0
2001-01-31 11:00:00	MSFT	Stock	31.5781	31.5938	31.25	31.4688	7749200.0
2001-01-31 12:00:00	MSFT	Stock	31.5	31.6562	31.2812	31.5312	6525600.0
2001-01-31 13:00:00	MSFT	Stock	31.5312	31.625	31.25	31.2812	7169400.0
2001-01-31 14:00:00	MSFT	Stock	31.25	31.625	31.0	31.1875	16738800.0
2001-01-31 15:00:00	MSFT	Stock	31.1875	31.25	30.5	30.5312	16595800.0
2001-01-31 16:00:00	MSFT	Stock	30.5312	31.4062	30.375	30.375	4941200.0
2001-01-31 17:00:00	MSFT	Stock	30.3906	30.4375	30.25	30.3438	86200.0
2001-01-31 18:00:00	MSFT	Stock	30.3438	30.5312	30.25	30.25	75800.0
2001-01-31 08:00:00	NVDA	Stock	0.2125	0.2135	0.2125	0.2125	288000.0
2001-01-31 09:00:00	NVDA	Stock	0.2177	0.2219	0.2159	0.2201	34440000.0
2001-01-31 10:00:00	NVDA	Stock	0.2202	0.226	0.219	0.2253	51528000.0
2001-01-31 11:00:00	NVDA	Stock	0.225	0.2253	0.2201	0.2208	21240000.0
2001-01-31 12:00:00	NVDA	Stock	0.2208	0.2221	0.219	0.2221	20664000.0
2001-01-31 13:00:00	NVDA	Stock	0.2221	0.2227	0.2195	0.2206	57624000.0
2001-01-31 14:00:00	NVDA	Stock	0.2203	0.224	0.2104	0.2146	62616000.0
2001-01-31 15:00:00	NVDA	Stock	0.2148	0.2177	0.212	0.2156	58512000.0
2001-01-31 16:00:00	NVDA	Stock	0.2156	0.2174	0.2128	0.2128	7152000.0
2001-01-31 17:00:00	NVDA	Stock	0.2188	0.2188	0.2188	0.2188	48000.0
2001-01-31 08:00:00	AMZN	Stock	0.9219	0.9688	0.8875	0.9594	19616000.0
2001-01-31 09:00:00	AMZN	Stock	0.9594	0.9781	0.9344	0.9625	74296000.0
2001-01-31 10:00:00	AMZN	Stock	0.9656	0.9688	0.9188	0.9281	54552000.0
2001-01-31 11:00:00	AMZN	Stock	0.9281	0.9281	0.8969	0.9	57758000.0
2001-01-31 12:00:00	AMZN	Stock	0.9	0.9125	0.8812	0.8875	31718000.0
2001-01-31 13:00:00	AMZN	Stock	0.8875	0.9	0.8594	0.8969	40698000.0
2001-01-31 14:00:00	AMZN	Stock	0.8969	0.9062	0.8625	0.8781	42072000.0
2001-01-31 15:00:00	AMZN	Stock	0.8812	0.8875	0.8531	0.8656	41628000.0
2001-01-31 16:00:00	AMZN	Stock	0.8688	0.9469	0.85	0.8688	11088000.0
2001-01-31 17:00:00	AMZN	Stock	0.8688	0.8688	0.8625	0.8688	214000.0
2001-01-31 18:00:00	AMZN	Stock	0.8703	0.8719	0.8625	0.8719	70000.0
2001-01-31 09:00:00	CL	Stock	29.235	29.235	28.525	28.55	405800.0
2001-01-31 10:00:00	CL	Stock	28.55	29.275	28.55	29.23	404400.0
2001-01-31 11:00:00	CL	Stock	29.225	29.35	29.18	29.29	171600.0
2001-01-31 12:00:00	CL	Stock	29.285	29.35	29.28	29.345	91200.0
2001-01-31 13:00:00	CL	Stock	29.375	29.55	29.3	29.52	275600.0
2001-01-31 14:00:00	CL	Stock	29.5	29.875	29.16	29.8	548400.0
2001-01-31 15:00:00	CL	Stock	29.78	30.05	29.685	30.04	831800.0

> showing 50 of 17,032 rows — these rows as CSV

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