PREVIEW / stock_1hour / 2002-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-03-08.parquet
  size:    384 KB
  rows:    18,201
  symbols: 1,394

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
2002-03-08 08:00:00	AAPL	Stock	0.4234	0.4446	0.4234	0.4445	744800.0
2002-03-08 09:00:00	AAPL	Stock	0.4377	0.4446	0.4377	0.4438	38175200.0
2002-03-08 10:00:00	AAPL	Stock	0.4438	0.4468	0.4427	0.4441	53558400.0
2002-03-08 11:00:00	AAPL	Stock	0.4448	0.4461	0.4413	0.4429	19824000.0
2002-03-08 12:00:00	AAPL	Stock	0.4427	0.448	0.4357	0.4357	34815200.0
2002-03-08 13:00:00	AAPL	Stock	0.4359	0.4425	0.4339	0.4425	34456800.0
2002-03-08 14:00:00	AAPL	Stock	0.4425	0.4455	0.44	0.4414	26370400.0
2002-03-08 15:00:00	AAPL	Stock	0.4414	0.4427	0.4366	0.44	31819200.0
2002-03-08 16:00:00	AAPL	Stock	0.4404	0.4414	0.4393	0.4404	6792800.0
2002-03-08 17:00:00	AAPL	Stock	0.4393	0.4393	0.4393	0.4393	5600.0
2002-03-08 08:00:00	MSFT	Stock	31.375	31.8	31.205	31.6	128800.0
2002-03-08 09:00:00	MSFT	Stock	31.6	32.005	31.5	32.0	8342800.0
2002-03-08 10:00:00	MSFT	Stock	32.0	32.265	31.9	32.16	10912800.0
2002-03-08 11:00:00	MSFT	Stock	32.175	32.315	32.11	32.2695	6124000.0
2002-03-08 12:00:00	MSFT	Stock	32.26	32.35	31.875	31.88	8620600.0
2002-03-08 13:00:00	MSFT	Stock	31.8751	32.17	31.855	32.155	4684600.0
2002-03-08 14:00:00	MSFT	Stock	32.155	32.17	31.755	31.775	5816200.0
2002-03-08 15:00:00	MSFT	Stock	31.78	32.0	31.585	31.97	8250000.0
2002-03-08 16:00:00	MSFT	Stock	31.975	32.0387	31.855	31.94	2339600.0
2002-03-08 17:00:00	MSFT	Stock	31.94	31.995	31.905	31.955	16600.0
2002-03-08 18:00:00	MSFT	Stock	31.955	31.98	31.955	31.98	1400.0
2002-03-08 08:00:00	NVDA	Stock	0.4509	0.4833	0.4509	0.481	1536000.0
2002-03-08 09:00:00	NVDA	Stock	0.4812	0.4868	0.4783	0.4862	199740000.0
2002-03-08 10:00:00	NVDA	Stock	0.4862	0.4957	0.4822	0.4917	321564000.0
2002-03-08 11:00:00	NVDA	Stock	0.4917	0.4928	0.485	0.4912	161820000.0
2002-03-08 12:00:00	NVDA	Stock	0.4916	0.494	0.4859	0.4867	111744000.0
2002-03-08 13:00:00	NVDA	Stock	0.4865	0.4901	0.4854	0.488	104028000.0
2002-03-08 14:00:00	NVDA	Stock	0.4884	0.4937	0.487	0.4879	124272000.0
2002-03-08 15:00:00	NVDA	Stock	0.4883	0.489	0.4831	0.4851	155856000.0
2002-03-08 16:00:00	NVDA	Stock	0.4852	0.4887	0.485	0.4867	22920000.0
2002-03-08 17:00:00	NVDA	Stock	0.4862	0.4867	0.4846	0.4846	636000.0
2002-03-08 18:00:00	NVDA	Stock	0.4861	0.4862	0.4861	0.4862	216000.0
2002-03-08 08:00:00	AMZN	Stock	0.779	0.819	0.779	0.795	510000.0
2002-03-08 09:00:00	AMZN	Stock	0.7995	0.8345	0.7995	0.8275	31272000.0
2002-03-08 10:00:00	AMZN	Stock	0.8275	0.848	0.8175	0.8185	49310000.0
2002-03-08 11:00:00	AMZN	Stock	0.8185	0.829	0.8124	0.8205	22516000.0
2002-03-08 12:00:00	AMZN	Stock	0.82	0.829	0.8135	0.816	10012000.0
2002-03-08 13:00:00	AMZN	Stock	0.816	0.8235	0.816	0.8214	8546000.0
2002-03-08 14:00:00	AMZN	Stock	0.8215	0.825	0.813	0.8145	12756000.0
2002-03-08 15:00:00	AMZN	Stock	0.8145	0.82	0.7965	0.8175	39540000.0
2002-03-08 16:00:00	AMZN	Stock	0.8175	0.823	0.8105	0.8175	3156000.0
2002-03-08 17:00:00	AMZN	Stock	0.82	0.82	0.813	0.815	86000.0
2002-03-08 18:00:00	AMZN	Stock	0.821	0.822	0.821	0.822	12000.0
2002-03-08 09:00:00	CL	Stock	27.25	27.4	27.125	27.3	438600.0
2002-03-08 10:00:00	CL	Stock	27.31	27.35	27.055	27.09	672800.0
2002-03-08 11:00:00	CL	Stock	27.095	27.175	26.935	27.025	637000.0
2002-03-08 12:00:00	CL	Stock	27.005	27.15	26.995	27.07	727400.0
2002-03-08 13:00:00	CL	Stock	27.06	27.075	26.99	27.0	390000.0
2002-03-08 14:00:00	CL	Stock	27.0	27.1	26.975	27.015	735600.0
2002-03-08 15:00:00	CL	Stock	27.015	27.16	26.975	27.13	728000.0

> showing 50 of 18,201 rows — these rows as CSV

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