PREVIEW / stock_1hour / 2000-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-08.parquet
  size:    298 KB
  rows:    15,436
  symbols: 1,203

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
2000-08-08 08:00:00	AAPL	Stock	0.8555	0.8555	0.8538	0.8538	492800.0
2000-08-08 09:00:00	AAPL	Stock	0.8527	0.8571	0.8438	0.8482	23049600.0
2000-08-08 10:00:00	AAPL	Stock	0.8516	0.8549	0.8348	0.8393	45214400.0
2000-08-08 11:00:00	AAPL	Stock	0.8393	0.8421	0.8348	0.8393	27748000.0
2000-08-08 12:00:00	AAPL	Stock	0.8404	0.8415	0.8371	0.8382	20445600.0
2000-08-08 13:00:00	AAPL	Stock	0.8371	0.8404	0.8348	0.8371	8864800.0
2000-08-08 14:00:00	AAPL	Stock	0.8359	0.8393	0.8315	0.8393	17600800.0
2000-08-08 15:00:00	AAPL	Stock	0.8393	0.8393	0.827	0.8348	27535200.0
2000-08-08 16:00:00	AAPL	Stock	0.8348	0.8393	0.8326	0.8393	2424800.0
2000-08-08 17:00:00	AAPL	Stock	0.8482	0.8482	0.8438	0.8438	117600.0
2000-08-08 18:00:00	AAPL	Stock	0.8438	0.8438	0.8438	0.8438	5600.0
2000-08-08 08:00:00	MSFT	Stock	35.0156	35.0156	34.5938	34.9688	63000.0
2000-08-08 09:00:00	MSFT	Stock	34.9688	35.5312	34.8125	35.4062	8336800.0
2000-08-08 10:00:00	MSFT	Stock	35.4062	35.9375	35.3438	35.875	24743000.0
2000-08-08 11:00:00	MSFT	Stock	35.875	36.125	35.7188	36.0938	9830600.0
2000-08-08 12:00:00	MSFT	Stock	36.0938	36.5	36.0625	36.4375	13286200.0
2000-08-08 13:00:00	MSFT	Stock	36.4375	36.7188	35.9375	36.3438	29474200.0
2000-08-08 14:00:00	MSFT	Stock	36.3438	36.9375	36.3125	36.9219	19165200.0
2000-08-08 15:00:00	MSFT	Stock	36.9062	37.3438	36.6875	37.0312	29093600.0
2000-08-08 16:00:00	MSFT	Stock	37.0469	37.25	35.6875	37.125	1467000.0
2000-08-08 17:00:00	MSFT	Stock	37.0938	37.5	37.0625	37.2188	77000.0
2000-08-08 18:00:00	MSFT	Stock	37.3125	37.3125	37.2188	37.2188	11400.0
2000-08-08 08:00:00	NVDA	Stock	0.2866	0.2891	0.285	0.2878	4272000.0
2000-08-08 09:00:00	NVDA	Stock	0.2865	0.2896	0.2792	0.2875	29448000.0
2000-08-08 10:00:00	NVDA	Stock	0.2875	0.2958	0.2854	0.2875	35136000.0
2000-08-08 11:00:00	NVDA	Stock	0.2875	0.2885	0.2792	0.288	21000000.0
2000-08-08 12:00:00	NVDA	Stock	0.2867	0.288	0.2833	0.2841	6000000.0
2000-08-08 13:00:00	NVDA	Stock	0.2844	0.2857	0.2828	0.2844	7128000.0
2000-08-08 14:00:00	NVDA	Stock	0.2852	0.2852	0.2792	0.2813	6816000.0
2000-08-08 15:00:00	NVDA	Stock	0.2823	0.2862	0.2802	0.2802	16176000.0
2000-08-08 16:00:00	NVDA	Stock	0.2802	0.2849	0.2792	0.2792	792000.0
2000-08-08 08:00:00	AMZN	Stock	1.6438	1.6703	1.6031	1.6688	246000.0
2000-08-08 09:00:00	AMZN	Stock	1.6656	1.6719	1.6438	1.6562	14100000.0
2000-08-08 10:00:00	AMZN	Stock	1.6562	1.6625	1.6375	1.6484	17568000.0
2000-08-08 11:00:00	AMZN	Stock	1.6484	1.65	1.6375	1.6375	8852000.0
2000-08-08 12:00:00	AMZN	Stock	1.6375	1.6406	1.6219	1.6312	14674000.0
2000-08-08 13:00:00	AMZN	Stock	1.6281	1.6469	1.6219	1.6406	16258000.0
2000-08-08 14:00:00	AMZN	Stock	1.6406	1.6469	1.6281	1.6406	10046000.0
2000-08-08 15:00:00	AMZN	Stock	1.6406	1.65	1.625	1.6438	17046000.0
2000-08-08 16:00:00	AMZN	Stock	1.6469	1.65	1.6375	1.65	1816000.0
2000-08-08 17:00:00	AMZN	Stock	1.65	1.65	1.65	1.65	16000.0
2000-08-08 09:00:00	CL	Stock	26.875	26.875	25.8125	26.2188	968200.0
2000-08-08 10:00:00	CL	Stock	26.25	26.3125	25.9688	26.25	725600.0
2000-08-08 11:00:00	CL	Stock	26.2188	26.5938	26.125	26.4688	796600.0
2000-08-08 12:00:00	CL	Stock	26.4688	26.4688	26.25	26.3438	432800.0
2000-08-08 13:00:00	CL	Stock	26.3438	26.4375	26.1562	26.4062	561800.0
2000-08-08 14:00:00	CL	Stock	26.4062	26.5938	26.2188	26.5	560800.0
2000-08-08 15:00:00	CL	Stock	26.4688	26.625	26.25	26.375	1169800.0
2000-08-08 16:00:00	CL	Stock	26.375	26.4375	26.3125	26.3125	72200.0
2000-08-08 17:00:00	CL	Stock	26.4375	26.4375	26.4375	26.4375	42000.0

> showing 50 of 15,436 rows — these rows as CSV

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