PREVIEW / stock_1hour / 2009-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-04.parquet
  size:    863 KB
  rows:    42,153
  symbols: 3,347

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-06-04 05:00:00	AAPL	Stock	5.0786	5.0786	5.0786	5.0786	2800.0
2009-06-04 06:00:00	AAPL	Stock	5.0232	5.0321	5.0232	5.0321	31500.0
2009-06-04 07:00:00	AAPL	Stock	5.0357	5.0357	5.0089	5.0143	463876.0
2009-06-04 08:00:00	AAPL	Stock	5.0179	5.0296	5.0032	5.0089	3064712.0
2009-06-04 09:00:00	AAPL	Stock	5.0089	5.1121	4.9946	5.1079	120457232.0
2009-06-04 10:00:00	AAPL	Stock	5.1079	5.1286	5.0989	5.1171	110753244.0
2009-06-04 11:00:00	AAPL	Stock	5.1164	5.1307	5.0893	5.1194	49337904.0
2009-06-04 12:00:00	AAPL	Stock	5.12	5.1321	5.105	5.1302	38154452.0
2009-06-04 13:00:00	AAPL	Stock	5.1304	5.14	5.1221	5.1296	47430096.0
2009-06-04 14:00:00	AAPL	Stock	5.13	5.1329	5.1154	5.1254	45705800.0
2009-06-04 15:00:00	AAPL	Stock	5.1254	5.1493	5.1182	5.1311	102840920.0
2009-06-04 16:00:00	AAPL	Stock	5.1311	5.1446	5.1027	5.1357	20090224.0
2009-06-04 17:00:00	AAPL	Stock	5.1332	5.1429	5.1332	5.14	396816.0
2009-06-04 18:00:00	AAPL	Stock	5.14	5.1407	5.1336	5.14	548744.0
2009-06-04 19:00:00	AAPL	Stock	5.1382	5.2375	5.1382	5.2232	3510052.0
2009-06-04 07:00:00	MSFT	Stock	21.9	21.9	21.9	21.9	400.0
2009-06-04 08:00:00	MSFT	Stock	21.76	21.85	21.7	21.85	49345.0
2009-06-04 09:00:00	MSFT	Stock	21.85	21.9	21.73	21.78	3689263.0
2009-06-04 10:00:00	MSFT	Stock	21.79	21.85	21.58	21.79	6901544.0
2009-06-04 11:00:00	MSFT	Stock	21.79	21.8	21.69	21.705	4055829.0
2009-06-04 12:00:00	MSFT	Stock	21.717	21.74	21.63	21.63	4242434.0
2009-06-04 13:00:00	MSFT	Stock	21.64	21.82	21.63	21.72	3666972.0
2009-06-04 14:00:00	MSFT	Stock	21.71	21.82	21.71	21.77	3717453.0
2009-06-04 15:00:00	MSFT	Stock	21.77	21.87	21.72	21.81	9354959.0
2009-06-04 16:00:00	MSFT	Stock	21.82	21.86	21.675	21.83	4417045.0
2009-06-04 17:00:00	MSFT	Stock	21.83	21.84	21.83	21.83	11152.0
2009-06-04 18:00:00	MSFT	Stock	21.79	21.79	21.79	21.79	1000.0
2009-06-04 19:00:00	MSFT	Stock	21.82	21.85	21.8	21.85	2600.0
2009-06-04 09:00:00	NVDA	Stock	0.2663	0.272	0.2632	0.2695	81720200.0
2009-06-04 10:00:00	NVDA	Stock	0.27	0.27	0.2648	0.2688	78409320.0
2009-06-04 11:00:00	NVDA	Stock	0.2688	0.2728	0.268	0.271	106140600.0
2009-06-04 12:00:00	NVDA	Stock	0.2708	0.2715	0.2685	0.2703	61369400.0
2009-06-04 13:00:00	NVDA	Stock	0.2703	0.2723	0.2701	0.2718	80531040.0
2009-06-04 14:00:00	NVDA	Stock	0.2718	0.272	0.27	0.2712	65218720.0
2009-06-04 15:00:00	NVDA	Stock	0.2712	0.2725	0.2705	0.272	180763480.0
2009-06-04 16:00:00	NVDA	Stock	0.272	0.2725	0.2679	0.2725	17898200.0
2009-06-04 17:00:00	NVDA	Stock	0.2723	0.2725	0.2723	0.2725	36600.0
2009-06-04 18:00:00	NVDA	Stock	0.2725	0.273	0.2725	0.273	28000.0
2009-06-04 19:00:00	NVDA	Stock	0.2735	0.2743	0.2735	0.2743	68120.0
2009-06-04 07:00:00	AMZN	Stock	4.3	4.3	4.288	4.288	4000.0
2009-06-04 08:00:00	AMZN	Stock	4.2995	4.2995	4.2675	4.275	92800.0
2009-06-04 09:00:00	AMZN	Stock	4.285	4.32	4.2365	4.303	20553620.0
2009-06-04 10:00:00	AMZN	Stock	4.3025	4.306	4.2515	4.2742	20503240.0
2009-06-04 11:00:00	AMZN	Stock	4.2745	4.2825	4.2402	4.245	11469060.0
2009-06-04 12:00:00	AMZN	Stock	4.245	4.256	4.2285	4.2525	10496120.0
2009-06-04 13:00:00	AMZN	Stock	4.253	4.2915	4.248	4.2715	11295960.0
2009-06-04 14:00:00	AMZN	Stock	4.2715	4.2815	4.249	4.2535	9714820.0
2009-06-04 15:00:00	AMZN	Stock	4.254	4.29	4.245	4.274	18752240.0
2009-06-04 16:00:00	AMZN	Stock	4.2765	4.287	4.2659	4.2758	3223400.0
2009-06-04 17:00:00	AMZN	Stock	4.2795	4.284	4.2725	4.2725	384380.0

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

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