PREVIEW / stock_1hour / 2001-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-03.parquet
  size:    325 KB
  rows:    16,696
  symbols: 1,267

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-03 08:00:00	AAPL	Stock	0.2656	0.2662	0.25	0.2578	4491200.0
2001-01-03 09:00:00	AAPL	Stock	0.2578	0.2723	0.2545	0.269	83708800.0
2001-01-03 10:00:00	AAPL	Stock	0.269	0.2801	0.2667	0.2706	166331200.0
2001-01-03 11:00:00	AAPL	Stock	0.2701	0.2734	0.2667	0.2701	52164000.0
2001-01-03 12:00:00	AAPL	Stock	0.269	0.2712	0.2667	0.2701	57360800.0
2001-01-03 13:00:00	AAPL	Stock	0.2701	0.2835	0.2679	0.2768	110493600.0
2001-01-03 14:00:00	AAPL	Stock	0.2779	0.2958	0.2757	0.2946	164875200.0
2001-01-03 15:00:00	AAPL	Stock	0.2935	0.298	0.2846	0.2924	104367200.0
2001-01-03 16:00:00	AAPL	Stock	0.2913	0.2935	0.2807	0.2913	21884800.0
2001-01-03 17:00:00	AAPL	Stock	0.2919	0.2935	0.2919	0.2924	117600.0
2001-01-03 18:00:00	AAPL	Stock	0.2935	0.2935	0.2924	0.2924	44800.0
2001-01-03 08:00:00	MSFT	Stock	21.5	21.75	21.125	21.375	132800.0
2001-01-03 09:00:00	MSFT	Stock	21.375	22.375	21.25	22.2188	14015800.0
2001-01-03 10:00:00	MSFT	Stock	22.2188	22.7188	22.125	22.5312	17994400.0
2001-01-03 11:00:00	MSFT	Stock	22.5312	22.8125	22.25	22.4688	10556000.0
2001-01-03 12:00:00	MSFT	Stock	22.4688	22.625	22.2812	22.5625	8082400.0
2001-01-03 13:00:00	MSFT	Stock	22.5938	24.25	22.4062	23.375	27037600.0
2001-01-03 14:00:00	MSFT	Stock	23.4062	24.4375	23.3125	24.375	23854000.0
2001-01-03 15:00:00	MSFT	Stock	24.4062	24.4375	23.9062	23.9375	23064800.0
2001-01-03 16:00:00	MSFT	Stock	23.9844	24.1875	23.2344	23.9688	4504400.0
2001-01-03 17:00:00	MSFT	Stock	23.9688	24.0	23.75	23.9062	42400.0
2001-01-03 18:00:00	MSFT	Stock	23.9688	24.0	23.9375	24.0	5400.0
2001-01-03 09:00:00	NVDA	Stock	0.125	0.1292	0.1177	0.1245	59352000.0
2001-01-03 10:00:00	NVDA	Stock	0.1245	0.1398	0.1232	0.1331	96240000.0
2001-01-03 11:00:00	NVDA	Stock	0.1331	0.1354	0.1289	0.1299	63864000.0
2001-01-03 12:00:00	NVDA	Stock	0.1302	0.1326	0.1271	0.1315	54336000.0
2001-01-03 13:00:00	NVDA	Stock	0.1318	0.1625	0.1299	0.1418	189648000.0
2001-01-03 14:00:00	NVDA	Stock	0.1419	0.162	0.1417	0.1607	170136000.0
2001-01-03 15:00:00	NVDA	Stock	0.1611	0.1643	0.1536	0.1625	158928000.0
2001-01-03 16:00:00	NVDA	Stock	0.1633	0.1651	0.162	0.1628	11208000.0
2001-01-03 17:00:00	NVDA	Stock	0.1462	0.1667	0.1458	0.1667	144000.0
2001-01-03 18:00:00	NVDA	Stock	0.1661	0.1661	0.1661	0.1661	24000.0
2001-01-03 08:00:00	AMZN	Stock	0.6766	0.6906	0.6625	0.675	318000.0
2001-01-03 09:00:00	AMZN	Stock	0.6719	0.7	0.65	0.6875	20570000.0
2001-01-03 10:00:00	AMZN	Stock	0.6844	0.6969	0.6844	0.6938	32760000.0
2001-01-03 11:00:00	AMZN	Stock	0.6906	0.7	0.6844	0.6938	26834000.0
2001-01-03 12:00:00	AMZN	Stock	0.6953	0.75	0.6875	0.75	27570000.0
2001-01-03 13:00:00	AMZN	Stock	0.75	0.8625	0.7188	0.8	54126000.0
2001-01-03 14:00:00	AMZN	Stock	0.8047	0.85	0.7875	0.8375	43776000.0
2001-01-03 15:00:00	AMZN	Stock	0.8375	0.8938	0.8375	0.8812	58658000.0
2001-01-03 16:00:00	AMZN	Stock	0.8781	0.8938	0.8625	0.8781	5344000.0
2001-01-03 17:00:00	AMZN	Stock	0.8844	0.8938	0.8719	0.8938	146000.0
2001-01-03 18:00:00	AMZN	Stock	0.8812	0.8812	0.875	0.8781	26000.0
2001-01-03 09:00:00	CL	Stock	32.375	32.375	31.87	31.875	726600.0
2001-01-03 10:00:00	CL	Stock	31.875	31.875	30.95	31.0	767400.0
2001-01-03 11:00:00	CL	Stock	31.0	31.08	30.675	30.75	538800.0
2001-01-03 12:00:00	CL	Stock	30.755	31.1	30.63	30.925	431200.0
2001-01-03 13:00:00	CL	Stock	30.925	32.2	30.675	30.695	658600.0
2001-01-03 14:00:00	CL	Stock	30.695	30.745	29.7	30.195	801600.0
2001-01-03 15:00:00	CL	Stock	30.17	30.245	30.05	30.05	633200.0

> showing 50 of 16,696 rows — these rows as CSV

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