PREVIEW / stock_1hour / 2007-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-18.parquet
  size:    814 KB
  rows:    40,556
  symbols: 3,124

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
2007-10-18 06:00:00	AAPL	Stock	6.1539	6.1539	6.1539	6.1539	8400.0
2007-10-18 07:00:00	AAPL	Stock	6.1661	6.1875	6.1232	6.1232	163100.0
2007-10-18 08:00:00	AAPL	Stock	6.1304	6.1339	6.0957	6.1286	2948540.0
2007-10-18 09:00:00	AAPL	Stock	6.1286	6.1539	6.1089	6.1364	125641712.0
2007-10-18 10:00:00	AAPL	Stock	6.1361	6.1675	6.1146	6.1543	128308684.0
2007-10-18 11:00:00	AAPL	Stock	6.1541	6.1625	6.1393	6.1518	81848900.0
2007-10-18 12:00:00	AAPL	Stock	6.1518	6.1568	6.1418	6.1489	58993676.0
2007-10-18 13:00:00	AAPL	Stock	6.1493	6.2029	6.1379	6.1971	106681036.0
2007-10-18 14:00:00	AAPL	Stock	6.1971	6.2204	6.1918	6.1975	143392508.0
2007-10-18 15:00:00	AAPL	Stock	6.1979	6.2211	6.1696	6.1964	146028680.0
2007-10-18 16:00:00	AAPL	Stock	6.1964	6.2139	6.1693	6.1868	25049976.0
2007-10-18 17:00:00	AAPL	Stock	6.1868	6.2143	6.1664	6.1664	4534096.0
2007-10-18 18:00:00	AAPL	Stock	6.2061	6.2196	6.1986	6.2057	1036644.0
2007-10-18 19:00:00	AAPL	Stock	6.2107	6.2129	6.2004	6.2107	357196.0
2007-10-18 08:00:00	MSFT	Stock	31.04	31.08	30.75	30.89	860398.0
2007-10-18 09:00:00	MSFT	Stock	30.9	31.23	30.85	30.93	5682372.0
2007-10-18 10:00:00	MSFT	Stock	30.92	31.03	30.81	30.825	6302071.0
2007-10-18 11:00:00	MSFT	Stock	30.825	30.93	30.63	30.89	7598039.0
2007-10-18 12:00:00	MSFT	Stock	30.89	31.09	30.84	30.98	6887554.0
2007-10-18 13:00:00	MSFT	Stock	30.981	31.11	30.9	31.09	4444608.0
2007-10-18 14:00:00	MSFT	Stock	31.09	31.19	30.97	31.06	5828426.0
2007-10-18 15:00:00	MSFT	Stock	31.07	31.2	31.04	31.14	8310005.0
2007-10-18 16:00:00	MSFT	Stock	31.14	31.2	30.9	31.05	2488395.0
2007-10-18 17:00:00	MSFT	Stock	31.16	31.18	30.985	30.995	967950.0
2007-10-18 18:00:00	MSFT	Stock	30.995	31.16	30.985	31.11	1600.0
2007-10-18 19:00:00	MSFT	Stock	31.12	35.2	31.12	31.2	6524.0
2007-10-18 08:00:00	NVDA	Stock	0.99	0.99	0.9765	0.9765	1467840.0
2007-10-18 09:00:00	NVDA	Stock	0.9765	0.9875	0.966	0.971	51756360.0
2007-10-18 10:00:00	NVDA	Stock	0.971	0.9775	0.967	0.9685	62972680.0
2007-10-18 11:00:00	NVDA	Stock	0.9682	0.973	0.9605	0.9712	46412280.0
2007-10-18 12:00:00	NVDA	Stock	0.9715	0.9745	0.9675	0.9738	19687720.0
2007-10-18 13:00:00	NVDA	Stock	0.9742	0.9882	0.9685	0.9862	34487600.0
2007-10-18 14:00:00	NVDA	Stock	0.9862	0.9912	0.9818	0.9842	38177120.0
2007-10-18 15:00:00	NVDA	Stock	0.9842	0.9918	0.9838	0.9868	66986960.0
2007-10-18 16:00:00	NVDA	Stock	0.986	0.9885	0.9776	0.9878	18787360.0
2007-10-18 17:00:00	NVDA	Stock	0.9885	0.9911	0.9854	0.9911	1826000.0
2007-10-18 18:00:00	NVDA	Stock	0.9862	0.9862	0.9838	0.9838	48320.0
2007-10-18 19:00:00	NVDA	Stock	0.9838	0.9838	0.9838	0.9838	12000.0
2007-10-18 08:00:00	AMZN	Stock	4.51	4.51	4.479	4.4795	273120.0
2007-10-18 09:00:00	AMZN	Stock	4.4845	4.501	4.453	4.472	17822700.0
2007-10-18 10:00:00	AMZN	Stock	4.472	4.5135	4.4695	4.48	19441060.0
2007-10-18 11:00:00	AMZN	Stock	4.48	4.491	4.4675	4.4855	11603800.0
2007-10-18 12:00:00	AMZN	Stock	4.4855	4.509	4.4735	4.4955	9452680.0
2007-10-18 13:00:00	AMZN	Stock	4.4935	4.52	4.4805	4.5193	10139180.0
2007-10-18 14:00:00	AMZN	Stock	4.5193	4.5215	4.483	4.49	10977280.0
2007-10-18 15:00:00	AMZN	Stock	4.4905	4.4995	4.478	4.49	19197080.0
2007-10-18 16:00:00	AMZN	Stock	4.49	4.5275	4.46	4.5275	6811600.0
2007-10-18 17:00:00	AMZN	Stock	4.465	4.5325	4.465	4.5075	792380.0
2007-10-18 18:00:00	AMZN	Stock	4.505	4.5145	4.494	4.494	223800.0
2007-10-18 19:00:00	AMZN	Stock	4.4925	4.4935	4.4745	4.4935	43000.0

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

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