PREVIEW / stock_5min / 2012-09-07

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-09-07.parquet
  size:    4.7 MB
  rows:    320,610
  symbols: 3,459

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
2012-09-07 04:15:00	AAPL	Stock	24.2489	24.2489	24.2489	24.2489	2800.0
2012-09-07 04:30:00	AAPL	Stock	24.25	24.25	24.2321	24.2321	11900.0
2012-09-07 04:45:00	AAPL	Stock	24.2411	24.2411	24.2411	24.2411	2800.0
2012-09-07 05:15:00	AAPL	Stock	24.2371	24.2375	24.2371	24.2375	5600.0
2012-09-07 06:30:00	AAPL	Stock	24.25	24.2679	24.25	24.2679	8400.0
2012-09-07 06:40:00	AAPL	Stock	24.25	24.25	24.25	24.25	2800.0
2012-09-07 06:50:00	AAPL	Stock	24.2475	24.2475	24.2475	24.2475	11116.0
2012-09-07 07:00:00	AAPL	Stock	24.2443	24.2464	24.2236	24.2339	33460.0
2012-09-07 07:05:00	AAPL	Stock	24.2371	24.2429	24.2371	24.2429	28000.0
2012-09-07 07:10:00	AAPL	Stock	24.2343	24.2464	24.2343	24.2393	14000.0
2012-09-07 07:15:00	AAPL	Stock	24.24	24.2429	24.2357	24.2393	23380.0
2012-09-07 07:20:00	AAPL	Stock	24.2393	24.2429	24.2279	24.2279	47992.0
2012-09-07 07:25:00	AAPL	Stock	24.2232	24.2279	24.2182	24.2279	14700.0
2012-09-07 07:30:00	AAPL	Stock	24.2357	24.2357	24.2357	24.2357	2800.0
2012-09-07 07:35:00	AAPL	Stock	24.2286	24.235	24.2221	24.235	41972.0
2012-09-07 07:40:00	AAPL	Stock	24.2232	24.2232	24.2232	24.2232	2800.0
2012-09-07 07:45:00	AAPL	Stock	24.2314	24.2375	24.2243	24.2321	104188.0
2012-09-07 07:50:00	AAPL	Stock	24.2179	24.2321	24.2179	24.2286	23800.0
2012-09-07 07:55:00	AAPL	Stock	24.2286	24.23	24.225	24.225	25200.0
2012-09-07 08:00:00	AAPL	Stock	24.2286	24.2429	24.1829	24.2121	205912.0
2012-09-07 08:05:00	AAPL	Stock	24.2043	24.2143	24.1918	24.2143	189392.0
2012-09-07 08:10:00	AAPL	Stock	24.2196	24.2196	24.1964	24.2054	56168.0
2012-09-07 08:15:00	AAPL	Stock	24.2054	24.2054	24.1986	24.205	36400.0
2012-09-07 08:20:00	AAPL	Stock	24.2054	24.2096	24.2054	24.2096	8400.0
2012-09-07 08:25:00	AAPL	Stock	24.2143	24.2321	24.2139	24.2321	121436.0
2012-09-07 08:30:00	AAPL	Stock	24.2321	24.2321	24.1507	24.1725	883008.0
2012-09-07 08:35:00	AAPL	Stock	24.1679	24.1893	24.1679	24.1807	274764.0
2012-09-07 08:40:00	AAPL	Stock	24.1807	24.2143	24.1786	24.2046	652904.0
2012-09-07 08:45:00	AAPL	Stock	24.2025	24.2111	24.1996	24.2007	201544.0
2012-09-07 08:50:00	AAPL	Stock	24.2	24.2071	24.1939	24.1943	342384.0
2012-09-07 08:55:00	AAPL	Stock	24.1857	24.2	24.1511	24.1525	589904.0
2012-09-07 09:00:00	AAPL	Stock	24.1525	24.1661	24.1464	24.1493	610456.0
2012-09-07 09:05:00	AAPL	Stock	24.1546	24.1546	24.1296	24.1393	265944.0
2012-09-07 09:10:00	AAPL	Stock	24.1389	24.1575	24.1389	24.1468	116144.0
2012-09-07 09:15:00	AAPL	Stock	24.16	24.1661	24.1539	24.1614	295792.0
2012-09-07 09:20:00	AAPL	Stock	24.1679	24.1857	24.1679	24.1857	98616.0
2012-09-07 09:25:00	AAPL	Stock	24.1918	24.2229	24.1832	24.2177	697172.0
2012-09-07 09:30:00	AAPL	Stock	24.2143	24.2229	24.1375	24.18	13965252.0
2012-09-07 09:35:00	AAPL	Stock	24.1834	24.1886	24.1357	24.1364	10642520.0
2012-09-07 09:40:00	AAPL	Stock	24.1361	24.25	24.1346	24.2457	13038480.0
2012-09-07 09:45:00	AAPL	Stock	24.2493	24.2746	24.22	24.255	9880584.0
2012-09-07 09:50:00	AAPL	Stock	24.2546	24.2589	24.2021	24.2096	6634628.0
2012-09-07 09:55:00	AAPL	Stock	24.2114	24.2479	24.2057	24.2414	4925284.0
2012-09-07 10:00:00	AAPL	Stock	24.2451	24.2857	24.2371	24.2682	11528608.0
2012-09-07 10:05:00	AAPL	Stock	24.2686	24.3175	24.2675	24.3043	13197212.0
2012-09-07 10:10:00	AAPL	Stock	24.3047	24.3393	24.295	24.3014	12147464.0
2012-09-07 10:15:00	AAPL	Stock	24.3046	24.3118	24.2754	24.3032	7320852.0
2012-09-07 10:20:00	AAPL	Stock	24.3041	24.3118	24.2768	24.2979	4170740.0
2012-09-07 10:25:00	AAPL	Stock	24.2939	24.3064	24.2671	24.2861	4833136.0
2012-09-07 10:30:00	AAPL	Stock	24.2875	24.2929	24.2679	24.2746	3706948.0

> showing 50 of 320,610 rows — these rows as CSV

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