PREVIEW / stock_1hour / 2010-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-04.parquet
  size:    939 KB
  rows:    44,443
  symbols: 3,488

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
2010-05-04 04:00:00	AAPL	Stock	9.5018	9.5018	9.4911	9.4911	19600.0
2010-05-04 05:00:00	AAPL	Stock	9.4771	9.4793	9.4643	9.4643	33600.0
2010-05-04 06:00:00	AAPL	Stock	9.4679	9.4768	9.4539	9.4539	67200.0
2010-05-04 07:00:00	AAPL	Stock	9.4643	9.4732	9.4068	9.4114	486108.0
2010-05-04 08:00:00	AAPL	Stock	9.4139	9.425	9.3839	9.4143	3435376.0
2010-05-04 09:00:00	AAPL	Stock	9.4168	9.4168	9.2954	9.3264	90889064.0
2010-05-04 10:00:00	AAPL	Stock	9.3293	9.3332	9.1793	9.225	170241792.0
2010-05-04 11:00:00	AAPL	Stock	9.2247	9.2675	9.1696	9.2657	84309456.0
2010-05-04 12:00:00	AAPL	Stock	9.2654	9.2675	9.1857	9.2321	96538848.0
2010-05-04 13:00:00	AAPL	Stock	9.2304	9.2821	9.2244	9.2643	64515472.0
2010-05-04 14:00:00	AAPL	Stock	9.2657	9.2664	9.1914	9.2143	60104604.0
2010-05-04 15:00:00	AAPL	Stock	9.2123	9.25	9.1736	9.2379	129450272.0
2010-05-04 16:00:00	AAPL	Stock	9.2296	9.5125	9.2108	9.2379	13460468.0
2010-05-04 17:00:00	AAPL	Stock	9.2396	9.2439	9.2189	9.2214	592872.0
2010-05-04 18:00:00	AAPL	Stock	9.2207	9.2243	9.2143	9.2143	218792.0
2010-05-04 19:00:00	AAPL	Stock	9.2175	9.22	9.2071	9.2171	688576.0
2010-05-04 04:00:00	MSFT	Stock	30.72	30.72	30.72	30.72	200.0
2010-05-04 05:00:00	MSFT	Stock	30.68	30.68	30.68	30.68	100.0
2010-05-04 07:00:00	MSFT	Stock	30.7	30.7	30.62	30.7	2800.0
2010-05-04 08:00:00	MSFT	Stock	30.74	30.74	30.68	30.68	19606.0
2010-05-04 09:00:00	MSFT	Stock	30.65	30.69	30.2	30.41	6880216.0
2010-05-04 10:00:00	MSFT	Stock	30.42	30.45	30.1	30.12	14357155.0
2010-05-04 11:00:00	MSFT	Stock	30.11	30.15	29.76	29.945	14175705.0
2010-05-04 12:00:00	MSFT	Stock	29.946	29.95	29.75	29.908	9461937.0
2010-05-04 13:00:00	MSFT	Stock	29.91	30.12	29.875	30.095	6888489.0
2010-05-04 14:00:00	MSFT	Stock	30.093	30.14	29.935	29.97	7729759.0
2010-05-04 15:00:00	MSFT	Stock	29.965	30.15	29.93	30.11	16962409.0
2010-05-04 16:00:00	MSFT	Stock	30.11	30.86	29.97	29.97	4195956.0
2010-05-04 17:00:00	MSFT	Stock	30.0	30.08	29.95	30.08	9300.0
2010-05-04 18:00:00	MSFT	Stock	30.0	30.13	29.93	29.94	19070.0
2010-05-04 19:00:00	MSFT	Stock	30.01	30.02	29.94	29.96	13450.0
2010-05-04 06:00:00	NVDA	Stock	0.3885	0.3885	0.3885	0.3885	8960.0
2010-05-04 07:00:00	NVDA	Stock	0.3885	0.3885	0.3885	0.3885	15600.0
2010-05-04 08:00:00	NVDA	Stock	0.387	0.387	0.38	0.3825	464120.0
2010-05-04 09:00:00	NVDA	Stock	0.3813	0.3833	0.3708	0.372	143683080.0
2010-05-04 10:00:00	NVDA	Stock	0.3723	0.3758	0.3685	0.3688	222731560.0
2010-05-04 11:00:00	NVDA	Stock	0.3688	0.3692	0.366	0.367	166286720.0
2010-05-04 12:00:00	NVDA	Stock	0.367	0.3678	0.3632	0.366	168629280.0
2010-05-04 13:00:00	NVDA	Stock	0.3662	0.3695	0.3648	0.3692	153181840.0
2010-05-04 14:00:00	NVDA	Stock	0.3695	0.3703	0.3662	0.37	131536680.0
2010-05-04 15:00:00	NVDA	Stock	0.3699	0.3733	0.3672	0.3688	298256320.0
2010-05-04 16:00:00	NVDA	Stock	0.3685	0.375	0.3685	0.3686	25967080.0
2010-05-04 17:00:00	NVDA	Stock	0.3735	0.3735	0.3695	0.3695	184360.0
2010-05-04 19:00:00	NVDA	Stock	0.3713	0.3713	0.3713	0.3713	27960.0
2010-05-04 05:00:00	AMZN	Stock	6.8815	6.8915	6.8815	6.8915	6000.0
2010-05-04 08:00:00	AMZN	Stock	6.82	6.85	6.8	6.8125	108020.0
2010-05-04 09:00:00	AMZN	Stock	6.8	6.8015	6.636	6.7	29030700.0
2010-05-04 10:00:00	AMZN	Stock	6.7	6.701	6.58	6.5975	38366880.0
2010-05-04 11:00:00	AMZN	Stock	6.598	6.64	6.581	6.631	25608100.0
2010-05-04 12:00:00	AMZN	Stock	6.6295	6.641	6.5025	6.516	39759900.0

> showing 50 of 44,443 rows — these rows as CSV

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