PREVIEW / stock_1hour / 2010-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-21.parquet
  size:    884 KB
  rows:    42,815
  symbols: 3,459

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-07-21 04:00:00	AAPL	Stock	9.25	9.2679	9.25	9.2636	75488.0
2010-07-21 05:00:00	AAPL	Stock	9.2914	9.3211	9.2914	9.3029	37800.0
2010-07-21 06:00:00	AAPL	Stock	9.3029	9.3029	9.2739	9.2857	65212.0
2010-07-21 07:00:00	AAPL	Stock	9.2907	9.3714	9.2907	9.3482	4674908.0
2010-07-21 08:00:00	AAPL	Stock	9.3482	9.4143	9.2857	9.4086	21352772.0
2010-07-21 09:00:00	AAPL	Stock	9.4093	9.5168	9.195	9.2682	383519780.0
2010-07-21 10:00:00	AAPL	Stock	9.2682	9.2879	9.1611	9.1707	211738240.0
2010-07-21 11:00:00	AAPL	Stock	9.1682	9.23	9.1479	9.23	104488300.0
2010-07-21 12:00:00	AAPL	Stock	9.2293	9.2657	9.2261	9.2325	73730692.0
2010-07-21 13:00:00	AAPL	Stock	9.2329	9.2579	9.2086	9.2107	54701752.0
2010-07-21 14:00:00	AAPL	Stock	9.2106	9.2164	9.1107	9.1193	162565312.0
2010-07-21 15:00:00	AAPL	Stock	9.1186	9.1604	9.0714	9.0804	150842916.0
2010-07-21 16:00:00	AAPL	Stock	9.0804	9.2634	9.0732	9.0771	13037136.0
2010-07-21 17:00:00	AAPL	Stock	9.0768	9.0804	9.0643	9.0661	381640.0
2010-07-21 18:00:00	AAPL	Stock	9.065	9.0911	9.0636	9.0829	604464.0
2010-07-21 19:00:00	AAPL	Stock	9.0821	9.0907	9.0786	9.0875	354760.0
2010-07-21 06:00:00	MSFT	Stock	25.42	25.42	25.42	25.42	300.0
2010-07-21 07:00:00	MSFT	Stock	25.7	25.7	25.69	25.69	600.0
2010-07-21 08:00:00	MSFT	Stock	25.58	25.87	25.58	25.79	91937.0
2010-07-21 09:00:00	MSFT	Stock	25.79	25.81	25.12	25.21	8003487.0
2010-07-21 10:00:00	MSFT	Stock	25.21	25.51	25.13	25.46	9901047.0
2010-07-21 11:00:00	MSFT	Stock	25.47	25.5	25.35	25.45	8789448.0
2010-07-21 12:00:00	MSFT	Stock	25.44	25.58	25.4	25.48	7215760.0
2010-07-21 13:00:00	MSFT	Stock	25.484	25.58	25.46	25.54	5179342.0
2010-07-21 14:00:00	MSFT	Stock	25.54	25.57	25.0	25.03	11980256.0
2010-07-21 15:00:00	MSFT	Stock	25.03	25.125	24.975	25.11	15274983.0
2010-07-21 16:00:00	MSFT	Stock	25.11	25.292	25.018	25.14	5162926.0
2010-07-21 17:00:00	MSFT	Stock	25.47	25.47	25.12	25.31	138959.0
2010-07-21 18:00:00	MSFT	Stock	25.32	25.41	25.12	25.31	96634.0
2010-07-21 19:00:00	MSFT	Stock	25.3	25.34	25.28	25.3	23357.0
2010-07-21 08:00:00	NVDA	Stock	0.2695	0.2712	0.2695	0.2705	698080.0
2010-07-21 09:00:00	NVDA	Stock	0.271	0.275	0.2615	0.2623	78099000.0
2010-07-21 10:00:00	NVDA	Stock	0.2623	0.263	0.26	0.261	136834920.0
2010-07-21 11:00:00	NVDA	Stock	0.261	0.2623	0.2598	0.2623	55193480.0
2010-07-21 12:00:00	NVDA	Stock	0.262	0.2638	0.2618	0.2623	66812200.0
2010-07-21 13:00:00	NVDA	Stock	0.262	0.2643	0.2618	0.2632	34709120.0
2010-07-21 14:00:00	NVDA	Stock	0.2635	0.2635	0.2575	0.258	105514280.0
2010-07-21 15:00:00	NVDA	Stock	0.258	0.2603	0.2568	0.259	126477880.0
2010-07-21 16:00:00	NVDA	Stock	0.259	0.2613	0.257	0.26	14468480.0
2010-07-21 17:00:00	NVDA	Stock	0.2598	0.2603	0.2588	0.2588	257520.0
2010-07-21 18:00:00	NVDA	Stock	0.2588	0.2603	0.2588	0.2603	275760.0
2010-07-21 19:00:00	NVDA	Stock	0.2603	0.2603	0.2595	0.26	24000.0
2010-07-21 07:00:00	AMZN	Stock	6.0245	6.0245	6.0245	6.0245	12000.0
2010-07-21 08:00:00	AMZN	Stock	6.025	6.057	5.975	6.056	129540.0
2010-07-21 09:00:00	AMZN	Stock	6.055	6.064	5.952	6.027	16636520.0
2010-07-21 10:00:00	AMZN	Stock	6.0255	6.0255	5.975	5.9765	13995440.0
2010-07-21 11:00:00	AMZN	Stock	5.9765	5.9805	5.902	5.9445	14513120.0
2010-07-21 12:00:00	AMZN	Stock	5.9455	5.979	5.9375	5.949	6524700.0
2010-07-21 13:00:00	AMZN	Stock	5.949	6.0125	5.9485	5.9935	7134020.0
2010-07-21 14:00:00	AMZN	Stock	5.9925	5.999	5.8755	5.882	17458000.0

> showing 50 of 42,815 rows — these rows as CSV

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