PREVIEW / stock_1hour / 2000-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-01-18.parquet
  size:    284 KB
  rows:    14,540
  symbols: 1,130

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-01-18 09:00:00	AAPL	Stock	0.9018	0.9129	0.8984	0.904	57702400.0
2000-01-18 10:00:00	AAPL	Stock	0.9035	0.9079	0.8968	0.8987	47454400.0
2000-01-18 11:00:00	AAPL	Stock	0.8984	0.9235	0.8968	0.9174	63291200.0
2000-01-18 12:00:00	AAPL	Stock	0.9185	0.9375	0.9107	0.9353	60256000.0
2000-01-18 13:00:00	AAPL	Stock	0.9353	0.9375	0.9252	0.9252	50131200.0
2000-01-18 14:00:00	AAPL	Stock	0.9252	0.9369	0.9213	0.9319	54409600.0
2000-01-18 15:00:00	AAPL	Stock	0.9319	0.9464	0.9275	0.9286	84448000.0
2000-01-18 16:00:00	AAPL	Stock	0.9291	0.9291	0.928	0.928	1948800.0
2000-01-18 09:00:00	MSFT	Stock	55.9062	57.25	55.875	57.0938	13704800.0
2000-01-18 10:00:00	MSFT	Stock	57.125	57.5	56.875	57.4062	13313200.0
2000-01-18 11:00:00	MSFT	Stock	57.4375	57.75	57.1875	57.5	11171400.0
2000-01-18 12:00:00	MSFT	Stock	57.5	57.5312	57.25	57.2812	4184800.0
2000-01-18 13:00:00	MSFT	Stock	57.3438	57.625	57.3125	57.4375	5393000.0
2000-01-18 14:00:00	MSFT	Stock	57.4375	58.0	57.3438	57.7969	9458400.0
2000-01-18 15:00:00	MSFT	Stock	57.8125	58.0312	57.375	57.6875	15304200.0
2000-01-18 16:00:00	MSFT	Stock	57.6875	57.8125	57.6094	57.6562	299400.0
2000-01-18 09:00:00	NVDA	Stock	0.0927	0.0935	0.0926	0.0927	21456000.0
2000-01-18 10:00:00	NVDA	Stock	0.0932	0.0945	0.0885	0.0885	78240000.0
2000-01-18 11:00:00	NVDA	Stock	0.0885	0.0924	0.0885	0.0906	26640000.0
2000-01-18 12:00:00	NVDA	Stock	0.0911	0.0927	0.0911	0.0924	12480000.0
2000-01-18 13:00:00	NVDA	Stock	0.0919	0.0953	0.0911	0.0943	31200000.0
2000-01-18 14:00:00	NVDA	Stock	0.0943	0.0956	0.0924	0.0944	34464000.0
2000-01-18 15:00:00	NVDA	Stock	0.0947	0.0958	0.0941	0.0954	33984000.0
2000-01-18 09:00:00	AMZN	Stock	3.1719	3.1969	3.15	3.1594	19804000.0
2000-01-18 10:00:00	AMZN	Stock	3.1656	3.2312	3.15	3.1781	19456000.0
2000-01-18 11:00:00	AMZN	Stock	3.1781	3.2	3.1531	3.1625	9530000.0
2000-01-18 12:00:00	AMZN	Stock	3.1625	3.2063	3.1562	3.1969	9388000.0
2000-01-18 13:00:00	AMZN	Stock	3.1969	3.2219	3.175	3.175	7332000.0
2000-01-18 14:00:00	AMZN	Stock	3.1875	3.2	3.1625	3.1719	8280000.0
2000-01-18 15:00:00	AMZN	Stock	3.1688	3.2594	3.1562	3.2078	23666000.0
2000-01-18 16:00:00	AMZN	Stock	3.2078	3.2094	3.2063	3.2063	398000.0
2000-01-18 09:00:00	CL	Stock	31.5312	31.5625	31.0625	31.4688	326800.0
2000-01-18 10:00:00	CL	Stock	31.4375	31.8125	31.125	31.375	571200.0
2000-01-18 11:00:00	CL	Stock	31.375	31.5	31.0312	31.25	522400.0
2000-01-18 12:00:00	CL	Stock	31.25	31.375	31.1875	31.3125	268000.0
2000-01-18 13:00:00	CL	Stock	31.375	31.375	31.0938	31.2188	234400.0
2000-01-18 14:00:00	CL	Stock	31.2188	31.4062	31.0938	31.25	337200.0
2000-01-18 15:00:00	CL	Stock	31.25	31.5938	31.2188	31.5	549200.0
2000-01-18 16:00:00	CL	Stock	31.5	31.5	31.5	31.5	69200.0

> showing 39 of 14,540 rows — these rows as CSV

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