PREVIEW / stock_5min / 2012-01-25

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-01-25.parquet
  size:    4.9 MB
  rows:    326,253
  symbols: 3,536

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-01-25 04:00:00	AAPL	Stock	16.1143	16.1143	16.0657	16.0875	67256.0
2012-01-25 04:05:00	AAPL	Stock	16.0854	16.0854	16.0793	16.0793	19600.0
2012-01-25 04:10:00	AAPL	Stock	16.0714	16.0714	16.0714	16.0714	2800.0
2012-01-25 04:15:00	AAPL	Stock	16.0679	16.0679	16.0679	16.0679	26320.0
2012-01-25 04:20:00	AAPL	Stock	16.0543	16.0543	16.0536	16.0536	8400.0
2012-01-25 04:25:00	AAPL	Stock	16.0536	16.0543	16.05	16.0543	21364.0
2012-01-25 04:35:00	AAPL	Stock	16.0571	16.0643	16.0571	16.0643	25200.0
2012-01-25 04:40:00	AAPL	Stock	16.0564	16.0564	16.0411	16.0411	19040.0
2012-01-25 04:45:00	AAPL	Stock	16.0629	16.0639	16.0607	16.0639	25172.0
2012-01-25 04:50:00	AAPL	Stock	16.0686	16.0686	16.0643	16.0643	22400.0
2012-01-25 04:55:00	AAPL	Stock	16.0714	16.0725	16.0643	16.0682	35000.0
2012-01-25 05:00:00	AAPL	Stock	16.0643	16.0793	16.0643	16.0793	58800.0
2012-01-25 05:05:00	AAPL	Stock	16.0661	16.0793	16.0607	16.0793	27832.0
2012-01-25 05:10:00	AAPL	Stock	16.0793	16.0793	16.0793	16.0793	2800.0
2012-01-25 05:20:00	AAPL	Stock	16.075	16.0768	16.0746	16.0768	25200.0
2012-01-25 05:25:00	AAPL	Stock	16.0714	16.0804	16.0714	16.0804	30520.0
2012-01-25 05:30:00	AAPL	Stock	16.075	16.0804	16.075	16.0804	19964.0
2012-01-25 05:35:00	AAPL	Stock	16.0804	16.0893	16.0625	16.0893	76440.0
2012-01-25 05:50:00	AAPL	Stock	16.0821	16.0821	16.0786	16.0786	8400.0
2012-01-25 05:55:00	AAPL	Stock	16.0871	16.1393	16.0871	16.1393	64820.0
2012-01-25 06:00:00	AAPL	Stock	16.11	16.1429	16.11	16.1357	70000.0
2012-01-25 06:05:00	AAPL	Stock	16.1254	16.1536	16.1111	16.1536	35000.0
2012-01-25 06:10:00	AAPL	Stock	16.1357	16.1357	16.1357	16.1357	8400.0
2012-01-25 06:15:00	AAPL	Stock	16.1386	16.1429	16.125	16.1429	28000.0
2012-01-25 06:20:00	AAPL	Stock	16.1429	16.1429	16.1429	16.1429	5600.0
2012-01-25 06:30:00	AAPL	Stock	16.1339	16.1429	16.1339	16.1429	28000.0
2012-01-25 06:40:00	AAPL	Stock	16.1536	16.1536	16.1339	16.1339	28364.0
2012-01-25 06:45:00	AAPL	Stock	16.1339	16.1339	16.1321	16.1321	77000.0
2012-01-25 06:50:00	AAPL	Stock	16.1429	16.1429	16.1429	16.1429	4480.0
2012-01-25 06:55:00	AAPL	Stock	16.1429	16.1429	16.1429	16.1429	28000.0
2012-01-25 07:00:00	AAPL	Stock	16.1339	16.1607	16.1339	16.16	413728.0
2012-01-25 07:05:00	AAPL	Stock	16.1571	16.1679	16.1554	16.1643	288792.0
2012-01-25 07:10:00	AAPL	Stock	16.1661	16.1964	16.1661	16.1786	455000.0
2012-01-25 07:15:00	AAPL	Stock	16.1782	16.1875	16.1661	16.1786	228256.0
2012-01-25 07:20:00	AAPL	Stock	16.1714	16.1786	16.1607	16.1786	172088.0
2012-01-25 07:25:00	AAPL	Stock	16.1761	16.1882	16.1643	16.1786	356748.0
2012-01-25 07:30:00	AAPL	Stock	16.1786	16.1946	16.1786	16.1789	127820.0
2012-01-25 07:35:00	AAPL	Stock	16.1786	16.1804	16.1571	16.1714	310492.0
2012-01-25 07:40:00	AAPL	Stock	16.1779	16.2018	16.1779	16.1811	207760.0
2012-01-25 07:45:00	AAPL	Stock	16.1864	16.1932	16.1696	16.1786	293664.0
2012-01-25 07:50:00	AAPL	Stock	16.1782	16.1875	16.1732	16.1854	410648.0
2012-01-25 07:55:00	AAPL	Stock	16.1786	16.2243	16.1786	16.2054	531188.0
2012-01-25 08:00:00	AAPL	Stock	16.1986	16.2079	16.1321	16.1929	1325352.0
2012-01-25 08:05:00	AAPL	Stock	16.1943	16.1943	16.125	16.1346	1923768.0
2012-01-25 08:10:00	AAPL	Stock	16.1396	16.15	16.1261	16.1264	804412.0
2012-01-25 08:15:00	AAPL	Stock	16.125	16.1821	16.125	16.1818	900508.0
2012-01-25 08:20:00	AAPL	Stock	16.1807	16.22	16.1786	16.2071	2142392.0
2012-01-25 08:25:00	AAPL	Stock	16.2054	16.2314	16.2036	16.2282	1284948.0
2012-01-25 08:30:00	AAPL	Stock	16.2282	16.2571	16.2232	16.2571	2830100.0
2012-01-25 08:35:00	AAPL	Stock	16.2571	16.2786	16.2496	16.2768	1266216.0

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

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