PREVIEW / stock_1hour / 2000-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-05-04.parquet
  size:    274 KB
  rows:    13,899
  symbols: 1,151

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-05-04 09:00:00	AAPL	Stock	1.0279	1.0279	1.0028	1.014	67312000.0
2000-05-04 10:00:00	AAPL	Stock	1.014	1.0257	1.01	1.0112	82163200.0
2000-05-04 11:00:00	AAPL	Stock	1.0131	1.0201	1.0095	1.0106	22713600.0
2000-05-04 12:00:00	AAPL	Stock	1.0106	1.012	1.0	1.0039	42448000.0
2000-05-04 13:00:00	AAPL	Stock	1.0039	1.0056	0.9961	0.9983	29052800.0
2000-05-04 14:00:00	AAPL	Stock	0.9983	1.0078	0.9922	0.9967	36545600.0
2000-05-04 15:00:00	AAPL	Stock	0.9978	1.0	0.9872	0.9877	104921600.0
2000-05-04 16:00:00	AAPL	Stock	0.9883	0.99	0.9883	0.9883	380800.0
2000-05-04 09:00:00	MSFT	Stock	35.1562	35.1875	34.6562	34.875	6820800.0
2000-05-04 10:00:00	MSFT	Stock	34.9062	35.125	34.7812	34.9375	7109000.0
2000-05-04 11:00:00	MSFT	Stock	34.9375	35.125	34.8125	35.0	5348800.0
2000-05-04 12:00:00	MSFT	Stock	34.9688	35.0938	34.875	35.0938	3371000.0
2000-05-04 13:00:00	MSFT	Stock	35.0625	35.125	34.9062	35.0625	3877600.0
2000-05-04 14:00:00	MSFT	Stock	35.0312	35.2812	34.9375	35.1562	5856200.0
2000-05-04 15:00:00	MSFT	Stock	35.125	35.625	35.0938	35.2188	6522400.0
2000-05-04 16:00:00	MSFT	Stock	35.25	35.2812	35.2188	35.2812	211400.0
2000-05-04 09:00:00	NVDA	Stock	0.1809	0.1862	0.1793	0.1862	18336000.0
2000-05-04 10:00:00	NVDA	Stock	0.1855	0.1911	0.185	0.1852	73680000.0
2000-05-04 11:00:00	NVDA	Stock	0.1854	0.1872	0.1831	0.1831	18240000.0
2000-05-04 12:00:00	NVDA	Stock	0.1831	0.1855	0.1823	0.1853	39696000.0
2000-05-04 13:00:00	NVDA	Stock	0.1854	0.1865	0.1853	0.1857	19824000.0
2000-05-04 14:00:00	NVDA	Stock	0.1857	0.1858	0.1844	0.185	19440000.0
2000-05-04 15:00:00	NVDA	Stock	0.1844	0.1849	0.1826	0.1835	31728000.0
2000-05-04 09:00:00	AMZN	Stock	2.7125	2.7875	2.6562	2.7531	10152000.0
2000-05-04 10:00:00	AMZN	Stock	2.7594	2.825	2.7375	2.7719	18296000.0
2000-05-04 11:00:00	AMZN	Stock	2.775	2.8	2.75	2.7531	7566000.0
2000-05-04 12:00:00	AMZN	Stock	2.7562	2.7625	2.7125	2.7438	10880000.0
2000-05-04 13:00:00	AMZN	Stock	2.7438	2.75	2.725	2.75	10390000.0
2000-05-04 14:00:00	AMZN	Stock	2.7469	2.75	2.6688	2.6813	17576000.0
2000-05-04 15:00:00	AMZN	Stock	2.6828	2.7906	2.675	2.7562	15408000.0
2000-05-04 16:00:00	AMZN	Stock	2.7625	2.7625	2.75	2.7531	348000.0
2000-05-04 09:00:00	CL	Stock	27.875	27.875	27.625	27.8438	194000.0
2000-05-04 10:00:00	CL	Stock	27.8438	27.9062	27.7812	27.7812	205400.0
2000-05-04 11:00:00	CL	Stock	27.7812	27.9375	27.75	27.7812	283400.0
2000-05-04 12:00:00	CL	Stock	27.7812	27.875	27.7812	27.8125	198000.0
2000-05-04 13:00:00	CL	Stock	27.8125	27.9062	27.7812	27.8438	132400.0
2000-05-04 14:00:00	CL	Stock	27.8438	27.9375	27.7188	27.9375	342000.0
2000-05-04 15:00:00	CL	Stock	27.875	28.0312	27.875	27.9688	528200.0
2000-05-04 16:00:00	CL	Stock	27.9375	27.9688	27.9375	27.9688	120400.0

> showing 39 of 13,899 rows — these rows as CSV

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