PREVIEW / stock_1hour / 2008-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-23.parquet
  size:    856 KB
  rows:    42,502
  symbols: 3,269

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
2008-01-23 04:00:00	AAPL	Stock	5.0121	5.0121	4.9964	4.9964	20216.0
2008-01-23 05:00:00	AAPL	Stock	5.0	5.0264	5.0	5.0143	101920.0
2008-01-23 06:00:00	AAPL	Stock	4.9929	4.9929	4.955	4.9818	504364.0
2008-01-23 07:00:00	AAPL	Stock	4.9818	5.0429	4.9643	4.9807	3855936.0
2008-01-23 08:00:00	AAPL	Stock	4.9889	4.9946	4.9107	4.9407	48430508.0
2008-01-23 09:00:00	AAPL	Stock	4.9411	5.0	4.8179	4.9146	474610164.0
2008-01-23 10:00:00	AAPL	Stock	4.9143	4.9464	4.8507	4.882	401336040.0
2008-01-23 11:00:00	AAPL	Stock	4.8818	4.8886	4.6125	4.6179	576594004.0
2008-01-23 12:00:00	AAPL	Stock	4.6171	4.6625	4.505	4.5254	424238416.0
2008-01-23 13:00:00	AAPL	Stock	4.5264	4.6775	4.5211	4.6754	357227220.0
2008-01-23 14:00:00	AAPL	Stock	4.6754	4.8171	4.6429	4.7511	452689440.0
2008-01-23 15:00:00	AAPL	Stock	4.7511	4.9775	4.7375	4.9639	598532928.0
2008-01-23 16:00:00	AAPL	Stock	4.9636	4.9704	4.6671	4.95	28360668.0
2008-01-23 17:00:00	AAPL	Stock	4.9464	4.975	4.7313	4.9739	5571188.0
2008-01-23 18:00:00	AAPL	Stock	4.975	4.9875	4.9643	4.9679	1371160.0
2008-01-23 19:00:00	AAPL	Stock	4.9664	4.9811	4.9661	4.9782	849912.0
2008-01-23 06:00:00	MSFT	Stock	31.48	31.48	31.48	31.48	180.0
2008-01-23 07:00:00	MSFT	Stock	31.56	31.6	31.35	31.6	15100.0
2008-01-23 08:00:00	MSFT	Stock	31.6	31.99	31.33	31.45	319698.0
2008-01-23 09:00:00	MSFT	Stock	31.49	31.6	31.3	31.519	12726359.0
2008-01-23 10:00:00	MSFT	Stock	31.51	31.95	31.45	31.81	20221688.0
2008-01-23 11:00:00	MSFT	Stock	31.81	31.87	31.3	31.357	15687472.0
2008-01-23 12:00:00	MSFT	Stock	31.36	31.55	31.04	31.292	13998240.0
2008-01-23 13:00:00	MSFT	Stock	31.3	31.46	31.14	31.36	16757638.0
2008-01-23 14:00:00	MSFT	Stock	31.36	31.49	31.1	31.22	18274255.0
2008-01-23 15:00:00	MSFT	Stock	31.22	32.05	31.18	32.0	34412037.0
2008-01-23 16:00:00	MSFT	Stock	32.0	32.17	31.38	32.13	4852445.0
2008-01-23 17:00:00	MSFT	Stock	32.13	32.3	31.475	32.24	651874.0
2008-01-23 18:00:00	MSFT	Stock	32.24	32.32	31.93	32.25	94795.0
2008-01-23 19:00:00	MSFT	Stock	32.25	32.3	32.21	32.25	22700.0
2008-01-23 08:00:00	NVDA	Stock	0.592	0.592	0.5625	0.5688	590920.0
2008-01-23 09:00:00	NVDA	Stock	0.5662	0.5985	0.5605	0.5928	79998400.0
2008-01-23 10:00:00	NVDA	Stock	0.5928	0.6185	0.5928	0.6115	106837920.0
2008-01-23 11:00:00	NVDA	Stock	0.612	0.6148	0.5715	0.5718	147997400.0
2008-01-23 12:00:00	NVDA	Stock	0.5718	0.59	0.5662	0.5752	103935600.0
2008-01-23 13:00:00	NVDA	Stock	0.5755	0.5863	0.573	0.582	82425840.0
2008-01-23 14:00:00	NVDA	Stock	0.582	0.5925	0.578	0.5871	101178640.0
2008-01-23 15:00:00	NVDA	Stock	0.5875	0.6063	0.587	0.6005	258334760.0
2008-01-23 16:00:00	NVDA	Stock	0.6005	0.6048	0.5886	0.6015	33474960.0
2008-01-23 17:00:00	NVDA	Stock	0.6048	0.6088	0.5886	0.6015	1727040.0
2008-01-23 18:00:00	NVDA	Stock	0.6008	0.6088	0.5903	0.6088	6975000.0
2008-01-23 19:00:00	NVDA	Stock	0.6085	0.6088	0.6085	0.6088	114000.0
2008-01-23 07:00:00	AMZN	Stock	3.85	3.86	3.8405	3.85	36000.0
2008-01-23 08:00:00	AMZN	Stock	3.8505	3.8505	3.785	3.8085	325640.0
2008-01-23 09:00:00	AMZN	Stock	3.8085	3.8085	3.64	3.7765	47868140.0
2008-01-23 10:00:00	AMZN	Stock	3.776	3.84	3.6505	3.652	49710100.0
2008-01-23 11:00:00	AMZN	Stock	3.6515	3.6775	3.5515	3.5763	61630040.0
2008-01-23 12:00:00	AMZN	Stock	3.575	3.587	3.4975	3.523	53874620.0
2008-01-23 13:00:00	AMZN	Stock	3.5234	3.648	3.5025	3.628	52367620.0
2008-01-23 14:00:00	AMZN	Stock	3.6285	3.7355	3.593	3.6775	59123360.0

> showing 50 of 42,502 rows — these rows as CSV

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