PREVIEW / stock_1hour / 2000-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-12-18.parquet
  size:    325 KB
  rows:    16,799
  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
2000-12-18 08:00:00	AAPL	Stock	0.2545	0.2595	0.2511	0.2589	1730400.0
2000-12-18 09:00:00	AAPL	Stock	0.2589	0.2612	0.2556	0.2578	39323200.0
2000-12-18 10:00:00	AAPL	Stock	0.2578	0.26	0.2533	0.2545	50612800.0
2000-12-18 11:00:00	AAPL	Stock	0.2545	0.2567	0.2533	0.2545	23486400.0
2000-12-18 12:00:00	AAPL	Stock	0.2533	0.2545	0.2511	0.2522	27384000.0
2000-12-18 13:00:00	AAPL	Stock	0.2522	0.2533	0.2511	0.2511	28593600.0
2000-12-18 14:00:00	AAPL	Stock	0.2522	0.2533	0.25	0.25	31696000.0
2000-12-18 15:00:00	AAPL	Stock	0.2511	0.2556	0.2489	0.2545	97619200.0
2000-12-18 16:00:00	AAPL	Stock	0.2556	0.2589	0.2539	0.2545	3427200.0
2000-12-18 17:00:00	AAPL	Stock	0.2556	0.2556	0.2545	0.2545	722400.0
2000-12-18 08:00:00	MSFT	Stock	25.1562	25.375	24.5938	24.6875	445800.0
2000-12-18 09:00:00	MSFT	Stock	24.625	25.1875	24.3125	24.4375	16579400.0
2000-12-18 10:00:00	MSFT	Stock	24.5312	24.9062	24.4375	24.6562	12233800.0
2000-12-18 11:00:00	MSFT	Stock	24.6562	24.75	24.3125	24.4375	12646800.0
2000-12-18 12:00:00	MSFT	Stock	24.4375	24.4688	24.0	24.0938	10482600.0
2000-12-18 13:00:00	MSFT	Stock	24.0938	24.2188	23.6875	23.8438	11997200.0
2000-12-18 14:00:00	MSFT	Stock	23.8438	24.0	23.7812	23.9062	10617800.0
2000-12-18 15:00:00	MSFT	Stock	23.9375	24.0312	23.5	23.9062	23375800.0
2000-12-18 16:00:00	MSFT	Stock	23.9062	24.1875	23.8125	23.9844	2229000.0
2000-12-18 17:00:00	MSFT	Stock	23.9688	24.0938	23.9688	24.0625	38000.0
2000-12-18 18:00:00	MSFT	Stock	24.0312	24.0312	24.0	24.0	5000.0
2000-12-18 08:00:00	NVDA	Stock	0.1643	0.1667	0.1643	0.1667	600000.0
2000-12-18 09:00:00	NVDA	Stock	0.1646	0.1667	0.1583	0.1625	85296000.0
2000-12-18 10:00:00	NVDA	Stock	0.162	0.1667	0.1604	0.1638	108336000.0
2000-12-18 11:00:00	NVDA	Stock	0.1638	0.1651	0.1602	0.1648	109824000.0
2000-12-18 12:00:00	NVDA	Stock	0.1651	0.1667	0.1604	0.1625	34344000.0
2000-12-18 13:00:00	NVDA	Stock	0.1628	0.1654	0.1625	0.1646	127584000.0
2000-12-18 14:00:00	NVDA	Stock	0.1646	0.1664	0.1607	0.1609	77592000.0
2000-12-18 15:00:00	NVDA	Stock	0.162	0.1625	0.1594	0.1612	64416000.0
2000-12-18 16:00:00	NVDA	Stock	0.1609	0.1625	0.1609	0.1625	7416000.0
2000-12-18 17:00:00	NVDA	Stock	0.162	0.1625	0.162	0.1625	360000.0
2000-12-18 08:00:00	AMZN	Stock	1.15	1.1531	1.05	1.0531	444000.0
2000-12-18 09:00:00	AMZN	Stock	1.05	1.15	1.0312	1.0438	50254000.0
2000-12-18 10:00:00	AMZN	Stock	1.0438	1.05	0.95	0.9688	72974000.0
2000-12-18 11:00:00	AMZN	Stock	0.9688	1.0	0.9469	0.9875	44926000.0
2000-12-18 12:00:00	AMZN	Stock	0.9875	1.0031	0.9656	0.9938	33160000.0
2000-12-18 13:00:00	AMZN	Stock	0.9969	1.0062	0.9906	0.9969	25426000.0
2000-12-18 14:00:00	AMZN	Stock	0.9969	1.0188	0.9938	1.0125	29064000.0
2000-12-18 15:00:00	AMZN	Stock	1.0094	1.0125	0.9875	0.9969	27812000.0
2000-12-18 16:00:00	AMZN	Stock	0.9969	1.0188	0.9734	1.0188	13774000.0
2000-12-18 17:00:00	AMZN	Stock	0.9922	1.0375	0.9922	1.0219	326000.0
2000-12-18 18:00:00	AMZN	Stock	1.0188	1.0188	1.0188	1.0188	12000.0
2000-12-18 09:00:00	CL	Stock	28.75	29.12	28.75	29.12	238600.0
2000-12-18 10:00:00	CL	Stock	29.125	29.325	29.005	29.075	379600.0
2000-12-18 11:00:00	CL	Stock	29.065	29.625	29.065	29.5	436800.0
2000-12-18 12:00:00	CL	Stock	29.5	29.58	29.46	29.5	205400.0
2000-12-18 13:00:00	CL	Stock	29.495	29.7	29.45	29.53	147600.0
2000-12-18 14:00:00	CL	Stock	29.53	29.7	29.525	29.7	139800.0
2000-12-18 15:00:00	CL	Stock	29.695	29.7	29.56	29.62	442000.0
2000-12-18 16:00:00	CL	Stock	29.615	29.615	29.405	29.405	49400.0

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

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