PREVIEW / stock_1hour / 2008-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-15.parquet
  size:    797 KB
  rows:    40,780
  symbols: 3,337

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-12-15 04:00:00	AAPL	Stock	3.5096	3.5096	3.45	3.45	42000.0
2008-12-15 06:00:00	AAPL	Stock	3.4325	3.4325	3.4311	3.4311	5600.0
2008-12-15 07:00:00	AAPL	Stock	3.4075	3.4311	3.3679	3.4243	1173144.0
2008-12-15 08:00:00	AAPL	Stock	3.4275	3.455	3.4143	3.4429	4154472.0
2008-12-15 09:00:00	AAPL	Stock	3.4414	3.4496	3.3796	3.3807	125744556.0
2008-12-15 10:00:00	AAPL	Stock	3.3804	3.3821	3.3268	3.3409	148816920.0
2008-12-15 11:00:00	AAPL	Stock	3.34	3.3839	3.3346	3.3693	111079416.0
2008-12-15 12:00:00	AAPL	Stock	3.3682	3.3782	3.3332	3.3518	84271236.0
2008-12-15 13:00:00	AAPL	Stock	3.3518	3.3518	3.3214	3.34	94853108.0
2008-12-15 14:00:00	AAPL	Stock	3.3396	3.3621	3.3364	3.3414	90625528.0
2008-12-15 15:00:00	AAPL	Stock	3.3407	3.3864	3.325	3.3839	206904208.0
2008-12-15 16:00:00	AAPL	Stock	3.3857	3.3929	3.3464	3.3879	21291536.0
2008-12-15 17:00:00	AAPL	Stock	3.3893	3.3911	3.3485	3.3857	244832.0
2008-12-15 18:00:00	AAPL	Stock	3.3857	3.3868	3.3821	3.3821	1409632.0
2008-12-15 19:00:00	AAPL	Stock	3.3832	3.3871	3.3821	3.3821	224364.0
2008-12-15 05:00:00	MSFT	Stock	19.59	19.59	19.59	19.59	200.0
2008-12-15 06:00:00	MSFT	Stock	19.6	19.6	19.6	19.6	900.0
2008-12-15 07:00:00	MSFT	Stock	19.58	19.58	19.5	19.5	1100.0
2008-12-15 08:00:00	MSFT	Stock	19.5	19.5	19.36	19.4	11704.0
2008-12-15 09:00:00	MSFT	Stock	19.43	19.49	19.01	19.052	5030782.0
2008-12-15 10:00:00	MSFT	Stock	19.05	19.18	18.91	18.952	8114980.0
2008-12-15 11:00:00	MSFT	Stock	18.95	19.09	18.92	18.952	7468185.0
2008-12-15 12:00:00	MSFT	Stock	18.952	19.08	18.925	18.95	4492490.0
2008-12-15 13:00:00	MSFT	Stock	18.94	19.05	18.9	19.02	4967361.0
2008-12-15 14:00:00	MSFT	Stock	19.013	19.14	18.97	18.99	6402826.0
2008-12-15 15:00:00	MSFT	Stock	18.99	19.3	18.89	19.04	16688553.0
2008-12-15 16:00:00	MSFT	Stock	19.04	19.417	18.982	19.07	6009320.0
2008-12-15 17:00:00	MSFT	Stock	19.1	19.12	19.014	19.1	2800.0
2008-12-15 18:00:00	MSFT	Stock	19.04	19.12	19.04	19.12	18840.0
2008-12-15 19:00:00	MSFT	Stock	19.12	19.13	19.09	19.09	9900.0
2008-12-15 08:00:00	NVDA	Stock	0.214	0.2178	0.214	0.2178	45200.0
2008-12-15 09:00:00	NVDA	Stock	0.215	0.2175	0.2085	0.2102	68604080.0
2008-12-15 10:00:00	NVDA	Stock	0.2102	0.2112	0.2013	0.2043	119532080.0
2008-12-15 11:00:00	NVDA	Stock	0.2045	0.2112	0.2035	0.21	71938200.0
2008-12-15 12:00:00	NVDA	Stock	0.21	0.2108	0.2065	0.2068	35886560.0
2008-12-15 13:00:00	NVDA	Stock	0.207	0.209	0.2055	0.207	31427600.0
2008-12-15 14:00:00	NVDA	Stock	0.2072	0.2095	0.207	0.207	35466040.0
2008-12-15 15:00:00	NVDA	Stock	0.2072	0.2108	0.204	0.2082	99628520.0
2008-12-15 16:00:00	NVDA	Stock	0.209	0.2118	0.2075	0.208	1403000.0
2008-12-15 17:00:00	NVDA	Stock	0.209	0.209	0.209	0.209	40000.0
2008-12-15 19:00:00	NVDA	Stock	0.209	0.209	0.2065	0.2065	176000.0
2008-12-15 08:00:00	AMZN	Stock	2.57	2.57	2.55	2.55	10000.0
2008-12-15 09:00:00	AMZN	Stock	2.55	2.55	2.4425	2.4655	33154440.0
2008-12-15 10:00:00	AMZN	Stock	2.4655	2.501	2.4335	2.441	26986080.0
2008-12-15 11:00:00	AMZN	Stock	2.441	2.451	2.429	2.4435	16439920.0
2008-12-15 12:00:00	AMZN	Stock	2.443	2.4525	2.431	2.4355	10434680.0
2008-12-15 13:00:00	AMZN	Stock	2.435	2.4585	2.4175	2.4475	11510380.0
2008-12-15 14:00:00	AMZN	Stock	2.4475	2.4625	2.426	2.4275	11158120.0
2008-12-15 15:00:00	AMZN	Stock	2.4265	2.477	2.4074	2.442	29991880.0
2008-12-15 16:00:00	AMZN	Stock	2.447	2.4991	2.4445	2.471	1562840.0

> showing 50 of 40,780 rows — these rows as CSV

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