PREVIEW / stock_1hour / 2004-02-20

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-02-20.parquet
  size:    506 KB
  rows:    23,341
  symbols: 1,722

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
2004-02-20 08:00:00	AAPL	Stock	0.3972	0.4018	0.3972	0.4018	313600.0
2004-02-20 09:00:00	AAPL	Stock	0.4002	0.4018	0.3979	0.3979	36257816.0
2004-02-20 10:00:00	AAPL	Stock	0.3979	0.4011	0.3966	0.3986	47857544.0
2004-02-20 11:00:00	AAPL	Stock	0.3988	0.4011	0.3986	0.4009	22666168.0
2004-02-20 12:00:00	AAPL	Stock	0.4007	0.4009	0.398	0.3986	26110168.0
2004-02-20 13:00:00	AAPL	Stock	0.3986	0.3998	0.3975	0.3991	28461440.0
2004-02-20 14:00:00	AAPL	Stock	0.3995	0.402	0.3993	0.4007	42684544.0
2004-02-20 15:00:00	AAPL	Stock	0.4009	0.4011	0.3984	0.3989	55402592.0
2004-02-20 16:00:00	AAPL	Stock	0.3988	0.4002	0.3979	0.3998	7075936.0
2004-02-20 17:00:00	AAPL	Stock	0.3998	0.3998	0.3993	0.3993	43848.0
2004-02-20 18:00:00	AAPL	Stock	0.4013	0.4013	0.4013	0.4013	5600.0
2004-02-20 08:00:00	MSFT	Stock	26.58	26.6	26.54	26.55	23816.0
2004-02-20 09:00:00	MSFT	Stock	26.52	26.66	26.5	26.62	8650793.0
2004-02-20 10:00:00	MSFT	Stock	26.62	26.73	26.51	26.64	9013814.0
2004-02-20 11:00:00	MSFT	Stock	26.63	26.7	26.59	26.68	4902644.0
2004-02-20 12:00:00	MSFT	Stock	26.68	26.7	26.55	26.55	4483118.0
2004-02-20 13:00:00	MSFT	Stock	26.55	26.65	26.54	26.63	6133059.0
2004-02-20 14:00:00	MSFT	Stock	26.63	26.75	26.61	26.64	9440546.0
2004-02-20 15:00:00	MSFT	Stock	26.649	26.66	26.57	26.6	9327474.0
2004-02-20 16:00:00	MSFT	Stock	26.59	26.65	26.53	26.6	1719706.0
2004-02-20 17:00:00	MSFT	Stock	26.6	26.6	26.57	26.6	37826.0
2004-02-20 18:00:00	MSFT	Stock	26.6	26.6	26.6	26.6	1628.0
2004-02-20 08:00:00	NVDA	Stock	0.1959	0.1965	0.1959	0.1965	27360.0
2004-02-20 09:00:00	NVDA	Stock	0.1965	0.1984	0.1955	0.1957	68462880.0
2004-02-20 10:00:00	NVDA	Stock	0.1957	0.1972	0.1954	0.1961	120700440.0
2004-02-20 11:00:00	NVDA	Stock	0.1961	0.1969	0.1959	0.1962	35954280.0
2004-02-20 12:00:00	NVDA	Stock	0.1962	0.1966	0.1952	0.1952	58720920.0
2004-02-20 13:00:00	NVDA	Stock	0.1952	0.1978	0.1948	0.1972	81272160.0
2004-02-20 14:00:00	NVDA	Stock	0.1972	0.2017	0.1969	0.2003	95269080.0
2004-02-20 15:00:00	NVDA	Stock	0.2002	0.2012	0.1993	0.2007	130301160.0
2004-02-20 16:00:00	NVDA	Stock	0.2013	0.2015	0.2004	0.2012	6749880.0
2004-02-20 17:00:00	NVDA	Stock	0.2004	0.2012	0.2001	0.2008	470040.0
2004-02-20 08:00:00	AMZN	Stock	2.246	2.246	2.235	2.235	35000.0
2004-02-20 09:00:00	AMZN	Stock	2.24	2.2605	2.235	2.252	24583900.0
2004-02-20 10:00:00	AMZN	Stock	2.2525	2.2635	2.2365	2.246	29181240.0
2004-02-20 11:00:00	AMZN	Stock	2.246	2.2595	2.243	2.2567	13197660.0
2004-02-20 12:00:00	AMZN	Stock	2.2554	2.2555	2.2405	2.241	7783240.0
2004-02-20 13:00:00	AMZN	Stock	2.242	2.264	2.2415	2.259	13361940.0
2004-02-20 14:00:00	AMZN	Stock	2.2595	2.269	2.2565	2.257	24922240.0
2004-02-20 15:00:00	AMZN	Stock	2.257	2.2605	2.2465	2.26	28318680.0
2004-02-20 16:00:00	AMZN	Stock	2.2605	2.2615	2.25	2.25	2019340.0
2004-02-20 17:00:00	AMZN	Stock	2.2605	2.2605	2.25	2.2552	97660.0
2004-02-20 18:00:00	AMZN	Stock	2.257	2.2575	2.257	2.257	28000.0
2004-02-20 09:00:00	CL	Stock	28.325	28.325	28.075	28.085	512600.0
2004-02-20 10:00:00	CL	Stock	28.1	28.52	28.075	28.215	995800.0
2004-02-20 11:00:00	CL	Stock	28.21	28.285	28.06	28.085	479000.0
2004-02-20 12:00:00	CL	Stock	28.075	28.11	28.005	28.015	575400.0
2004-02-20 13:00:00	CL	Stock	28.02	28.07	27.975	28.015	401800.0
2004-02-20 14:00:00	CL	Stock	28.02	28.1	27.98	27.98	542800.0
2004-02-20 15:00:00	CL	Stock	27.98	28.075	27.955	28.025	708800.0

> showing 50 of 23,341 rows — these rows as CSV

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