PREVIEW / stock_5min / 2010-04-21

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-04-21.parquet
  size:    4.8 MB
  rows:    326,210
  symbols: 3,468

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
2010-04-21 04:15:00	AAPL	Stock	9.125	9.1825	9.0732	9.1825	32200.0
2010-04-21 04:20:00	AAPL	Stock	9.1789	9.1789	9.1789	9.1789	2800.0
2010-04-21 04:35:00	AAPL	Stock	9.1964	9.205	9.1964	9.1964	8792.0
2010-04-21 04:45:00	AAPL	Stock	9.1782	9.1782	9.1429	9.1429	54600.0
2010-04-21 05:00:00	AAPL	Stock	9.1964	9.1964	9.1786	9.1786	37044.0
2010-04-21 05:10:00	AAPL	Stock	9.185	9.185	9.185	9.185	2800.0
2010-04-21 05:15:00	AAPL	Stock	9.1696	9.1696	9.1696	9.1696	2800.0
2010-04-21 05:30:00	AAPL	Stock	9.1704	9.1704	9.1704	9.1704	5600.0
2010-04-21 05:55:00	AAPL	Stock	9.195	9.1964	9.195	9.1964	30324.0
2010-04-21 06:20:00	AAPL	Stock	9.1786	9.2196	9.1786	9.2196	71260.0
2010-04-21 06:30:00	AAPL	Stock	9.1946	9.215	9.1904	9.215	50400.0
2010-04-21 06:35:00	AAPL	Stock	9.2232	9.2232	9.2168	9.2168	75376.0
2010-04-21 06:40:00	AAPL	Stock	9.2168	9.2168	9.2168	9.2168	2800.0
2010-04-21 06:45:00	AAPL	Stock	9.2214	9.2214	9.215	9.2214	18900.0
2010-04-21 06:50:00	AAPL	Stock	9.1993	9.1993	9.1964	9.1964	14000.0
2010-04-21 06:55:00	AAPL	Stock	9.1964	9.1964	9.1964	9.1964	5600.0
2010-04-21 07:00:00	AAPL	Stock	9.2139	9.2143	9.1929	9.1929	49140.0
2010-04-21 07:05:00	AAPL	Stock	9.1961	9.2143	9.1961	9.2054	152432.0
2010-04-21 07:10:00	AAPL	Stock	9.2054	9.2571	9.2018	9.2339	420000.0
2010-04-21 07:15:00	AAPL	Stock	9.2496	9.2846	9.2464	9.2464	266448.0
2010-04-21 07:20:00	AAPL	Stock	9.2643	9.2643	9.25	9.25	462868.0
2010-04-21 07:25:00	AAPL	Stock	9.2489	9.2489	9.2321	9.2321	263564.0
2010-04-21 07:30:00	AAPL	Stock	9.2321	9.2429	9.205	9.205	110180.0
2010-04-21 07:35:00	AAPL	Stock	9.2179	9.2214	9.2036	9.205	82124.0
2010-04-21 07:40:00	AAPL	Stock	9.2036	9.2054	9.1971	9.2018	158312.0
2010-04-21 07:45:00	AAPL	Stock	9.2036	9.2321	9.1989	9.2321	224364.0
2010-04-21 07:50:00	AAPL	Stock	9.2318	9.2386	9.2225	9.2386	123256.0
2010-04-21 07:55:00	AAPL	Stock	9.2407	9.2679	9.2393	9.2679	276696.0
2010-04-21 08:00:00	AAPL	Stock	9.265	9.265	9.2054	9.2071	1484000.0
2010-04-21 08:05:00	AAPL	Stock	9.2075	9.2143	9.1679	9.1704	1519784.0
2010-04-21 08:10:00	AAPL	Stock	9.1721	9.2114	9.1721	9.1946	1369900.0
2010-04-21 08:15:00	AAPL	Stock	9.1946	9.2029	9.1879	9.2029	499240.0
2010-04-21 08:20:00	AAPL	Stock	9.2032	9.2107	9.1982	9.21	746060.0
2010-04-21 08:25:00	AAPL	Stock	9.2086	9.2186	9.2057	9.21	770084.0
2010-04-21 08:30:00	AAPL	Stock	9.2121	9.2175	9.2093	9.2143	440076.0
2010-04-21 08:35:00	AAPL	Stock	9.2175	9.2264	9.2171	9.2264	489048.0
2010-04-21 08:40:00	AAPL	Stock	9.2257	9.2304	9.2214	9.225	508116.0
2010-04-21 08:45:00	AAPL	Stock	9.2239	9.2389	9.2214	9.2364	841736.0
2010-04-21 08:50:00	AAPL	Stock	9.2361	9.2561	9.2357	9.2504	1541428.0
2010-04-21 08:55:00	AAPL	Stock	9.25	9.2732	9.2496	9.2732	2033472.0
2010-04-21 09:00:00	AAPL	Stock	9.2743	9.2846	9.2618	9.2668	2186212.0
2010-04-21 09:05:00	AAPL	Stock	9.2673	9.2836	9.2673	9.2814	1230712.0
2010-04-21 09:10:00	AAPL	Stock	9.2829	9.2879	9.2682	9.2746	3061044.0
2010-04-21 09:15:00	AAPL	Stock	9.2746	9.2829	9.2632	9.2632	1125964.0
2010-04-21 09:20:00	AAPL	Stock	9.265	9.3214	9.2625	9.3107	2471504.0
2010-04-21 09:25:00	AAPL	Stock	9.3136	9.315	9.2425	9.2425	3655960.0
2010-04-21 09:30:00	AAPL	Stock	9.2429	9.2811	9.1332	9.1764	99145144.0
2010-04-21 09:35:00	AAPL	Stock	9.1779	9.2446	9.1568	9.2311	61212536.0
2010-04-21 09:40:00	AAPL	Stock	9.2314	9.2375	9.2036	9.2279	31970260.0
2010-04-21 09:45:00	AAPL	Stock	9.2282	9.275	9.2279	9.2647	41237364.0

> showing 50 of 326,210 rows — these rows as CSV

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