PREVIEW / stock_1hour / 2004-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-16.parquet
  size:    495 KB
  rows:    23,479
  symbols: 1,816

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-08-16 08:00:00	AAPL	Stock	0.5509	0.5509	0.5509	0.5509	212800.0
2004-08-16 09:00:00	AAPL	Stock	0.5511	0.5611	0.5507	0.5589	29773688.0
2004-08-16 10:00:00	AAPL	Stock	0.5589	0.5664	0.5571	0.5593	65884840.0
2004-08-16 11:00:00	AAPL	Stock	0.5591	0.5659	0.5591	0.5648	32296712.0
2004-08-16 12:00:00	AAPL	Stock	0.5646	0.5655	0.5621	0.5625	32533256.0
2004-08-16 13:00:00	AAPL	Stock	0.5625	0.5629	0.5593	0.5627	24668112.0
2004-08-16 14:00:00	AAPL	Stock	0.5627	0.5655	0.5523	0.5557	102954712.0
2004-08-16 15:00:00	AAPL	Stock	0.5561	0.5573	0.5471	0.55	98656208.0
2004-08-16 16:00:00	AAPL	Stock	0.5496	0.55	0.5464	0.5482	8712536.0
2004-08-16 17:00:00	AAPL	Stock	0.5477	0.5477	0.5477	0.5477	22400.0
2004-08-16 18:00:00	AAPL	Stock	0.5482	0.5482	0.5482	0.5482	95200.0
2004-08-16 08:00:00	MSFT	Stock	27.15	27.15	27.1	27.13	17640.0
2004-08-16 09:00:00	MSFT	Stock	27.13	27.15	26.985	27.101	6212348.0
2004-08-16 10:00:00	MSFT	Stock	27.11	27.2	27.05	27.099	7966806.0
2004-08-16 11:00:00	MSFT	Stock	27.1	27.15	27.02	27.04	5701504.0
2004-08-16 12:00:00	MSFT	Stock	27.04	27.07	26.97	27.05	4906090.0
2004-08-16 13:00:00	MSFT	Stock	27.05	27.12	26.97	27.02	4675414.0
2004-08-16 14:00:00	MSFT	Stock	27.03	27.171	27.02	27.15	5986896.0
2004-08-16 15:00:00	MSFT	Stock	27.16	27.17	27.06	27.07	9011696.0
2004-08-16 16:00:00	MSFT	Stock	27.08	27.11	27.04	27.09	8685110.0
2004-08-16 17:00:00	MSFT	Stock	27.08	27.09	27.06	27.06	13347.0
2004-08-16 18:00:00	MSFT	Stock	27.08	27.08	27.07	27.07	3450.0
2004-08-16 09:00:00	NVDA	Stock	0.0879	0.0888	0.086	0.0873	76766760.0
2004-08-16 10:00:00	NVDA	Stock	0.0872	0.0878	0.0861	0.0867	116488800.0
2004-08-16 11:00:00	NVDA	Stock	0.0867	0.0871	0.0862	0.087	72950520.0
2004-08-16 12:00:00	NVDA	Stock	0.087	0.0871	0.0863	0.0866	35650560.0
2004-08-16 13:00:00	NVDA	Stock	0.0866	0.0869	0.0862	0.0866	34260000.0
2004-08-16 14:00:00	NVDA	Stock	0.0866	0.0871	0.0865	0.087	60931800.0
2004-08-16 15:00:00	NVDA	Stock	0.0871	0.0873	0.0865	0.0867	93809040.0
2004-08-16 16:00:00	NVDA	Stock	0.0869	0.0885	0.0864	0.0867	5131440.0
2004-08-16 17:00:00	NVDA	Stock	0.0875	0.0875	0.0868	0.0868	676920.0
2004-08-16 09:00:00	AMZN	Stock	1.8065	1.8345	1.799	1.8265	14530420.0
2004-08-16 10:00:00	AMZN	Stock	1.825	1.871	1.821	1.858	28417280.0
2004-08-16 11:00:00	AMZN	Stock	1.858	1.884	1.856	1.876	19908640.0
2004-08-16 12:00:00	AMZN	Stock	1.876	1.9	1.8755	1.8925	18242560.0
2004-08-16 13:00:00	AMZN	Stock	1.8925	1.905	1.8885	1.9035	19656880.0
2004-08-16 14:00:00	AMZN	Stock	1.903	1.92	1.9	1.908	24242140.0
2004-08-16 15:00:00	AMZN	Stock	1.908	1.913	1.893	1.898	33210440.0
2004-08-16 16:00:00	AMZN	Stock	1.8985	1.8985	1.8825	1.8975	1878820.0
2004-08-16 17:00:00	AMZN	Stock	1.8975	1.9	1.895	1.9	182780.0
2004-08-16 18:00:00	AMZN	Stock	1.9	1.9	1.898	1.898	65000.0
2004-08-16 09:00:00	CL	Stock	25.93	26.05	25.795	26.045	206000.0
2004-08-16 10:00:00	CL	Stock	26.035	26.24	26.025	26.075	514800.0
2004-08-16 11:00:00	CL	Stock	26.075	26.12	26.015	26.015	339800.0
2004-08-16 12:00:00	CL	Stock	26.015	26.095	26.0	26.02	202200.0
2004-08-16 13:00:00	CL	Stock	26.025	26.05	25.95	25.975	297200.0
2004-08-16 14:00:00	CL	Stock	25.975	26.005	25.88	25.91	355000.0
2004-08-16 15:00:00	CL	Stock	25.905	26.02	25.9	26.0	577600.0
2004-08-16 16:00:00	CL	Stock	25.975	25.975	25.975	25.975	23000.0

> showing 49 of 23,479 rows — these rows as CSV

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