PREVIEW / stock_1hour / 2000-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-17.parquet
  size:    288 KB
  rows:    15,220
  symbols: 1,215

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-08-17 08:00:00	AAPL	Stock	0.8661	0.875	0.8638	0.8683	207200.0
2000-08-17 09:00:00	AAPL	Stock	0.8661	0.8884	0.8616	0.8839	36159200.0
2000-08-17 10:00:00	AAPL	Stock	0.8839	0.8929	0.8728	0.8917	48160000.0
2000-08-17 11:00:00	AAPL	Stock	0.8929	0.9007	0.8906	0.894	17796800.0
2000-08-17 12:00:00	AAPL	Stock	0.8951	0.9029	0.8895	0.8962	13199200.0
2000-08-17 13:00:00	AAPL	Stock	0.8962	0.9063	0.8951	0.9018	16620800.0
2000-08-17 14:00:00	AAPL	Stock	0.9018	0.9208	0.8996	0.9185	35576800.0
2000-08-17 15:00:00	AAPL	Stock	0.9185	0.9364	0.9174	0.9236	85792000.0
2000-08-17 16:00:00	AAPL	Stock	0.9196	0.933	0.8633	0.9185	12174400.0
2000-08-17 17:00:00	AAPL	Stock	0.9258	0.9286	0.9185	0.9185	84000.0
2000-08-17 08:00:00	MSFT	Stock	35.75	35.75	35.4375	35.4688	14800.0
2000-08-17 09:00:00	MSFT	Stock	35.4688	35.5938	35.2812	35.4688	3162400.0
2000-08-17 10:00:00	MSFT	Stock	35.4375	35.8125	35.2812	35.75	8265400.0
2000-08-17 11:00:00	MSFT	Stock	35.75	35.7812	35.6562	35.75	5341400.0
2000-08-17 12:00:00	MSFT	Stock	35.75	35.8125	35.5938	35.5938	2890400.0
2000-08-17 13:00:00	MSFT	Stock	35.625	35.75	35.4688	35.6562	3459400.0
2000-08-17 14:00:00	MSFT	Stock	35.625	35.6875	35.5625	35.625	3078800.0
2000-08-17 15:00:00	MSFT	Stock	35.6562	36.0	35.625	35.7812	6925400.0
2000-08-17 16:00:00	MSFT	Stock	35.8125	35.875	35.6406	35.7812	2305000.0
2000-08-17 17:00:00	MSFT	Stock	35.6875	35.8594	35.0	35.8594	56600.0
2000-08-17 08:00:00	NVDA	Stock	0.3042	0.3042	0.3042	0.3042	96000.0
2000-08-17 09:00:00	NVDA	Stock	0.3021	0.3068	0.299	0.3021	17760000.0
2000-08-17 10:00:00	NVDA	Stock	0.3039	0.3089	0.299	0.3083	26328000.0
2000-08-17 11:00:00	NVDA	Stock	0.3063	0.3083	0.3042	0.3057	9360000.0
2000-08-17 12:00:00	NVDA	Stock	0.3057	0.306	0.3042	0.3055	6288000.0
2000-08-17 13:00:00	NVDA	Stock	0.3055	0.306	0.3042	0.3042	10104000.0
2000-08-17 14:00:00	NVDA	Stock	0.3044	0.3063	0.3042	0.3049	11880000.0
2000-08-17 15:00:00	NVDA	Stock	0.3057	0.3115	0.3052	0.3099	45432000.0
2000-08-17 16:00:00	NVDA	Stock	0.3099	0.3099	0.3089	0.3099	1776000.0
2000-08-17 08:00:00	AMZN	Stock	1.925	1.925	1.85	1.9031	112000.0
2000-08-17 09:00:00	AMZN	Stock	1.9	1.9312	1.8969	1.9	14946000.0
2000-08-17 10:00:00	AMZN	Stock	1.9	1.9469	1.8969	1.9281	17302000.0
2000-08-17 11:00:00	AMZN	Stock	1.925	1.9281	1.8625	1.8719	11544000.0
2000-08-17 12:00:00	AMZN	Stock	1.8688	1.875	1.8438	1.8625	11424000.0
2000-08-17 13:00:00	AMZN	Stock	1.8625	1.8938	1.8594	1.8812	10214000.0
2000-08-17 14:00:00	AMZN	Stock	1.8781	1.8969	1.875	1.8938	7462000.0
2000-08-17 15:00:00	AMZN	Stock	1.8938	1.9312	1.8906	1.9062	22986000.0
2000-08-17 16:00:00	AMZN	Stock	1.9031	1.9219	1.8781	1.9219	2356000.0
2000-08-17 17:00:00	AMZN	Stock	1.9219	1.925	1.9125	1.9156	116000.0
2000-08-17 18:00:00	AMZN	Stock	1.9125	1.9125	1.9125	1.9125	4000.0
2000-08-17 09:00:00	CL	Stock	26.9688	26.9688	26.75	26.75	185800.0
2000-08-17 10:00:00	CL	Stock	26.7812	26.9375	26.6875	26.7188	253800.0
2000-08-17 11:00:00	CL	Stock	26.7188	26.7188	26.0625	26.125	455600.0
2000-08-17 12:00:00	CL	Stock	26.1562	26.1562	25.8125	26.0312	825000.0
2000-08-17 13:00:00	CL	Stock	26.0312	26.0312	25.8438	25.9062	265400.0
2000-08-17 14:00:00	CL	Stock	25.9062	26.3438	25.9062	26.125	384400.0
2000-08-17 15:00:00	CL	Stock	26.125	26.4375	26.125	26.3125	814200.0
2000-08-17 16:00:00	CL	Stock	26.3438	26.375	26.3438	26.375	146600.0
2000-08-17 17:00:00	CL	Stock	26.375	26.375	26.375	26.375	4000.0

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

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