PREVIEW / stock_1hour / 2000-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-01-19.parquet
  size:    284 KB
  rows:    14,558
  symbols: 1,131

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-19 09:00:00	AAPL	Stock	0.9431	0.971	0.9263	0.9464	74054400.0
2000-01-19 10:00:00	AAPL	Stock	0.947	0.947	0.923	0.9408	91672000.0
2000-01-19 11:00:00	AAPL	Stock	0.9408	0.9453	0.9286	0.9397	47857600.0
2000-01-19 12:00:00	AAPL	Stock	0.9397	0.9548	0.9397	0.9526	54320000.0
2000-01-19 13:00:00	AAPL	Stock	0.952	0.9565	0.9431	0.9453	42683200.0
2000-01-19 14:00:00	AAPL	Stock	0.9464	0.9554	0.942	0.9548	62630400.0
2000-01-19 15:00:00	AAPL	Stock	0.9537	0.9587	0.942	0.9531	173745600.0
2000-01-19 16:00:00	AAPL	Stock	0.9531	0.9554	0.9503	0.9515	1052800.0
2000-01-19 09:00:00	MSFT	Stock	55.25	55.75	54.375	54.6875	18774400.0
2000-01-19 10:00:00	MSFT	Stock	54.6875	54.9375	54.0625	54.75	21354400.0
2000-01-19 11:00:00	MSFT	Stock	54.7812	54.9062	54.25	54.5	9071000.0
2000-01-19 12:00:00	MSFT	Stock	54.5312	54.9375	54.5	54.6875	5639800.0
2000-01-19 13:00:00	MSFT	Stock	54.6875	54.75	54.3125	54.4375	5830600.0
2000-01-19 14:00:00	MSFT	Stock	54.4688	54.4688	54.0312	54.1562	7438600.0
2000-01-19 15:00:00	MSFT	Stock	54.1562	54.1562	53.0	53.5312	21335800.0
2000-01-19 16:00:00	MSFT	Stock	53.5312	53.5625	53.3125	53.5	256000.0
2000-01-19 09:00:00	NVDA	Stock	0.0958	0.0958	0.0945	0.0945	24240000.0
2000-01-19 10:00:00	NVDA	Stock	0.0945	0.0958	0.0944	0.0945	14256000.0
2000-01-19 11:00:00	NVDA	Stock	0.0945	0.0951	0.0937	0.0943	29424000.0
2000-01-19 12:00:00	NVDA	Stock	0.0939	0.0945	0.0939	0.0943	29040000.0
2000-01-19 13:00:00	NVDA	Stock	0.0945	0.0958	0.094	0.0957	15936000.0
2000-01-19 14:00:00	NVDA	Stock	0.0956	0.0958	0.0951	0.0953	20928000.0
2000-01-19 15:00:00	NVDA	Stock	0.0953	0.0956	0.0945	0.0945	21696000.0
2000-01-19 09:00:00	AMZN	Stock	3.2063	3.225	3.15	3.1625	18086000.0
2000-01-19 10:00:00	AMZN	Stock	3.1688	3.2063	3.15	3.1938	34792000.0
2000-01-19 11:00:00	AMZN	Stock	3.1969	3.325	3.1906	3.25	39788000.0
2000-01-19 12:00:00	AMZN	Stock	3.2531	3.3375	3.2438	3.3344	13296000.0
2000-01-19 13:00:00	AMZN	Stock	3.3312	3.3562	3.3031	3.3438	15536000.0
2000-01-19 14:00:00	AMZN	Stock	3.3438	3.375	3.3062	3.3531	20130000.0
2000-01-19 15:00:00	AMZN	Stock	3.35	3.3594	3.3	3.3375	18638000.0
2000-01-19 16:00:00	AMZN	Stock	3.3375	3.3406	3.3344	3.3406	246000.0
2000-01-19 09:00:00	CL	Stock	31.5	31.5625	31.4062	31.5625	288600.0
2000-01-19 10:00:00	CL	Stock	31.5625	31.625	31.375	31.5625	284400.0
2000-01-19 11:00:00	CL	Stock	31.5312	31.5312	31.125	31.2188	285400.0
2000-01-19 12:00:00	CL	Stock	31.2188	31.5	31.2188	31.375	233400.0
2000-01-19 13:00:00	CL	Stock	31.375	31.4375	31.2188	31.3125	265800.0
2000-01-19 14:00:00	CL	Stock	31.3125	31.3125	30.7812	30.875	361400.0
2000-01-19 15:00:00	CL	Stock	30.8125	30.8125	30.5625	30.75	618000.0
2000-01-19 16:00:00	CL	Stock	30.75	30.75	30.75	30.75	103400.0

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

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