PREVIEW / stock_5min / 2007-11-14

all stock 5-min files

  file:    by_date/stock_5min/2007/2007-11-14.parquet
  size:    4.3 MB
  rows:    317,427
  symbols: 3,204

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-11-14 04:55:00	AAPL	Stock	6.2321	6.2321	6.2107	6.2107	13888.0
2007-11-14 05:00:00	AAPL	Stock	6.2214	6.2214	6.2214	6.2214	8708.0
2007-11-14 05:05:00	AAPL	Stock	6.225	6.225	6.225	6.225	11200.0
2007-11-14 05:10:00	AAPL	Stock	6.2436	6.2436	6.2436	6.2436	5600.0
2007-11-14 05:15:00	AAPL	Stock	6.2257	6.2257	6.22	6.22	11200.0
2007-11-14 05:20:00	AAPL	Stock	6.2161	6.2161	6.2161	6.2161	50316.0
2007-11-14 05:25:00	AAPL	Stock	6.2339	6.2339	6.2339	6.2339	2800.0
2007-11-14 05:45:00	AAPL	Stock	6.2246	6.2246	6.2246	6.2246	28000.0
2007-11-14 05:50:00	AAPL	Stock	6.2496	6.2496	6.2496	6.2496	8400.0
2007-11-14 05:55:00	AAPL	Stock	6.2214	6.2214	6.22	6.22	11200.0
2007-11-14 06:00:00	AAPL	Stock	6.2339	6.235	6.2339	6.235	5600.0
2007-11-14 06:25:00	AAPL	Stock	6.2232	6.2232	6.22	6.22	22400.0
2007-11-14 06:30:00	AAPL	Stock	6.2375	6.2375	6.2375	6.2375	5460.0
2007-11-14 06:35:00	AAPL	Stock	6.2268	6.2268	6.2164	6.2164	16800.0
2007-11-14 06:40:00	AAPL	Stock	6.2164	6.2164	6.2021	6.2036	215600.0
2007-11-14 06:45:00	AAPL	Stock	6.2036	6.2143	6.1982	6.2143	34160.0
2007-11-14 06:50:00	AAPL	Stock	6.2036	6.2107	6.2036	6.2089	60844.0
2007-11-14 07:00:00	AAPL	Stock	6.1982	6.1982	6.1482	6.1482	158200.0
2007-11-14 07:05:00	AAPL	Stock	6.1482	6.1682	6.1482	6.1682	56000.0
2007-11-14 07:10:00	AAPL	Stock	6.1607	6.1607	6.1536	6.1536	33600.0
2007-11-14 07:15:00	AAPL	Stock	6.1607	6.1643	6.1607	6.1607	123900.0
2007-11-14 07:20:00	AAPL	Stock	6.1518	6.1589	6.1429	6.1429	80304.0
2007-11-14 07:25:00	AAPL	Stock	6.1518	6.1607	6.1375	6.1607	99260.0
2007-11-14 07:30:00	AAPL	Stock	6.1446	6.1586	6.1375	6.1454	89180.0
2007-11-14 07:35:00	AAPL	Stock	6.15	6.1614	6.1321	6.1321	187600.0
2007-11-14 07:40:00	AAPL	Stock	6.1332	6.1375	6.1111	6.1329	434336.0
2007-11-14 07:45:00	AAPL	Stock	6.1339	6.1432	6.1339	6.1407	246120.0
2007-11-14 07:50:00	AAPL	Stock	6.1525	6.1625	6.1464	6.1621	278656.0
2007-11-14 07:55:00	AAPL	Stock	6.1536	6.1607	6.1446	6.1607	149940.0
2007-11-14 08:00:00	AAPL	Stock	6.1607	6.1786	6.1279	6.1393	1994048.0
2007-11-14 08:05:00	AAPL	Stock	6.1379	6.1429	6.1354	6.1389	753844.0
2007-11-14 08:10:00	AAPL	Stock	6.1379	6.1696	6.1354	6.1696	1384292.0
2007-11-14 08:15:00	AAPL	Stock	6.1693	6.1789	6.1575	6.1786	1879444.0
2007-11-14 08:20:00	AAPL	Stock	6.1786	6.1921	6.1421	6.1843	1037428.0
2007-11-14 08:25:00	AAPL	Stock	6.1846	6.1875	6.1754	6.1789	1725780.0
2007-11-14 08:30:00	AAPL	Stock	6.1839	6.2571	6.1839	6.2464	6362468.0
2007-11-14 08:35:00	AAPL	Stock	6.2482	6.2679	6.2482	6.2679	4057480.0
2007-11-14 08:40:00	AAPL	Stock	6.2679	6.2736	6.25	6.2518	2213876.0
2007-11-14 08:45:00	AAPL	Stock	6.2521	6.2875	6.2493	6.2729	3733436.0
2007-11-14 08:50:00	AAPL	Stock	6.2729	6.2857	6.2679	6.2811	3097500.0
2007-11-14 08:55:00	AAPL	Stock	6.2818	6.2839	6.2714	6.2725	1322496.0
2007-11-14 09:00:00	AAPL	Stock	6.2746	6.2757	6.2571	6.2696	4623108.0
2007-11-14 09:05:00	AAPL	Stock	6.2682	6.2925	6.26	6.2896	1761816.0
2007-11-14 09:10:00	AAPL	Stock	6.2918	6.305	6.2839	6.2932	3169684.0
2007-11-14 09:15:00	AAPL	Stock	6.2936	6.3007	6.2825	6.2871	644728.0
2007-11-14 09:20:00	AAPL	Stock	6.2864	6.2879	6.2775	6.2821	1140272.0
2007-11-14 09:25:00	AAPL	Stock	6.2807	6.3393	6.2768	6.3271	7437528.0
2007-11-14 09:30:00	AAPL	Stock	6.3275	6.3418	6.2604	6.2814	76003620.0
2007-11-14 09:35:00	AAPL	Stock	6.28	6.3	6.2589	6.2693	37523528.0
2007-11-14 09:40:00	AAPL	Stock	6.2696	6.2711	6.2104	6.2248	47562396.0

> showing 50 of 317,427 rows — these rows as CSV

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