PREVIEW / stock_1hour / 2008-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-12.parquet
  size:    829 KB
  rows:    40,298
  symbols: 3,322

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-08-12 06:00:00	AAPL	Stock	6.18	6.1854	6.18	6.1854	11200.0
2008-08-12 07:00:00	AAPL	Stock	6.2043	6.2546	6.1789	6.2339	850668.0
2008-08-12 08:00:00	AAPL	Stock	6.2443	6.2443	6.1768	6.1875	2653476.0
2008-08-12 09:00:00	AAPL	Stock	6.1825	6.3214	6.1746	6.3125	134101044.0
2008-08-12 10:00:00	AAPL	Stock	6.3132	6.4032	6.3071	6.3732	210907172.0
2008-08-12 11:00:00	AAPL	Stock	6.3736	6.3893	6.3396	6.3532	105697368.0
2008-08-12 12:00:00	AAPL	Stock	6.3521	6.3732	6.3346	6.3721	58234204.0
2008-08-12 13:00:00	AAPL	Stock	6.3718	6.3746	6.3214	6.3457	73665396.0
2008-08-12 14:00:00	AAPL	Stock	6.3439	6.375	6.3318	6.3386	74022452.0
2008-08-12 15:00:00	AAPL	Stock	6.3382	6.3471	6.2143	6.3171	154662732.0
2008-08-12 16:00:00	AAPL	Stock	6.3171	6.3429	6.3071	6.3143	11776184.0
2008-08-12 17:00:00	AAPL	Stock	6.3143	6.3261	6.3143	6.3211	311304.0
2008-08-12 18:00:00	AAPL	Stock	6.3275	6.3275	6.3168	6.3254	308672.0
2008-08-12 19:00:00	AAPL	Stock	6.3214	6.3246	6.3196	6.3214	92820.0
2008-08-12 07:00:00	MSFT	Stock	28.0	28.0	28.0	28.0	200.0
2008-08-12 08:00:00	MSFT	Stock	27.77	27.95	27.77	27.82	9300.0
2008-08-12 09:00:00	MSFT	Stock	27.82	27.89	27.68	27.73	7414338.0
2008-08-12 10:00:00	MSFT	Stock	27.73	27.86	27.58	27.69	10474211.0
2008-08-12 11:00:00	MSFT	Stock	27.69	28.36	27.67	28.23	11766696.0
2008-08-12 12:00:00	MSFT	Stock	28.23	28.23	28.06	28.14	4584830.0
2008-08-12 13:00:00	MSFT	Stock	28.14	28.24	28.07	28.14	4984950.0
2008-08-12 14:00:00	MSFT	Stock	28.14	28.35	28.13	28.17	6247737.0
2008-08-12 15:00:00	MSFT	Stock	28.18	28.2	28.02	28.14	12720709.0
2008-08-12 16:00:00	MSFT	Stock	28.16	28.2	28.002	28.1	2201694.0
2008-08-12 17:00:00	MSFT	Stock	28.14	28.15	28.14	28.15	225.0
2008-08-12 18:00:00	MSFT	Stock	28.15	28.15	28.12	28.12	16586.0
2008-08-12 20:00:00	MSFT	Stock	28.29	28.29	28.29	28.29	561.0
2008-08-12 08:00:00	NVDA	Stock	0.2862	0.2862	0.28	0.2812	315800.0
2008-08-12 09:00:00	NVDA	Stock	0.2812	0.2838	0.278	0.278	135662720.0
2008-08-12 10:00:00	NVDA	Stock	0.278	0.2808	0.2765	0.28	199231280.0
2008-08-12 11:00:00	NVDA	Stock	0.2798	0.2808	0.2769	0.2785	232191400.0
2008-08-12 12:00:00	NVDA	Stock	0.2783	0.2788	0.275	0.2763	139305320.0
2008-08-12 13:00:00	NVDA	Stock	0.276	0.2785	0.274	0.2765	168112920.0
2008-08-12 14:00:00	NVDA	Stock	0.2764	0.2792	0.2755	0.276	147571720.0
2008-08-12 15:00:00	NVDA	Stock	0.276	0.2772	0.2728	0.2763	260073080.0
2008-08-12 16:00:00	NVDA	Stock	0.2765	0.2938	0.2668	0.281	50601160.0
2008-08-12 17:00:00	NVDA	Stock	0.2825	0.3115	0.2703	0.3073	70433400.0
2008-08-12 18:00:00	NVDA	Stock	0.3068	0.3068	0.3038	0.3055	8818360.0
2008-08-12 19:00:00	NVDA	Stock	0.3055	0.306	0.302	0.3028	1759800.0
2008-08-12 08:00:00	AMZN	Stock	4.4315	4.44	4.345	4.3525	411900.0
2008-08-12 09:00:00	AMZN	Stock	4.353	4.424	4.33	4.3705	29776660.0
2008-08-12 10:00:00	AMZN	Stock	4.371	4.4	4.35	4.377	29340680.0
2008-08-12 11:00:00	AMZN	Stock	4.3785	4.407	4.3555	4.3685	20720820.0
2008-08-12 12:00:00	AMZN	Stock	4.3665	4.3725	4.34	4.365	12358160.0
2008-08-12 13:00:00	AMZN	Stock	4.364	4.372	4.351	4.3595	10826180.0
2008-08-12 14:00:00	AMZN	Stock	4.36	4.371	4.336	4.3415	16438320.0
2008-08-12 15:00:00	AMZN	Stock	4.3415	4.3625	4.305	4.3625	35954720.0
2008-08-12 16:00:00	AMZN	Stock	4.3625	4.4045	4.348	4.3625	4042380.0
2008-08-12 17:00:00	AMZN	Stock	4.3525	4.3525	4.35	4.35	20000.0
2008-08-12 18:00:00	AMZN	Stock	4.35	4.35	4.3495	4.3495	6000.0

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

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