PREVIEW / stock_1hour / 2009-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-03.parquet
  size:    817 KB
  rows:    40,413
  symbols: 3,331

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-04-03 06:00:00	AAPL	Stock	4.1032	4.1246	4.1032	4.1246	34552.0
2009-04-03 07:00:00	AAPL	Stock	4.1079	4.1382	4.1079	4.125	379204.0
2009-04-03 08:00:00	AAPL	Stock	4.1171	4.125	4.0	4.0871	2520588.0
2009-04-03 09:00:00	AAPL	Stock	4.0871	4.1157	4.0543	4.0943	90157900.0
2009-04-03 10:00:00	AAPL	Stock	4.0925	4.1232	4.0679	4.1156	102392220.0
2009-04-03 11:00:00	AAPL	Stock	4.1157	4.1464	4.0696	4.1429	81366712.0
2009-04-03 12:00:00	AAPL	Stock	4.1429	4.1475	4.1089	4.1204	68568444.0
2009-04-03 13:00:00	AAPL	Stock	4.1211	4.1446	4.1179	4.1381	64344280.0
2009-04-03 14:00:00	AAPL	Stock	4.1392	4.1425	4.1246	4.1379	66150504.0
2009-04-03 15:00:00	AAPL	Stock	4.1375	4.1436	4.1114	4.1421	114599632.0
2009-04-03 16:00:00	AAPL	Stock	4.1421	4.1511	4.1162	4.1454	11521748.0
2009-04-03 17:00:00	AAPL	Stock	4.1457	4.1482	4.1425	4.1471	479920.0
2009-04-03 18:00:00	AAPL	Stock	4.1464	4.1482	4.1425	4.1457	3056200.0
2009-04-03 19:00:00	AAPL	Stock	4.1457	4.1471	4.1446	4.1464	66444.0
2009-04-03 07:00:00	MSFT	Stock	19.4	19.4	19.31	19.31	1900.0
2009-04-03 08:00:00	MSFT	Stock	19.31	19.4	19.01	19.08	48198.0
2009-04-03 09:00:00	MSFT	Stock	19.1	19.17	18.7	18.75	9663091.0
2009-04-03 10:00:00	MSFT	Stock	18.75	18.77	18.5	18.56	14543987.0
2009-04-03 11:00:00	MSFT	Stock	18.56	18.72	18.434	18.659	10923387.0
2009-04-03 12:00:00	MSFT	Stock	18.66	18.88	18.65	18.75	9026354.0
2009-04-03 13:00:00	MSFT	Stock	18.74	18.81	18.65	18.77	6491831.0
2009-04-03 14:00:00	MSFT	Stock	18.78	18.82	18.68	18.78	7615565.0
2009-04-03 15:00:00	MSFT	Stock	18.79	18.84	18.51	18.84	17452880.0
2009-04-03 16:00:00	MSFT	Stock	18.74	18.8	18.644	18.7	2638814.0
2009-04-03 17:00:00	MSFT	Stock	18.72	18.74	18.57	18.73	22172.0
2009-04-03 18:00:00	MSFT	Stock	18.74	18.75	18.72	18.72	431509.0
2009-04-03 19:00:00	MSFT	Stock	18.73	18.73	18.7	18.73	4539.0
2009-04-03 08:00:00	NVDA	Stock	0.2705	0.2705	0.2628	0.2635	673440.0
2009-04-03 09:00:00	NVDA	Stock	0.2628	0.2685	0.2603	0.2663	78937160.0
2009-04-03 10:00:00	NVDA	Stock	0.2663	0.2743	0.2649	0.2728	207713600.0
2009-04-03 11:00:00	NVDA	Stock	0.273	0.2803	0.2715	0.2798	171236600.0
2009-04-03 12:00:00	NVDA	Stock	0.2798	0.283	0.2792	0.2803	142200360.0
2009-04-03 13:00:00	NVDA	Stock	0.2803	0.2836	0.28	0.2815	129523720.0
2009-04-03 14:00:00	NVDA	Stock	0.2815	0.2832	0.2802	0.2828	84270960.0
2009-04-03 15:00:00	NVDA	Stock	0.2828	0.283	0.28	0.283	171665320.0
2009-04-03 16:00:00	NVDA	Stock	0.283	0.2868	0.2765	0.2835	4360200.0
2009-04-03 17:00:00	NVDA	Stock	0.2767	0.2835	0.2767	0.2835	2547880.0
2009-04-03 18:00:00	NVDA	Stock	0.2838	0.2838	0.2838	0.2838	8000.0
2009-04-03 19:00:00	NVDA	Stock	0.2838	0.2838	0.2835	0.2835	8120.0
2009-04-03 08:00:00	AMZN	Stock	3.867	3.884	3.8345	3.8345	398300.0
2009-04-03 09:00:00	AMZN	Stock	3.83	3.844	3.775	3.802	17927400.0
2009-04-03 10:00:00	AMZN	Stock	3.8015	3.835	3.775	3.806	20035940.0
2009-04-03 11:00:00	AMZN	Stock	3.8065	3.8485	3.805	3.8475	11628960.0
2009-04-03 12:00:00	AMZN	Stock	3.8465	3.889	3.8415	3.8664	16429760.0
2009-04-03 13:00:00	AMZN	Stock	3.866	3.8895	3.85	3.8835	9093700.0
2009-04-03 14:00:00	AMZN	Stock	3.8835	3.8965	3.8615	3.8855	11470800.0
2009-04-03 15:00:00	AMZN	Stock	3.8855	3.916	3.867	3.9095	25941440.0
2009-04-03 16:00:00	AMZN	Stock	3.909	3.926	3.8476	3.91	660500.0
2009-04-03 17:00:00	AMZN	Stock	3.91	3.92	3.91	3.9125	25600.0
2009-04-03 18:00:00	AMZN	Stock	3.9105	3.916	3.9105	3.916	12000.0

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

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