PREVIEW / stock_1hour / 2010-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-10.parquet
  size:    906 KB
  rows:    43,427
  symbols: 3,483

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-08-10 06:00:00	AAPL	Stock	9.3161	9.3161	9.3161	9.3161	5320.0
2010-08-10 07:00:00	AAPL	Stock	9.3107	9.3107	9.2821	9.2821	178444.0
2010-08-10 08:00:00	AAPL	Stock	9.2857	9.3036	9.2707	9.285	2159444.0
2010-08-10 09:00:00	AAPL	Stock	9.2832	9.2996	9.2361	9.2504	68437992.0
2010-08-10 10:00:00	AAPL	Stock	9.2479	9.2568	9.2079	9.2143	86517452.0
2010-08-10 11:00:00	AAPL	Stock	9.215	9.2554	9.2107	9.2457	37640876.0
2010-08-10 12:00:00	AAPL	Stock	9.2457	9.2493	9.2218	9.2275	26345592.0
2010-08-10 13:00:00	AAPL	Stock	9.2275	9.2321	9.1982	9.2174	34900096.0
2010-08-10 14:00:00	AAPL	Stock	9.2179	9.3018	9.2143	9.2846	111303500.0
2010-08-10 15:00:00	AAPL	Stock	9.2839	9.2982	9.2525	9.2643	73259312.0
2010-08-10 16:00:00	AAPL	Stock	9.2643	9.2744	9.2157	9.2554	7351400.0
2010-08-10 17:00:00	AAPL	Stock	9.2561	9.2596	9.2518	9.2521	136724.0
2010-08-10 18:00:00	AAPL	Stock	9.2525	9.2646	9.2521	9.2589	206920.0
2010-08-10 19:00:00	AAPL	Stock	9.2589	9.2621	9.2564	9.2589	149408.0
2010-08-10 07:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	200.0
2010-08-10 08:00:00	MSFT	Stock	25.4	25.46	25.37	25.38	12300.0
2010-08-10 09:00:00	MSFT	Stock	25.38	25.38	25.0	25.11	9251445.0
2010-08-10 10:00:00	MSFT	Stock	25.105	25.2	25.04	25.05	11264478.0
2010-08-10 11:00:00	MSFT	Stock	25.05	25.11	24.99	25.0	12321560.0
2010-08-10 12:00:00	MSFT	Stock	25.0	25.07	24.92	25.0	9080221.0
2010-08-10 13:00:00	MSFT	Stock	25.009	25.03	24.88	24.955	7646049.0
2010-08-10 14:00:00	MSFT	Stock	24.955	25.2	24.94	25.095	16560676.0
2010-08-10 15:00:00	MSFT	Stock	25.09	25.14	24.97	25.03	17136123.0
2010-08-10 16:00:00	MSFT	Stock	25.02	25.08	24.945	25.05	2857681.0
2010-08-10 17:00:00	MSFT	Stock	25.05	25.08	25.05	25.07	1557.0
2010-08-10 18:00:00	MSFT	Stock	25.07	25.07	25.06	25.07	22192.0
2010-08-10 19:00:00	MSFT	Stock	25.06	25.07	25.06	25.07	2592.0
2010-08-10 06:00:00	NVDA	Stock	0.24	0.24	0.24	0.24	236560.0
2010-08-10 07:00:00	NVDA	Stock	0.2375	0.2375	0.2375	0.2375	20000.0
2010-08-10 08:00:00	NVDA	Stock	0.24	0.241	0.2375	0.238	493440.0
2010-08-10 09:00:00	NVDA	Stock	0.238	0.238	0.2318	0.2348	118783000.0
2010-08-10 10:00:00	NVDA	Stock	0.2348	0.2362	0.233	0.2334	127547600.0
2010-08-10 11:00:00	NVDA	Stock	0.2332	0.2338	0.2318	0.233	51915880.0
2010-08-10 12:00:00	NVDA	Stock	0.2332	0.2332	0.2322	0.2325	27440760.0
2010-08-10 13:00:00	NVDA	Stock	0.2325	0.2328	0.23	0.2304	72288040.0
2010-08-10 14:00:00	NVDA	Stock	0.2305	0.234	0.23	0.2318	142968600.0
2010-08-10 15:00:00	NVDA	Stock	0.2319	0.232	0.23	0.2312	214338640.0
2010-08-10 16:00:00	NVDA	Stock	0.2312	0.2326	0.2303	0.2305	3628400.0
2010-08-10 17:00:00	NVDA	Stock	0.2312	0.2312	0.2308	0.2308	931760.0
2010-08-10 18:00:00	NVDA	Stock	0.231	0.2315	0.2308	0.231	443400.0
2010-08-10 19:00:00	NVDA	Stock	0.2312	0.2312	0.2305	0.2312	164000.0
2010-08-10 07:00:00	AMZN	Stock	6.405	6.405	6.405	6.405	5580.0
2010-08-10 08:00:00	AMZN	Stock	6.4	6.419	6.3755	6.4125	523500.0
2010-08-10 09:00:00	AMZN	Stock	6.416	6.4255	6.369	6.3955	11467920.0
2010-08-10 10:00:00	AMZN	Stock	6.394	6.435	6.3785	6.396	11803400.0
2010-08-10 11:00:00	AMZN	Stock	6.397	6.47	6.3955	6.456	11481480.0
2010-08-10 12:00:00	AMZN	Stock	6.4565	6.4635	6.4405	6.4558	7230860.0
2010-08-10 13:00:00	AMZN	Stock	6.4558	6.4585	6.415	6.427	8843800.0
2010-08-10 14:00:00	AMZN	Stock	6.427	6.4965	6.4155	6.4837	24172100.0
2010-08-10 15:00:00	AMZN	Stock	6.4835	6.5	6.4815	6.5	34336360.0

> showing 50 of 43,427 rows — these rows as CSV

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