PREVIEW / stock_1hour / 2008-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-20.parquet
  size:    811 KB
  rows:    39,454
  symbols: 3,303

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-20 07:00:00	AAPL	Stock	6.2779	6.2779	6.2232	6.2507	79100.0
2008-08-20 08:00:00	AAPL	Stock	6.2507	6.2507	6.225	6.2282	1434104.0
2008-08-20 09:00:00	AAPL	Stock	6.2286	6.2693	6.2182	6.2629	79466268.0
2008-08-20 10:00:00	AAPL	Stock	6.2629	6.3193	6.2375	6.3111	107763040.0
2008-08-20 11:00:00	AAPL	Stock	6.3129	6.3161	6.2579	6.2693	50367408.0
2008-08-20 12:00:00	AAPL	Stock	6.2689	6.2807	6.2004	6.2482	66413200.0
2008-08-20 13:00:00	AAPL	Stock	6.2493	6.2825	6.2411	6.2514	47235608.0
2008-08-20 14:00:00	AAPL	Stock	6.2507	6.2696	6.2104	6.2668	54540668.0
2008-08-20 15:00:00	AAPL	Stock	6.2668	6.2846	6.2311	6.2818	82538316.0
2008-08-20 16:00:00	AAPL	Stock	6.2804	6.2829	6.1975	6.28	7171892.0
2008-08-20 17:00:00	AAPL	Stock	6.2789	6.2821	6.2789	6.2804	95312.0
2008-08-20 18:00:00	AAPL	Stock	6.2789	6.2829	6.2786	6.2829	60480.0
2008-08-20 19:00:00	AAPL	Stock	6.2829	6.2857	6.2796	6.2821	127400.0
2008-08-20 20:00:00	AAPL	Stock	6.2675	6.2675	6.2675	6.2675	2800.0
2008-08-20 07:00:00	MSFT	Stock	27.46	27.46	27.46	27.46	1610.0
2008-08-20 08:00:00	MSFT	Stock	27.46	27.53	27.46	27.53	9885.0
2008-08-20 09:00:00	MSFT	Stock	27.5	27.58	27.28	27.4	3834028.0
2008-08-20 10:00:00	MSFT	Stock	27.4	27.55	27.29	27.47	7613055.0
2008-08-20 11:00:00	MSFT	Stock	27.47	27.56	27.42	27.5	4907896.0
2008-08-20 12:00:00	MSFT	Stock	27.492	27.51	27.35	27.4	4159047.0
2008-08-20 13:00:00	MSFT	Stock	27.39	27.43	27.32	27.36	4188098.0
2008-08-20 14:00:00	MSFT	Stock	27.35	27.36	27.22	27.3	4819939.0
2008-08-20 15:00:00	MSFT	Stock	27.298	27.43	27.17	27.3	8072423.0
2008-08-20 16:00:00	MSFT	Stock	27.29	27.375	27.28	27.29	1769894.0
2008-08-20 17:00:00	MSFT	Stock	27.31	27.31	27.31	27.31	200.0
2008-08-20 19:00:00	MSFT	Stock	27.3	27.3	27.3	27.3	300.0
2008-08-20 20:00:00	MSFT	Stock	27.49	27.49	27.49	27.49	13400.0
2008-08-20 08:00:00	NVDA	Stock	0.3398	0.3405	0.339	0.34	723040.0
2008-08-20 09:00:00	NVDA	Stock	0.34	0.3438	0.338	0.342	102753280.0
2008-08-20 10:00:00	NVDA	Stock	0.342	0.3505	0.3398	0.3502	225225280.0
2008-08-20 11:00:00	NVDA	Stock	0.35	0.3505	0.3478	0.3497	189687480.0
2008-08-20 12:00:00	NVDA	Stock	0.3495	0.3502	0.3468	0.3488	154232760.0
2008-08-20 13:00:00	NVDA	Stock	0.3488	0.3525	0.3488	0.349	114395320.0
2008-08-20 14:00:00	NVDA	Stock	0.349	0.3508	0.3462	0.3502	169620520.0
2008-08-20 15:00:00	NVDA	Stock	0.3501	0.353	0.3488	0.3525	159911080.0
2008-08-20 16:00:00	NVDA	Stock	0.352	0.3522	0.3355	0.3513	14417880.0
2008-08-20 17:00:00	NVDA	Stock	0.3522	0.3525	0.3515	0.3522	80000.0
2008-08-20 18:00:00	NVDA	Stock	0.3522	0.3538	0.3522	0.353	176960.0
2008-08-20 19:00:00	NVDA	Stock	0.353	0.3548	0.353	0.353	181000.0
2008-08-20 20:00:00	NVDA	Stock	0.349	0.349	0.349	0.349	1264000.0
2008-08-20 07:00:00	AMZN	Stock	4.085	4.085	4.085	4.085	2000.0
2008-08-20 08:00:00	AMZN	Stock	4.1015	4.1015	4.0875	4.09	88240.0
2008-08-20 09:00:00	AMZN	Stock	4.092	4.1625	4.07	4.09	18643480.0
2008-08-20 10:00:00	AMZN	Stock	4.0875	4.13	4.0715	4.1145	28203580.0
2008-08-20 11:00:00	AMZN	Stock	4.1155	4.1436	4.0695	4.0955	19433480.0
2008-08-20 12:00:00	AMZN	Stock	4.097	4.1085	4.06	4.0925	8120160.0
2008-08-20 13:00:00	AMZN	Stock	4.093	4.1165	4.0915	4.1155	10184360.0
2008-08-20 14:00:00	AMZN	Stock	4.1155	4.1156	4.0745	4.1076	10663300.0
2008-08-20 15:00:00	AMZN	Stock	4.1055	4.109	4.0695	4.1085	17373540.0
2008-08-20 16:00:00	AMZN	Stock	4.1065	4.1085	4.0645	4.1065	3808820.0

> showing 50 of 39,454 rows — these rows as CSV

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