PREVIEW / stock_1hour / 2004-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-29.parquet
  size:    527 KB
  rows:    25,000
  symbols: 1,791

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-06-29 08:00:00	AAPL	Stock	0.5759	0.5821	0.5734	0.5741	411600.0
2004-06-29 09:00:00	AAPL	Stock	0.5745	0.5745	0.5609	0.57	118685560.0
2004-06-29 10:00:00	AAPL	Stock	0.5702	0.5705	0.5646	0.5693	117076736.0
2004-06-29 11:00:00	AAPL	Stock	0.5695	0.5727	0.5689	0.5705	50556408.0
2004-06-29 12:00:00	AAPL	Stock	0.5707	0.5723	0.5696	0.5709	43530760.0
2004-06-29 13:00:00	AAPL	Stock	0.5709	0.5732	0.5704	0.5728	30721712.0
2004-06-29 14:00:00	AAPL	Stock	0.573	0.5755	0.5723	0.5739	75787320.0
2004-06-29 15:00:00	AAPL	Stock	0.5741	0.5891	0.5737	0.5802	97727056.0
2004-06-29 16:00:00	AAPL	Stock	0.5802	0.5804	0.5745	0.5804	8043672.0
2004-06-29 17:00:00	AAPL	Stock	0.58	0.5804	0.58	0.5802	141120.0
2004-06-29 08:00:00	MSFT	Stock	28.47	28.47	28.2263	28.25	123791.0
2004-06-29 09:00:00	MSFT	Stock	28.28	28.52	28.18	28.45	5152595.0
2004-06-29 10:00:00	MSFT	Stock	28.4481	28.58	28.44	28.487	8704389.0
2004-06-29 11:00:00	MSFT	Stock	28.49	28.5	28.41	28.46	7629985.0
2004-06-29 12:00:00	MSFT	Stock	28.47	28.5	28.42	28.431	5850787.0
2004-06-29 13:00:00	MSFT	Stock	28.44	28.47	28.37	28.46	5882054.0
2004-06-29 14:00:00	MSFT	Stock	28.46	28.53	28.42	28.53	8005476.0
2004-06-29 15:00:00	MSFT	Stock	28.53	28.55	28.45	28.5	10267541.0
2004-06-29 16:00:00	MSFT	Stock	28.5	29.0	28.47	28.57	1383371.0
2004-06-29 17:00:00	MSFT	Stock	28.57	28.61	28.46	28.56	114346.0
2004-06-29 18:00:00	MSFT	Stock	28.6	28.6	28.6	28.6	500.0
2004-06-29 09:00:00	NVDA	Stock	0.1673	0.1697	0.1673	0.1692	34818360.0
2004-06-29 10:00:00	NVDA	Stock	0.1693	0.1722	0.1692	0.172	75496080.0
2004-06-29 11:00:00	NVDA	Stock	0.172	0.1732	0.1719	0.173	59688840.0
2004-06-29 12:00:00	NVDA	Stock	0.173	0.1733	0.1712	0.1715	46690200.0
2004-06-29 13:00:00	NVDA	Stock	0.1715	0.1719	0.1707	0.1715	19701240.0
2004-06-29 14:00:00	NVDA	Stock	0.1716	0.1729	0.1712	0.1726	38398080.0
2004-06-29 15:00:00	NVDA	Stock	0.1727	0.1733	0.1722	0.1733	78084720.0
2004-06-29 16:00:00	NVDA	Stock	0.1733	0.1733	0.1719	0.1719	3161280.0
2004-06-29 17:00:00	NVDA	Stock	0.1731	0.1731	0.1724	0.1724	761760.0
2004-06-29 08:00:00	AMZN	Stock	2.676	2.676	2.661	2.661	159400.0
2004-06-29 09:00:00	AMZN	Stock	2.664	2.677	2.645	2.6595	23906120.0
2004-06-29 10:00:00	AMZN	Stock	2.6605	2.67	2.6325	2.6365	36605940.0
2004-06-29 11:00:00	AMZN	Stock	2.6365	2.664	2.6355	2.6605	18485720.0
2004-06-29 12:00:00	AMZN	Stock	2.6615	2.697	2.661	2.6846	25626460.0
2004-06-29 13:00:00	AMZN	Stock	2.6848	2.6895	2.669	2.678	14008960.0
2004-06-29 14:00:00	AMZN	Stock	2.678	2.692	2.67	2.6835	15856940.0
2004-06-29 15:00:00	AMZN	Stock	2.6825	2.689	2.671	2.6855	27431720.0
2004-06-29 16:00:00	AMZN	Stock	2.6855	2.687	2.6695	2.6855	3002580.0
2004-06-29 17:00:00	AMZN	Stock	2.685	2.6905	2.685	2.6855	119840.0
2004-06-29 09:00:00	CL	Stock	28.885	29.005	28.85	29.0	186600.0
2004-06-29 10:00:00	CL	Stock	29.0	29.17	28.975	29.08	346200.0
2004-06-29 11:00:00	CL	Stock	29.075	29.375	29.06	29.35	421400.0
2004-06-29 12:00:00	CL	Stock	29.355	29.375	29.31	29.35	299400.0
2004-06-29 13:00:00	CL	Stock	29.35	29.4	29.345	29.35	386200.0
2004-06-29 14:00:00	CL	Stock	29.35	29.4	29.325	29.395	525000.0
2004-06-29 15:00:00	CL	Stock	29.395	29.4	29.255	29.305	837000.0
2004-06-29 16:00:00	CL	Stock	29.3	29.3	29.3	29.3	2800.0
2004-06-29 17:00:00	CL	Stock	29.3	29.3	29.3	29.3	800.0

> showing 49 of 25,000 rows — these rows as CSV

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