PREVIEW / stock_1hour / 2009-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-07.parquet
  size:    868 KB
  rows:    42,220
  symbols: 3,336

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-05-07 04:00:00	AAPL	Stock	4.7429	4.7429	4.7429	4.7429	2800.0
2009-05-07 06:00:00	AAPL	Stock	4.7607	4.7607	4.7571	4.7571	16800.0
2009-05-07 07:00:00	AAPL	Stock	4.7586	4.765	4.7586	4.7611	33600.0
2009-05-07 08:00:00	AAPL	Stock	4.7593	4.7607	4.7414	4.7457	911680.0
2009-05-07 09:00:00	AAPL	Stock	4.7457	4.7457	4.6175	4.6264	84553420.0
2009-05-07 10:00:00	AAPL	Stock	4.6239	4.63	4.5804	4.6139	103325600.0
2009-05-07 11:00:00	AAPL	Stock	4.6157	4.6243	4.5857	4.6136	44916900.0
2009-05-07 12:00:00	AAPL	Stock	4.6132	4.6132	4.5889	4.6005	28865284.0
2009-05-07 13:00:00	AAPL	Stock	4.6004	4.6011	4.5682	4.5696	58707992.0
2009-05-07 14:00:00	AAPL	Stock	4.57	4.5929	4.5679	4.5918	63946120.0
2009-05-07 15:00:00	AAPL	Stock	4.5918	4.6225	4.5736	4.6086	105864500.0
2009-05-07 16:00:00	AAPL	Stock	4.6075	4.6196	4.5864	4.6046	22134588.0
2009-05-07 17:00:00	AAPL	Stock	4.6096	4.6275	4.6096	4.6271	133280.0
2009-05-07 18:00:00	AAPL	Stock	4.6275	4.6393	4.6093	4.6321	1379728.0
2009-05-07 19:00:00	AAPL	Stock	4.6357	4.6393	4.6321	4.6339	25452.0
2009-05-07 06:00:00	MSFT	Stock	19.85	20.0	19.85	20.0	1263.0
2009-05-07 07:00:00	MSFT	Stock	19.99	19.99	19.9	19.9	2406.0
2009-05-07 08:00:00	MSFT	Stock	19.9	19.95	19.86	19.87	49482.0
2009-05-07 09:00:00	MSFT	Stock	19.89	19.99	19.5	19.51	7680103.0
2009-05-07 10:00:00	MSFT	Stock	19.51	19.56	19.27	19.44	14660418.0
2009-05-07 11:00:00	MSFT	Stock	19.44	19.5	19.37	19.478	4570698.0
2009-05-07 12:00:00	MSFT	Stock	19.47	19.48	19.31	19.435	3986670.0
2009-05-07 13:00:00	MSFT	Stock	19.44	19.44	19.32	19.395	5130157.0
2009-05-07 14:00:00	MSFT	Stock	19.37	19.4	19.2	19.23	7979531.0
2009-05-07 15:00:00	MSFT	Stock	19.24	19.46	19.14	19.37	15649701.0
2009-05-07 16:00:00	MSFT	Stock	19.33	19.55	19.292	19.32	5288579.0
2009-05-07 17:00:00	MSFT	Stock	19.39	19.41	19.32	19.41	33275.0
2009-05-07 18:00:00	MSFT	Stock	19.32	19.45	19.32	19.45	20009.0
2009-05-07 19:00:00	MSFT	Stock	19.45	19.47	19.42	19.46	10065.0
2009-05-07 07:00:00	NVDA	Stock	0.3	0.3	0.3	0.3	20000.0
2009-05-07 08:00:00	NVDA	Stock	0.2928	0.2975	0.2928	0.2972	289200.0
2009-05-07 09:00:00	NVDA	Stock	0.296	0.297	0.2785	0.279	125079080.0
2009-05-07 10:00:00	NVDA	Stock	0.279	0.2808	0.269	0.2743	265849600.0
2009-05-07 11:00:00	NVDA	Stock	0.2745	0.2745	0.268	0.271	123804800.0
2009-05-07 12:00:00	NVDA	Stock	0.271	0.2725	0.2675	0.2723	117989080.0
2009-05-07 13:00:00	NVDA	Stock	0.2723	0.273	0.2652	0.2658	131669320.0
2009-05-07 14:00:00	NVDA	Stock	0.2658	0.2679	0.2645	0.2668	142325680.0
2009-05-07 15:00:00	NVDA	Stock	0.2668	0.273	0.2658	0.268	276445560.0
2009-05-07 16:00:00	NVDA	Stock	0.2688	0.282	0.2468	0.2623	55471480.0
2009-05-07 17:00:00	NVDA	Stock	0.2625	0.267	0.2563	0.2568	12057760.0
2009-05-07 18:00:00	NVDA	Stock	0.257	0.26	0.2568	0.26	1642280.0
2009-05-07 19:00:00	NVDA	Stock	0.26	0.2645	0.26	0.2638	674400.0
2009-05-07 04:00:00	AMZN	Stock	4.1145	4.1145	4.1145	4.1145	3720.0
2009-05-07 08:00:00	AMZN	Stock	4.142	4.142	4.1225	4.1225	114380.0
2009-05-07 09:00:00	AMZN	Stock	4.1225	4.1475	4.0315	4.034	24357720.0
2009-05-07 10:00:00	AMZN	Stock	4.0345	4.037	3.964	3.9855	32844900.0
2009-05-07 11:00:00	AMZN	Stock	3.9845	3.9885	3.95	3.9765	21360860.0
2009-05-07 12:00:00	AMZN	Stock	3.978	3.983	3.9425	3.9585	16752260.0
2009-05-07 13:00:00	AMZN	Stock	3.959	3.9605	3.916	3.93	17356240.0
2009-05-07 14:00:00	AMZN	Stock	3.9316	3.947	3.894	3.941	33738440.0

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

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