PREVIEW / stock_1hour / 2009-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-28.parquet
  size:    807 KB
  rows:    40,182
  symbols: 3,305

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
2009-01-28 04:00:00	AAPL	Stock	3.2661	3.2661	3.2661	3.2661	56000.0
2009-01-28 06:00:00	AAPL	Stock	3.2768	3.2954	3.2768	3.2954	137200.0
2009-01-28 07:00:00	AAPL	Stock	3.2857	3.3125	3.2821	3.3121	442876.0
2009-01-28 08:00:00	AAPL	Stock	3.3039	3.3189	3.2857	3.3064	2790872.0
2009-01-28 09:00:00	AAPL	Stock	3.3057	3.3104	3.2679	3.275	75304936.0
2009-01-28 10:00:00	AAPL	Stock	3.275	3.3089	3.2679	3.3079	113427328.0
2009-01-28 11:00:00	AAPL	Stock	3.3089	3.3396	3.2893	3.3389	122772020.0
2009-01-28 12:00:00	AAPL	Stock	3.3389	3.3679	3.335	3.3395	105868476.0
2009-01-28 13:00:00	AAPL	Stock	3.3393	3.3839	3.3371	3.3664	96308520.0
2009-01-28 14:00:00	AAPL	Stock	3.3664	3.3929	3.3625	3.3907	130860492.0
2009-01-28 15:00:00	AAPL	Stock	3.3907	3.3925	3.3411	3.3687	155026816.0
2009-01-28 16:00:00	AAPL	Stock	3.3654	3.3695	3.3399	3.3579	28313320.0
2009-01-28 17:00:00	AAPL	Stock	3.3582	3.3636	3.3571	3.3589	152544.0
2009-01-28 18:00:00	AAPL	Stock	3.3579	3.3671	3.2851	3.3568	17329984.0
2009-01-28 19:00:00	AAPL	Stock	3.3554	3.3621	3.3482	3.3482	80248.0
2009-01-28 07:00:00	MSFT	Stock	17.82	17.92	17.82	17.92	2607.0
2009-01-28 08:00:00	MSFT	Stock	17.92	18.08	17.91	18.02	74088.0
2009-01-28 09:00:00	MSFT	Stock	18.02	18.08	17.67	17.83	8727156.0
2009-01-28 10:00:00	MSFT	Stock	17.82	18.08	17.79	18.0	9146706.0
2009-01-28 11:00:00	MSFT	Stock	18.0	18.15	17.99	18.068	7979851.0
2009-01-28 12:00:00	MSFT	Stock	18.07	18.12	17.96	17.97	4177324.0
2009-01-28 13:00:00	MSFT	Stock	17.98	18.15	17.94	18.13	5337936.0
2009-01-28 14:00:00	MSFT	Stock	18.125	18.31	18.09	18.24	9289827.0
2009-01-28 15:00:00	MSFT	Stock	18.24	18.29	17.82	18.06	14353570.0
2009-01-28 16:00:00	MSFT	Stock	18.08	18.08	17.856	17.95	3169220.0
2009-01-28 17:00:00	MSFT	Stock	17.95	17.96	17.95	17.96	2620.0
2009-01-28 18:00:00	MSFT	Stock	17.97	18.04	17.96	17.98	550552.0
2009-01-28 19:00:00	MSFT	Stock	17.96	18.0	17.96	18.0	6982.0
2009-01-28 08:00:00	NVDA	Stock	0.2125	0.222	0.2125	0.22	572200.0
2009-01-28 09:00:00	NVDA	Stock	0.222	0.2228	0.2125	0.2128	129976000.0
2009-01-28 10:00:00	NVDA	Stock	0.2128	0.2187	0.2115	0.217	128207480.0
2009-01-28 11:00:00	NVDA	Stock	0.217	0.2198	0.217	0.2175	62488440.0
2009-01-28 12:00:00	NVDA	Stock	0.2175	0.2183	0.217	0.2178	17190680.0
2009-01-28 13:00:00	NVDA	Stock	0.2178	0.2215	0.2178	0.2212	57503880.0
2009-01-28 14:00:00	NVDA	Stock	0.221	0.2228	0.2185	0.2225	108936400.0
2009-01-28 15:00:00	NVDA	Stock	0.2225	0.2232	0.2165	0.2198	200162920.0
2009-01-28 16:00:00	NVDA	Stock	0.2195	0.2232	0.2184	0.2198	11117760.0
2009-01-28 17:00:00	NVDA	Stock	0.2158	0.2198	0.2158	0.2198	48920.0
2009-01-28 18:00:00	NVDA	Stock	0.2158	0.2158	0.2158	0.2158	20000.0
2009-01-28 19:00:00	NVDA	Stock	0.2158	0.2158	0.2158	0.2158	20000.0
2009-01-28 07:00:00	AMZN	Stock	2.55	2.55	2.55	2.55	3060.0
2009-01-28 08:00:00	AMZN	Stock	2.4755	2.505	2.4755	2.4975	214340.0
2009-01-28 09:00:00	AMZN	Stock	2.496	2.4985	2.4485	2.4805	19481700.0
2009-01-28 10:00:00	AMZN	Stock	2.479	2.5415	2.4765	2.5125	30082520.0
2009-01-28 11:00:00	AMZN	Stock	2.5125	2.557	2.505	2.5365	18149100.0
2009-01-28 12:00:00	AMZN	Stock	2.536	2.5455	2.513	2.5175	15033820.0
2009-01-28 13:00:00	AMZN	Stock	2.518	2.5445	2.514	2.528	12086940.0
2009-01-28 14:00:00	AMZN	Stock	2.528	2.5745	2.527	2.5575	20111400.0
2009-01-28 15:00:00	AMZN	Stock	2.5575	2.5645	2.506	2.5145	38439240.0
2009-01-28 16:00:00	AMZN	Stock	2.516	2.5294	2.5	2.504	3659100.0

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

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