PREVIEW / stock_1hour / 2008-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-14.parquet
  size:    824 KB
  rows:    40,331
  symbols: 3,354

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-07-14 06:00:00	AAPL	Stock	6.225	6.225	6.2246	6.225	28000.0
2008-07-14 07:00:00	AAPL	Stock	6.2636	6.3014	6.2443	6.2718	785400.0
2008-07-14 08:00:00	AAPL	Stock	6.275	6.4414	6.25	6.4357	20582100.0
2008-07-14 09:00:00	AAPL	Stock	6.4286	6.4546	6.2896	6.3036	153903008.0
2008-07-14 10:00:00	AAPL	Stock	6.3036	6.3536	6.2554	6.3307	174685560.0
2008-07-14 11:00:00	AAPL	Stock	6.3314	6.3393	6.2029	6.2257	106061088.0
2008-07-14 12:00:00	AAPL	Stock	6.2257	6.265	6.2114	6.2482	94821384.0
2008-07-14 13:00:00	AAPL	Stock	6.2486	6.2814	6.2229	6.2575	80445400.0
2008-07-14 14:00:00	AAPL	Stock	6.2577	6.2943	6.2118	6.2261	85914892.0
2008-07-14 15:00:00	AAPL	Stock	6.2257	6.2775	6.1814	6.21	151822748.0
2008-07-14 16:00:00	AAPL	Stock	6.2164	6.2772	6.1839	6.1925	11163208.0
2008-07-14 17:00:00	AAPL	Stock	6.1929	6.1929	6.1786	6.1839	329756.0
2008-07-14 18:00:00	AAPL	Stock	6.1839	6.1929	6.1839	6.1893	299880.0
2008-07-14 19:00:00	AAPL	Stock	6.1893	6.1946	6.1886	6.1914	287364.0
2008-07-14 07:00:00	MSFT	Stock	25.6	25.79	25.55	25.79	3600.0
2008-07-14 08:00:00	MSFT	Stock	25.62	25.7	25.51	25.65	47195.0
2008-07-14 09:00:00	MSFT	Stock	25.6	25.78	25.42	25.74	7049708.0
2008-07-14 10:00:00	MSFT	Stock	25.75	25.81	25.47	25.66	8909444.0
2008-07-14 11:00:00	MSFT	Stock	25.66	25.69	25.24	25.35	4794384.0
2008-07-14 12:00:00	MSFT	Stock	25.35	25.37	25.2	25.27	3915215.0
2008-07-14 13:00:00	MSFT	Stock	25.27	25.29	25.07	25.27	6568905.0
2008-07-14 14:00:00	MSFT	Stock	25.26	25.45	25.18	25.22	6431342.0
2008-07-14 15:00:00	MSFT	Stock	25.21	25.375	25.07	25.11	10938638.0
2008-07-14 16:00:00	MSFT	Stock	25.14	25.398	25.07	25.1	1985203.0
2008-07-14 17:00:00	MSFT	Stock	25.1	25.21	25.08	25.1	8287.0
2008-07-14 18:00:00	MSFT	Stock	25.08	25.15	25.08	25.14	4064.0
2008-07-14 19:00:00	MSFT	Stock	25.12	25.15	25.12	25.15	561.0
2008-07-14 20:00:00	MSFT	Stock	25.15	25.15	25.15	25.15	3502.0
2008-07-14 08:00:00	NVDA	Stock	0.29	0.3	0.29	0.2958	223920.0
2008-07-14 09:00:00	NVDA	Stock	0.2958	0.2982	0.2838	0.2842	74165960.0
2008-07-14 10:00:00	NVDA	Stock	0.2841	0.286	0.278	0.2835	192716640.0
2008-07-14 11:00:00	NVDA	Stock	0.2835	0.2845	0.2768	0.279	111301360.0
2008-07-14 12:00:00	NVDA	Stock	0.279	0.2818	0.2765	0.2805	89333480.0
2008-07-14 13:00:00	NVDA	Stock	0.2808	0.284	0.2785	0.281	104344840.0
2008-07-14 14:00:00	NVDA	Stock	0.2812	0.2822	0.2795	0.2803	92953360.0
2008-07-14 15:00:00	NVDA	Stock	0.2803	0.283	0.278	0.2785	197705880.0
2008-07-14 16:00:00	NVDA	Stock	0.2805	0.2816	0.2778	0.2785	8598680.0
2008-07-14 17:00:00	NVDA	Stock	0.2785	0.2788	0.2772	0.2775	185760.0
2008-07-14 18:00:00	NVDA	Stock	0.277	0.278	0.277	0.278	85440.0
2008-07-14 20:00:00	NVDA	Stock	0.2785	0.2785	0.2785	0.2785	52000.0
2008-07-14 08:00:00	AMZN	Stock	3.475	3.5	3.475	3.4995	26000.0
2008-07-14 09:00:00	AMZN	Stock	3.5	3.5	3.326	3.326	22568760.0
2008-07-14 10:00:00	AMZN	Stock	3.326	3.3625	3.2795	3.348	35384480.0
2008-07-14 11:00:00	AMZN	Stock	3.348	3.3645	3.3125	3.3365	21308180.0
2008-07-14 12:00:00	AMZN	Stock	3.3355	3.3455	3.3095	3.32	20327460.0
2008-07-14 13:00:00	AMZN	Stock	3.32	3.352	3.2825	3.3375	17504280.0
2008-07-14 14:00:00	AMZN	Stock	3.3375	3.3475	3.3035	3.3075	15337400.0
2008-07-14 15:00:00	AMZN	Stock	3.3075	3.3545	3.288	3.3135	42087260.0
2008-07-14 16:00:00	AMZN	Stock	3.3135	3.3325	3.3115	3.33	3553580.0
2008-07-14 17:00:00	AMZN	Stock	3.32	3.32	3.32	3.32	2000.0

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

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