PREVIEW / stock_1hour / 2009-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-07.parquet
  size:    840 KB
  rows:    42,839
  symbols: 3,301

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-07 05:00:00	AAPL	Stock	4.1607	4.1607	4.1429	4.1429	14448.0
2009-04-07 06:00:00	AAPL	Stock	4.1804	4.1804	4.1793	4.1793	5600.0
2009-04-07 07:00:00	AAPL	Stock	4.1607	4.1743	4.1475	4.1625	90860.0
2009-04-07 08:00:00	AAPL	Stock	4.1589	4.1721	4.1536	4.1646	913360.0
2009-04-07 09:00:00	AAPL	Stock	4.1671	4.1714	4.1236	4.1296	73907624.0
2009-04-07 10:00:00	AAPL	Stock	4.1293	4.1496	4.0936	4.1307	110737340.0
2009-04-07 11:00:00	AAPL	Stock	4.1311	4.1371	4.1054	4.1096	51862020.0
2009-04-07 12:00:00	AAPL	Stock	4.1096	4.1304	4.1014	4.1209	50948716.0
2009-04-07 13:00:00	AAPL	Stock	4.1218	4.1218	4.0782	4.0932	63245784.0
2009-04-07 14:00:00	AAPL	Stock	4.0931	4.0964	4.0782	4.0932	44298576.0
2009-04-07 15:00:00	AAPL	Stock	4.0932	4.1346	4.0804	4.0989	115780728.0
2009-04-07 16:00:00	AAPL	Stock	4.1071	4.12	4.0986	4.1136	18488400.0
2009-04-07 17:00:00	AAPL	Stock	4.1121	4.225	4.1071	4.1071	647052.0
2009-04-07 18:00:00	AAPL	Stock	4.1071	4.1125	4.105	4.1054	1026648.0
2009-04-07 19:00:00	AAPL	Stock	4.1054	4.1107	4.105	4.1071	88172.0
2009-04-07 04:00:00	MSFT	Stock	18.82	18.86	18.8	18.83	4625.0
2009-04-07 05:00:00	MSFT	Stock	18.83	18.83	18.7	18.7	700.0
2009-04-07 06:00:00	MSFT	Stock	18.62	18.65	18.62	18.65	2100.0
2009-04-07 07:00:00	MSFT	Stock	18.52	18.52	18.52	18.52	200.0
2009-04-07 08:00:00	MSFT	Stock	18.65	18.67	18.52	18.63	17185.0
2009-04-07 09:00:00	MSFT	Stock	18.63	19.5	18.63	19.09	11505670.0
2009-04-07 10:00:00	MSFT	Stock	19.092	19.1	18.96	19.03	10136562.0
2009-04-07 11:00:00	MSFT	Stock	19.03	19.06	18.97	19.01	5727153.0
2009-04-07 12:00:00	MSFT	Stock	19.01	19.05	18.91	18.98	5508989.0
2009-04-07 13:00:00	MSFT	Stock	18.98	18.99	18.7	18.76	8398586.0
2009-04-07 14:00:00	MSFT	Stock	18.762	18.77	18.63	18.77	6215704.0
2009-04-07 15:00:00	MSFT	Stock	18.765	18.941	18.7	18.71	14527042.0
2009-04-07 16:00:00	MSFT	Stock	18.72	18.964	18.72	18.84	2971500.0
2009-04-07 17:00:00	MSFT	Stock	18.8	18.86	18.76	18.83	19924.0
2009-04-07 18:00:00	MSFT	Stock	18.82	18.87	18.76	18.85	17021.0
2009-04-07 19:00:00	MSFT	Stock	18.85	18.85	18.84	18.84	3835.0
2009-04-07 20:00:00	MSFT	Stock	19.0	19.0	19.0	19.0	1300.0
2009-04-07 08:00:00	NVDA	Stock	0.283	0.2832	0.2788	0.2792	745040.0
2009-04-07 09:00:00	NVDA	Stock	0.2795	0.281	0.2723	0.2783	109423160.0
2009-04-07 10:00:00	NVDA	Stock	0.2783	0.2812	0.276	0.28	117761120.0
2009-04-07 11:00:00	NVDA	Stock	0.2803	0.2803	0.2755	0.276	83317960.0
2009-04-07 12:00:00	NVDA	Stock	0.2763	0.2778	0.275	0.2775	61362880.0
2009-04-07 13:00:00	NVDA	Stock	0.2775	0.2778	0.2725	0.2736	55665000.0
2009-04-07 14:00:00	NVDA	Stock	0.2735	0.2748	0.2725	0.2745	39931800.0
2009-04-07 15:00:00	NVDA	Stock	0.2745	0.277	0.273	0.2738	119906840.0
2009-04-07 16:00:00	NVDA	Stock	0.274	0.2775	0.2732	0.2772	16059880.0
2009-04-07 17:00:00	NVDA	Stock	0.274	0.2758	0.274	0.2752	146640.0
2009-04-07 18:00:00	NVDA	Stock	0.2752	0.2755	0.274	0.2752	91880.0
2009-04-07 20:00:00	NVDA	Stock	0.276	0.276	0.276	0.276	124000.0
2009-04-07 07:00:00	AMZN	Stock	3.841	3.841	3.841	3.841	2000.0
2009-04-07 08:00:00	AMZN	Stock	3.85	3.86	3.841	3.86	62300.0
2009-04-07 09:00:00	AMZN	Stock	3.86	3.86	3.805	3.8095	12459200.0
2009-04-07 10:00:00	AMZN	Stock	3.807	3.854	3.775	3.833	20166840.0
2009-04-07 11:00:00	AMZN	Stock	3.8335	3.836	3.784	3.7925	11889200.0
2009-04-07 12:00:00	AMZN	Stock	3.7925	3.8165	3.7895	3.813	10051160.0

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

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