PREVIEW / stock_1hour / 2000-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-06.parquet
  size:    293 KB
  rows:    15,371
  symbols: 1,193

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-07-06 08:00:00	AAPL	Stock	0.9224	0.9911	0.9224	0.9353	369600.0
2000-07-06 09:00:00	AAPL	Stock	0.9353	0.9453	0.9241	0.9319	16346400.0
2000-07-06 10:00:00	AAPL	Stock	0.9319	0.9342	0.9018	0.904	29243200.0
2000-07-06 11:00:00	AAPL	Stock	0.904	0.9263	0.9018	0.9107	46916800.0
2000-07-06 12:00:00	AAPL	Stock	0.9118	0.9152	0.8951	0.8996	40236000.0
2000-07-06 13:00:00	AAPL	Stock	0.8984	0.9051	0.8929	0.8929	38309600.0
2000-07-06 14:00:00	AAPL	Stock	0.894	0.8973	0.8862	0.8951	45511200.0
2000-07-06 15:00:00	AAPL	Stock	0.8962	0.9252	0.8962	0.9252	80029600.0
2000-07-06 16:00:00	AAPL	Stock	0.9241	0.9252	0.9068	0.9247	5191200.0
2000-07-06 18:00:00	AAPL	Stock	0.923	0.9241	0.923	0.923	33600.0
2000-07-06 08:00:00	MSFT	Stock	39.2812	39.3438	39.2812	39.3438	14400.0
2000-07-06 09:00:00	MSFT	Stock	39.4062	39.8438	39.3125	39.6562	4470400.0
2000-07-06 10:00:00	MSFT	Stock	39.6562	39.7812	39.25	39.3125	5817400.0
2000-07-06 11:00:00	MSFT	Stock	39.3125	39.8438	39.3125	39.75	4766600.0
2000-07-06 12:00:00	MSFT	Stock	39.75	39.8125	39.5938	39.75	3570000.0
2000-07-06 13:00:00	MSFT	Stock	39.75	39.9375	39.7188	39.875	4952800.0
2000-07-06 14:00:00	MSFT	Stock	39.875	40.0312	39.8438	39.9688	8032400.0
2000-07-06 15:00:00	MSFT	Stock	40.0	40.8438	39.9688	40.4375	13684200.0
2000-07-06 16:00:00	MSFT	Stock	40.4375	40.7812	39.9688	40.4688	1528400.0
2000-07-06 17:00:00	MSFT	Stock	40.4688	40.4688	40.4375	40.4688	2400.0
2000-07-06 18:00:00	MSFT	Stock	40.375	40.4062	40.375	40.4062	1800.0
2000-07-06 08:00:00	NVDA	Stock	0.2275	0.2275	0.2275	0.2275	3000000.0
2000-07-06 09:00:00	NVDA	Stock	0.2302	0.2438	0.2273	0.2344	92520000.0
2000-07-06 10:00:00	NVDA	Stock	0.2344	0.2344	0.2221	0.2281	83328000.0
2000-07-06 11:00:00	NVDA	Stock	0.2281	0.2354	0.2276	0.2331	69072000.0
2000-07-06 12:00:00	NVDA	Stock	0.2333	0.2396	0.2323	0.2359	49368000.0
2000-07-06 13:00:00	NVDA	Stock	0.2354	0.2427	0.2354	0.2411	72360000.0
2000-07-06 14:00:00	NVDA	Stock	0.2411	0.2495	0.2365	0.2449	76656000.0
2000-07-06 15:00:00	NVDA	Stock	0.244	0.2469	0.2375	0.2414	124344000.0
2000-07-06 16:00:00	NVDA	Stock	0.2411	0.2438	0.237	0.2436	23328000.0
2000-07-06 17:00:00	NVDA	Stock	0.2375	0.2375	0.2375	0.2375	144000.0
2000-07-06 09:00:00	AMZN	Stock	1.8344	1.85	1.8031	1.825	8240000.0
2000-07-06 10:00:00	AMZN	Stock	1.8219	1.8688	1.7438	1.7562	27714000.0
2000-07-06 11:00:00	AMZN	Stock	1.7594	1.8	1.7375	1.7875	24380000.0
2000-07-06 12:00:00	AMZN	Stock	1.7906	1.8438	1.7844	1.8375	15234000.0
2000-07-06 13:00:00	AMZN	Stock	1.8375	1.8531	1.8156	1.8219	11638000.0
2000-07-06 14:00:00	AMZN	Stock	1.8219	1.8406	1.8	1.8312	12150000.0
2000-07-06 15:00:00	AMZN	Stock	1.8344	1.8562	1.7875	1.8	29004000.0
2000-07-06 16:00:00	AMZN	Stock	1.8031	1.8281	1.7938	1.8281	3326000.0
2000-07-06 17:00:00	AMZN	Stock	1.825	1.825	1.8219	1.8219	24000.0
2000-07-06 18:00:00	AMZN	Stock	1.8125	1.8188	1.8125	1.8188	12000.0
2000-07-06 09:00:00	CL	Stock	29.9375	30.125	29.9062	30.0625	427600.0
2000-07-06 10:00:00	CL	Stock	30.0625	30.0938	29.5	29.5625	634400.0
2000-07-06 11:00:00	CL	Stock	29.5312	29.75	29.5	29.5938	433400.0
2000-07-06 12:00:00	CL	Stock	29.5625	29.75	29.5625	29.75	164000.0
2000-07-06 13:00:00	CL	Stock	29.7188	29.75	29.6562	29.75	176800.0
2000-07-06 14:00:00	CL	Stock	29.75	29.75	29.5625	29.625	252400.0
2000-07-06 15:00:00	CL	Stock	29.625	29.6562	29.375	29.4062	539000.0
2000-07-06 16:00:00	CL	Stock	29.4062	29.4062	29.4062	29.4062	81600.0

> showing 49 of 15,371 rows — these rows as CSV

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