PREVIEW / stock_1hour / 2001-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-05.parquet
  size:    315 KB
  rows:    16,264
  symbols: 1,256

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-05 08:00:00	AAPL	Stock	0.3058	0.3125	0.3036	0.3036	845600.0
2001-01-05 09:00:00	AAPL	Stock	0.2991	0.3036	0.2946	0.2969	44324000.0
2001-01-05 10:00:00	AAPL	Stock	0.2969	0.3103	0.2958	0.298	78943200.0
2001-01-05 11:00:00	AAPL	Stock	0.298	0.2991	0.2868	0.2919	113864800.0
2001-01-05 12:00:00	AAPL	Stock	0.2913	0.3002	0.2902	0.2969	39440800.0
2001-01-05 13:00:00	AAPL	Stock	0.2958	0.298	0.2946	0.2958	13440000.0
2001-01-05 14:00:00	AAPL	Stock	0.2958	0.2969	0.2891	0.2924	26728800.0
2001-01-05 15:00:00	AAPL	Stock	0.2924	0.2958	0.2879	0.2924	55384000.0
2001-01-05 16:00:00	AAPL	Stock	0.2924	0.2946	0.2891	0.2924	7834400.0
2001-01-05 17:00:00	AAPL	Stock	0.2935	0.2935	0.2902	0.2902	39200.0
2001-01-05 18:00:00	AAPL	Stock	0.2924	0.2946	0.2924	0.2946	16800.0
2001-01-05 08:00:00	MSFT	Stock	24.5312	24.5625	23.75	23.75	155200.0
2001-01-05 09:00:00	MSFT	Stock	23.7812	24.6562	23.75	24.2188	13500800.0
2001-01-05 10:00:00	MSFT	Stock	24.2188	24.75	24.1875	24.625	15115000.0
2001-01-05 11:00:00	MSFT	Stock	24.5938	24.6562	24.2812	24.5312	14551000.0
2001-01-05 12:00:00	MSFT	Stock	24.5	24.9375	24.4062	24.6875	8209600.0
2001-01-05 13:00:00	MSFT	Stock	24.6562	24.8125	24.625	24.6562	5555400.0
2001-01-05 14:00:00	MSFT	Stock	24.6562	24.75	24.3125	24.3438	8260000.0
2001-01-05 15:00:00	MSFT	Stock	24.3438	24.6875	23.9688	24.5	16933000.0
2001-01-05 16:00:00	MSFT	Stock	24.5156	24.5938	24.2812	24.5312	5123400.0
2001-01-05 17:00:00	MSFT	Stock	24.5312	24.5625	24.375	24.5625	39800.0
2001-01-05 18:00:00	MSFT	Stock	24.5312	24.625	24.5	24.5938	8000.0
2001-01-05 08:00:00	NVDA	Stock	0.1875	0.1875	0.1802	0.1833	576000.0
2001-01-05 09:00:00	NVDA	Stock	0.1802	0.1813	0.1656	0.1711	39072000.0
2001-01-05 10:00:00	NVDA	Stock	0.1719	0.1807	0.1688	0.1719	88296000.0
2001-01-05 11:00:00	NVDA	Stock	0.1729	0.1729	0.1604	0.1651	91608000.0
2001-01-05 12:00:00	NVDA	Stock	0.1635	0.1667	0.1615	0.162	30816000.0
2001-01-05 13:00:00	NVDA	Stock	0.162	0.1638	0.1583	0.1633	31536000.0
2001-01-05 14:00:00	NVDA	Stock	0.1625	0.1635	0.1586	0.1594	32760000.0
2001-01-05 15:00:00	NVDA	Stock	0.1583	0.1599	0.151	0.1547	74712000.0
2001-01-05 16:00:00	NVDA	Stock	0.1546	0.1625	0.1523	0.1526	4056000.0
2001-01-05 18:00:00	NVDA	Stock	0.1542	0.1542	0.154	0.154	72000.0
2001-01-05 08:00:00	AMZN	Stock	0.7875	0.7875	0.7719	0.7812	174000.0
2001-01-05 09:00:00	AMZN	Stock	0.7812	0.7938	0.7031	0.7062	20068000.0
2001-01-05 10:00:00	AMZN	Stock	0.7031	0.7563	0.7031	0.7125	31890000.0
2001-01-05 11:00:00	AMZN	Stock	0.7125	0.725	0.6781	0.725	32320000.0
2001-01-05 12:00:00	AMZN	Stock	0.7219	0.7406	0.7062	0.7313	12394000.0
2001-01-05 13:00:00	AMZN	Stock	0.7297	0.7344	0.7031	0.7062	8328000.0
2001-01-05 14:00:00	AMZN	Stock	0.7062	0.7188	0.7062	0.7125	16884000.0
2001-01-05 15:00:00	AMZN	Stock	0.7125	0.7406	0.7062	0.725	28176000.0
2001-01-05 16:00:00	AMZN	Stock	0.725	0.7281	0.7078	0.7094	11108000.0
2001-01-05 17:00:00	AMZN	Stock	0.7219	0.7219	0.7094	0.7156	28000.0
2001-01-05 18:00:00	AMZN	Stock	0.7094	0.7094	0.7094	0.7094	20000.0
2001-01-05 09:00:00	CL	Stock	28.45	28.625	28.395	28.455	644200.0
2001-01-05 10:00:00	CL	Stock	28.455	29.225	28.45	29.06	1199800.0
2001-01-05 11:00:00	CL	Stock	29.075	29.185	28.925	28.925	357200.0
2001-01-05 12:00:00	CL	Stock	28.925	28.95	28.7	28.725	780600.0
2001-01-05 13:00:00	CL	Stock	28.725	28.8	28.6	28.69	392800.0
2001-01-05 14:00:00	CL	Stock	28.69	28.775	28.62	28.745	321400.0
2001-01-05 15:00:00	CL	Stock	28.745	28.9	28.65	28.835	773600.0

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

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