PREVIEW / stock_1hour / 2007-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-17.parquet
  size:    799 KB
  rows:    39,359
  symbols: 3,160

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-17 04:00:00	AAPL	Stock	6.0729	6.1375	6.0729	6.1218	14000.0
2007-10-17 06:00:00	AAPL	Stock	6.1143	6.1143	6.1143	6.1143	12600.0
2007-10-17 07:00:00	AAPL	Stock	6.1071	6.1964	6.1071	6.1779	1996484.0
2007-10-17 08:00:00	AAPL	Stock	6.1739	6.1964	6.1304	6.1554	10638292.0
2007-10-17 09:00:00	AAPL	Stock	6.155	6.18	6.125	6.1328	149054500.0
2007-10-17 10:00:00	AAPL	Stock	6.1336	6.1479	6.0946	6.1225	163864568.0
2007-10-17 11:00:00	AAPL	Stock	6.1229	6.1568	6.1143	6.1554	123058684.0
2007-10-17 12:00:00	AAPL	Stock	6.155	6.1579	6.1071	6.1093	108567760.0
2007-10-17 13:00:00	AAPL	Stock	6.1092	6.1207	6.0582	6.0688	169316896.0
2007-10-17 14:00:00	AAPL	Stock	6.0686	6.1154	6.0421	6.1045	169201788.0
2007-10-17 15:00:00	AAPL	Stock	6.1061	6.1696	6.0996	6.1696	199639888.0
2007-10-17 16:00:00	AAPL	Stock	6.1682	6.1964	6.1156	6.1454	24195808.0
2007-10-17 17:00:00	AAPL	Stock	6.1457	6.1571	6.1059	6.1404	7254856.0
2007-10-17 18:00:00	AAPL	Stock	6.1411	6.1546	6.1411	6.15	370832.0
2007-10-17 19:00:00	AAPL	Stock	6.1518	6.1607	6.1421	6.1446	425180.0
2007-10-17 07:00:00	MSFT	Stock	30.68	30.82	30.68	30.8	14600.0
2007-10-17 08:00:00	MSFT	Stock	30.81	30.84	30.75	30.78	50016.0
2007-10-17 09:00:00	MSFT	Stock	30.78	30.98	30.31	30.89	9096049.0
2007-10-17 10:00:00	MSFT	Stock	30.89	31.0	30.852	30.985	11295833.0
2007-10-17 11:00:00	MSFT	Stock	30.99	31.23	30.98	31.21	16464574.0
2007-10-17 12:00:00	MSFT	Stock	31.21	31.211	30.94	30.94	10971705.0
2007-10-17 13:00:00	MSFT	Stock	30.95	31.0	30.65	30.71	11275055.0
2007-10-17 14:00:00	MSFT	Stock	30.7	31.025	30.67	30.82	7563163.0
2007-10-17 15:00:00	MSFT	Stock	30.82	31.09	30.8	31.08	15371002.0
2007-10-17 16:00:00	MSFT	Stock	31.06	31.16	30.942	31.12	3048511.0
2007-10-17 17:00:00	MSFT	Stock	31.15	31.15	30.755	31.08	955461.0
2007-10-17 18:00:00	MSFT	Stock	31.0	31.04	31.0	31.0	2228.0
2007-10-17 19:00:00	MSFT	Stock	31.04	31.08	31.02	31.02	4183.0
2007-10-17 08:00:00	NVDA	Stock	0.9425	0.9445	0.9368	0.939	1251800.0
2007-10-17 09:00:00	NVDA	Stock	0.9402	0.9808	0.9402	0.9613	142048360.0
2007-10-17 10:00:00	NVDA	Stock	0.9615	0.9702	0.9562	0.969	78810720.0
2007-10-17 11:00:00	NVDA	Stock	0.969	0.98	0.9652	0.9792	94328080.0
2007-10-17 12:00:00	NVDA	Stock	0.9792	0.98	0.963	0.9632	70889520.0
2007-10-17 13:00:00	NVDA	Stock	0.963	0.9672	0.9548	0.9585	75072440.0
2007-10-17 14:00:00	NVDA	Stock	0.9585	0.978	0.9572	0.9685	65171480.0
2007-10-17 15:00:00	NVDA	Stock	0.968	0.9912	0.968	0.99	159990080.0
2007-10-17 16:00:00	NVDA	Stock	0.99	0.9945	0.9699	0.985	28136280.0
2007-10-17 17:00:00	NVDA	Stock	0.985	0.9862	0.9732	0.9862	1501760.0
2007-10-17 18:00:00	NVDA	Stock	0.9842	0.9845	0.984	0.984	173360.0
2007-10-17 19:00:00	NVDA	Stock	0.9835	0.9835	0.9835	0.9835	14000.0
2007-10-17 07:00:00	AMZN	Stock	4.55	4.55	4.549	4.55	22000.0
2007-10-17 08:00:00	AMZN	Stock	4.566	4.5775	4.5445	4.575	1815660.0
2007-10-17 09:00:00	AMZN	Stock	4.575	4.604	4.5225	4.5315	25379740.0
2007-10-17 10:00:00	AMZN	Stock	4.5305	4.5635	4.526	4.5525	19371760.0
2007-10-17 11:00:00	AMZN	Stock	4.5515	4.572	4.5285	4.562	17690520.0
2007-10-17 12:00:00	AMZN	Stock	4.5615	4.5685	4.535	4.5365	11378840.0
2007-10-17 13:00:00	AMZN	Stock	4.5375	4.5435	4.4625	4.476	19987220.0
2007-10-17 14:00:00	AMZN	Stock	4.4755	4.5065	4.453	4.496	20271900.0
2007-10-17 15:00:00	AMZN	Stock	4.4955	4.5275	4.4805	4.5275	28667280.0
2007-10-17 16:00:00	AMZN	Stock	4.523	4.5955	4.5055	4.543	6595720.0

> showing 50 of 39,359 rows — these rows as CSV

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