PREVIEW / stock_1hour / 2000-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-02-07.parquet
  size:    280 KB
  rows:    14,440
  symbols: 1,138

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-02-07 09:00:00	AAPL	Stock	0.9643	0.9643	0.9459	0.9598	36568000.0
2000-02-07 10:00:00	AAPL	Stock	0.9607	0.9933	0.9565	0.9833	91347200.0
2000-02-07 11:00:00	AAPL	Stock	0.9833	0.9916	0.9732	0.9908	47230400.0
2000-02-07 12:00:00	AAPL	Stock	0.9911	1.0	0.9866	0.99	42313600.0
2000-02-07 13:00:00	AAPL	Stock	0.9911	0.9994	0.9888	0.9933	26846400.0
2000-02-07 14:00:00	AAPL	Stock	0.9933	1.0045	0.9933	1.0039	58732800.0
2000-02-07 15:00:00	AAPL	Stock	1.0045	1.019	1.0039	1.0179	121060800.0
2000-02-07 16:00:00	AAPL	Stock	1.0184	1.0201	1.0156	1.0184	380800.0
2000-02-07 09:00:00	MSFT	Stock	53.4062	53.4375	52.4062	52.7188	6233800.0
2000-02-07 10:00:00	MSFT	Stock	52.75	53.125	52.5938	52.8125	6191800.0
2000-02-07 11:00:00	MSFT	Stock	52.8438	53.1875	52.6875	52.9688	3966200.0
2000-02-07 12:00:00	MSFT	Stock	52.9688	53.0	52.6562	52.6875	3139000.0
2000-02-07 13:00:00	MSFT	Stock	52.6875	52.8125	52.4375	52.4375	4077400.0
2000-02-07 14:00:00	MSFT	Stock	52.4375	52.625	52.125	52.6094	6000800.0
2000-02-07 15:00:00	MSFT	Stock	52.6094	53.375	52.4062	53.2812	7551800.0
2000-02-07 16:00:00	MSFT	Stock	53.3125	53.3125	53.2812	53.3125	315400.0
2000-02-07 09:00:00	NVDA	Stock	0.0849	0.0849	0.0826	0.0827	18576000.0
2000-02-07 10:00:00	NVDA	Stock	0.0831	0.0833	0.0824	0.0826	19728000.0
2000-02-07 11:00:00	NVDA	Stock	0.0826	0.0833	0.0823	0.0829	34848000.0
2000-02-07 12:00:00	NVDA	Stock	0.0829	0.0831	0.0823	0.0823	21072000.0
2000-02-07 13:00:00	NVDA	Stock	0.0824	0.0826	0.0806	0.0815	27744000.0
2000-02-07 14:00:00	NVDA	Stock	0.0812	0.0818	0.0802	0.0812	11424000.0
2000-02-07 15:00:00	NVDA	Stock	0.081	0.0819	0.0792	0.0792	63744000.0
2000-02-07 16:00:00	NVDA	Stock	0.0793	0.0793	0.0793	0.0793	1008000.0
2000-02-07 09:00:00	AMZN	Stock	3.8094	3.8156	3.7375	3.7812	36318000.0
2000-02-07 10:00:00	AMZN	Stock	3.7812	3.8438	3.7656	3.7906	28034000.0
2000-02-07 11:00:00	AMZN	Stock	3.7906	3.8156	3.775	3.8	11426000.0
2000-02-07 12:00:00	AMZN	Stock	3.8094	3.8188	3.75	3.7688	22460000.0
2000-02-07 13:00:00	AMZN	Stock	3.7719	3.7781	3.7125	3.7188	16574000.0
2000-02-07 14:00:00	AMZN	Stock	3.7188	3.7438	3.6562	3.6688	31470000.0
2000-02-07 15:00:00	AMZN	Stock	3.6688	3.7812	3.6688	3.75	41952000.0
2000-02-07 16:00:00	AMZN	Stock	3.75	3.75	3.7469	3.75	202000.0
2000-02-07 09:00:00	CL	Stock	28.125	28.125	26.7812	26.875	1149000.0
2000-02-07 10:00:00	CL	Stock	26.875	27.4375	26.7812	27.1562	1339800.0
2000-02-07 11:00:00	CL	Stock	27.2188	27.9375	27.1562	27.8125	492400.0
2000-02-07 12:00:00	CL	Stock	27.8125	27.8125	27.3438	27.4375	700400.0
2000-02-07 13:00:00	CL	Stock	27.4375	27.625	27.375	27.5312	606200.0
2000-02-07 14:00:00	CL	Stock	27.5312	27.8438	27.5312	27.7812	630600.0
2000-02-07 15:00:00	CL	Stock	27.8125	28.4062	27.75	28.0938	750000.0
2000-02-07 16:00:00	CL	Stock	28.1875	28.1875	28.1875	28.1875	116400.0

> showing 40 of 14,440 rows — these rows as CSV

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